Any MSSQL Server Native SRV PDO Fails with Error on Scriptcase 9

Any MSSQL Server Native SRV PDO Fails with

[SIZE=12px]Connection Error[/SIZE]

[SIZE=12px]Fatal error: Invalid handle returned. in C:\Program Files\NetMake\v9\wwwroot\scriptcase\prod hird\adodb\drivers\adodb-pdo.inc.php on line 126[/SIZE]

Hi,
I had a same problem that I resolved by two ways,

  1. Installing the ODBC driver (http://127.0.0.1:8090/scriptcase/doc/manual_mp/manual/05-scriptcase-connections/10-mssql/02-sqlserver-windows/)
  2. Updating Scriptcase.

Regards,
Rozmi

Hi,
I had a same problem that I resolved by two ways,

  1. Installing the ODBC driver (http://127.0.0.1:8090/scriptcase/doc/manual_mp/manual/05-scriptcase-connections/10-mssql/02-sqlserver-windows/)
  2. Updating Scriptcase.

Regards,
Rozmi

Scriptcase 9 right? And using 32 or 64 bit ODBC?

Scrptcase 9 support 32 bit and 64 bit, if you installed SC9 64 bit then install ODBC 64 bit.

In my case I’m using SC9 64 bit and certainly the ODBC 64bit as well.

Hello,

Please, let us know if the problem persists using scriptcase and driver with the same architecture as recommended above.

If persists, send the diagnosis of their environment by accessing the menu Help -> Diagnosis.
So, Click the link generated at the top of the page and save it as .HTML.

I have installed the Microsoft ODBC Driver 11 for SQL Server, and cannot connect with NATIVE SRV or NATIVE SRV PDO, but available with ODBC

My database is MS SQL SERVER 2008R2 , but the error is :

Connection Error

Connection attempt failed: SQLSTATE[08001]: [Microsoft][ODBC Driver 11 for SQL Server]ODBC Driver 11 for SQL Server does not support connections to SQL Server 2000 or earlier versions.

Is it detect the wrong version ?