Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Error trying to connect MS Access 2003 to SQL Server 2005

Posted on 2008-10-02
6
Medium Priority
?
731 Views
Last Modified: 2012-05-05
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?
0
Comment
Question by:BFulford
  • 3
  • 3
6 Comments
 
LVL 38

Expert Comment

by:Jim P.
ID: 22628925
Are you using named pipes?

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
0
 

Author Comment

by:BFulford
ID: 22633213
We are not using a DSN to access the SQL Server. We use ADO to connect to SQL server specifying a connection string.
0
 
LVL 38

Expert Comment

by:Jim P.
ID: 22633556
Can we see the connect string?
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Author Comment

by:BFulford
ID: 22634657
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.
0
 
LVL 38

Expert Comment

by:Jim P.
ID: 22635694
From a command prompt fire the cliconfg (Client Network Utility) and see what protocols are neabled and in what order.
0
 

Accepted Solution

by:
BFulford earned 0 total points
ID: 22985597
The issue was with OLD sql drivers... The drivers were from 1999 and were not current for SQL 2005.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question