Solved

ODBC connection failures with MS Access

Posted on 2004-09-16
4
391 Views
Last Modified: 2012-06-22
I have a sql (2000) server called Numbers in the network and the ip address of 192.168.0.95. The server instance is called NUMBERS\BKUPEXEC, and thers a database called VIS_PRD that was created earlier this morning.

Im trying to configure one of the client machines to connect to this server via a user and/or system instance created in thier ODBC Data Sources. Couple of things that I notice when I attempt the connection

The server name NUMBERS or NUMBER/BKUPEXEC do not appear as a server option on the server pulldown (as if the ODBC Data Source Administrator) is not able to resolve to it and find it by default

I manually entered the server instance in (NUMBERS/BKUPEXEC) and tried authenticating using both NT and SQL authentication and I keep getting the following error

Connection failed: SQLState: '0100' SQL Server Error:53....ConnectionOpen (CreateFile()) Connection failed..

What could I be doing wrong?

-Frustrated with SQL now
0
Comment
Question by:nanohurtz
  • 2
4 Comments
 
LVL 41

Accepted Solution

by:
shanesuebsahakarn earned 300 total points
ID: 12074787
0
 
LVL 36

Expert Comment

by:SidFishes
ID: 12074819
i agree with shane...almost certainly due to outdated mdac...but also make sure you have installed the latest jet sp's
0
 

Author Comment

by:nanohurtz
ID: 12075697
Yay!!! Thanks, that seemed to have worked very well..

The issue I'm having now is that some of the tables that I uploaded to the server contained indexes set to automatically increment (autonumbers). They are no longer incrementing as they should in sql2000. Is there some sort of a script or configuration that I must make to have my indexes increment as they did before in ms access?
0
 

Author Comment

by:nanohurtz
ID: 12075873
Fixed
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
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…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

789 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