SQL SERVER connection

Developers Databases
#1

I want to connect to MS.SQL SERVER 2008R2 in the database connection menu, using DBMS driver - MS SQL SERVER NATIVE SRV, but the error said that it’s SQL SERVER 2000 ?

Connection Error

SQLState: 08001 Error Code: 22 Message: [Microsoft][ODBC Driver 13 for SQL Server]ODBC Driver 13 for SQL Server does not support connections to SQL Server 2000 or earlier versions. SQLState: 08001 Error Code: 22 Message: [Microsoft][ODBC Driver 13 for SQL Server]Client unable to establish connection SQLState: 08001 Error Code: 22 Message: [Microsoft][ODBC Driver 13 for SQL Server]ODBC Driver 13 for SQL Server does not support connections to SQL Server 2000 or earlier versions. SQLState: 08001 Error Code: 22 Message: [Microsoft][ODBC Driver 13 for SQL Server]Client unable to establish connection

Is it a bug or wrong detection ?

Any idea to solve this ?

Thanks

#2

As I read it, you have installed the wrong ODBC driver. This error comes out of your eco system, not Scritpcase imho…

#3

I have installed the ODBC driver 13 with SDK, it works well with other applications

What is the driver version that can fix with scriptcase ?

#4

Please do check if you use the 32 or 64 bit version. If you use the 32 bit version do check that all dependancies are working. The program is here:
in case of count (on windows) grab a program called depends and run it.
https://www.dependencywalker.com/
It has helped me out many times when dependancies were not complete (on windows!).
On linux you can use http://sourceforge.net/projects/binscan or ELF Library Viewer