Solved

Error trying to connect MS Access 2003 to SQL Server 2005

Posted on 2008-10-02
6
703 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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

809 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