Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

access and sql server 2000

Status
Not open for further replies.
manny1234

manny1234

IS-IT--Management
Mar 13, 2006
58
US
I am using an access db to connect to a sql server. All of my work stations work fine with the same copy of the access db that I am using on this pc. On this PC I get

Code: 
Connection failed:
SQLState: '0100'
SQL Server Error: 2
[Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen(Connect()).
Connection Failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC Sql Server Driver][DBMSLPCN]SQL Server does not exist or access denied.
The user I am logged in has rights to the SQL server and they were able to connect on a different pc.
I can create a successful file dsn and test it which leads me to believe I have a good connection to the SQL server from this pc....

I am pulling my hair out on this...
 
Status
Not open for further replies.

Similar threads

datajockey123
  • Locked
  • Question
Note / Information box with date and time stamp for each entery
Replies
2
Views
324
dhookom
dhookom
Swi
  • Locked
  • Question
Jet Sql Statement - Select Distinct Multiple Columns 1
Replies
4
Views
343
Swi
Swi
lameid
  • Locked
  • Question
SELECT FROM Table in Another Access File
Replies
2
Views
650
lameid
lameid
JK Dutta
  • Locked
  • Question
requet for form an access query for report
Replies
2
Views
637
dhookom
dhookom
monkeysee
  • Locked
  • Question
Automatic Invoicing in Access 1
Replies
6
Views
196
monkeysee
monkeysee

Part and Inventory Search

Sponsor

Back
Top