ODBC question

[andreis]

Hi:
We can't connect to SQL Server 7 with the message:
'A connection couldn't be established - SQL Server doesn't exists or access denied.
ConnectionOpen(Connect())
The driver returned invalid (or failed to return)
SQL_DRIVER_ODBC_VER:03.52'

Remote connections to the Server work fine. All DB are functional.
Reinstalling SQLServer 7 didn't help.
Any ideas what way to proceed?
Thanks in advance.
Andrei

 

[StevenK]

Is it the case that you're connecting from a client machine to a server where SQL Server is installed (or a different machine). If so it would be worth checking that the user logged onto the client machine is able to view the physical drive on which SQL Server sits. Is the SQL Server registered on the local client machine ?
Steve

 

[andreis]

Steve, thanks, funny enough, this is a different case: we try to connect from the server to the SQL Server itself, located on the same machine. From clients, the connection is fine.
Andrei

 

[foxdev]

Just a WAG: could it be that you are set to use TCP/IP as shown in the Client Network Utility? IOW, using the TCP/IP protocol to connect to yourself? If so, try using Named Pipes. Robert Bradley
Sr. DBA, some big company
cheap prints and oil paintings:

http://www.lowcostprints.com

 

[andreis]

Steve and Robert, thanks you for you help, it turned out that sqlsrv32.dll in our system for some reason had wrong version. After we replaced it, the problem was gone.
Andrei