Error trying to connect MS Access 2003 to SQL Server 2005

Posted on 2008-10-02
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?
Question by:BFulford
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
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.

Author Comment

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.
LVL 38

Expert Comment

by:Jim P.
ID: 22633556
Can we see the connect string?
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.


Author Comment

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.
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.

Accepted Solution

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.

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
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…

734 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