I'm trying to use ODBC to connect to my SQL Server but I'm getting error messages from the ODBC driver.
I have 6 PCs in the development environment. Out of these, 2 can run without any problems. The other 4 have problems connecting to the server.
1. Cannot connect to server. These PCs initially couldn't and we resorted to upgrading the SQL Server ODBC driver to version 3.5++ and it worked after that but yesterday we couldn't connect again. I doubt its the driver because the two PCs that are working fine are using older versions of the driver (version 2.65++). The error message for this situation is:
SQL Server Error: 5
[Microsoft][ODBC SQL Server Driver][dbnmpntw]ConnectionOpen (CreateFile())
SQL Server Error: 2
[Microsoft][ODBC SQL Server Driver][dbnmpntw]Access Denied.
2. Specified SQL Server Not Found. This PC was not upgraded at all (The ODBC Driver) It is identical with one of the PCs that's running fine in terms of ODBC setup. The SQL Server ODBC driver version is identical to the two PCs that's running fine.
However, when we run the application, the SQL Server Login window will appear requesting for User and Password although it has been included as parameters in the OpenConnection statement. (I assume it's because it assumes that our password is incorrect, although it is correct). When I re-enter the items requested, I will get the following message:
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][DBNMPNTW]ConnectionOpen (CreateFile())
SQL Server Error: 6
[Microsoft][ODBC SQL Server Driver][DBNMPNTW]Specified SQL server not found
All the PCs have the same configuration in terms of ODBC so I can't figure out why I'm getting different result on different terminals.
I've tried everything I can think of and I still can't come up with anything. Any suggestions would be deeply appreciated. Please help me.
Thanks in advance.