Cursor type changed, SQL state 01S02 in SQLExecute

[obrared2014]

Hi. first thanks for this tool. I have this error and not if I am missing something in the configuration:

not work: 1.-$db->select("exec dbo.s_cob_login 'username','password' "); error: [ODBC Driver 17 for SQL Server]Cursor type changed, SQL state 01S02 in SQLExecute.

this if it works: (esto si funciona ) 1.- DB::connection('odbc')->table('tbl_usuario')->where('username', 'username')->get() 2.- $db->select(" select * from tbl_users where ...")

	'odbc' => [
		'driver' => 'odbc',
		'dsn' => 'testodbc1',
		'database' => env('DB_SCJ_DATABASE'),
		'host' => env('DB_SCJ_HOST'),
		'username' => 'xxxxx',
		'password' => 'xxxx'

gracias.

[Enrica-r]

Laravel supports MSSQL Server directly with database driver 'driver' => 'sqlsrv'. This ensures that query and schema grammar is correctly translated MSSSQL.