Solved

Error trying to connect MS Access 2003 to SQL Server 2005

Posted on 2008-10-02
6
693 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.
Comment Utility
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
Comment Utility
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.
Comment Utility
Can we see the connect string?
0
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 

Author Comment

by:BFulford
Comment Utility
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.
Comment Utility
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
Comment Utility
The issue was with OLD sql drivers... The drivers were from 1999 and were not current for SQL 2005.
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

763 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now