BFulford
asked on
Error trying to connect MS Access 2003 to SQL Server 2005
We have an Access 2003 database that connects to SQL Server 2005 via ADO 2.5 fine on all the machines but one. When we try to open the ADO connection in VBA, an error occurs: ....
[microsoft][odbc sql server driver][dbnmpntw] Connection broken
Error number is -2147467259
This is a little odd and I can't find the reason for this disconnect. Suggestions?
[microsoft][odbc sql server driver][dbnmpntw] Connection broken
Error number is -2147467259
This is a little odd and I can't find the reason for this disconnect. Suggestions?
ASKER
We are not using a DSN to access the SQL Server. We use ADO to connect to SQL server specifying a connection string.
Can we see the connect string?
ASKER
ADO Connection String: driver={Sql Server}; server=dsi;database=agh; uid=dsi; password=pwd;
We tried adding Network=dbmssocn to the end but to no avail.
I am thinking it is SQL Server driver related.
We tried adding Network=dbmssocn to the end but to no avail.
I am thinking it is SQL Server driver related.
From a command prompt fire the cliconfg (Client Network Utility) and see what protocols are neabled and in what order.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If not then go into the the second page of the ODBC call and click on the Client configuration button.
Then select TCP/IP and configure from there.
ODBC-Page2.jpg
ODBC-Client-Configuration.jpg