asked on

Access Error: ODBC Call Failed: Data source name was not found and no default drivers specified (#0)

User is first going into Control Panel and creating a new System DSN connection to the SQL instance in question. User has proper permissions on the SQL instance/database in question.

He gets this message when he opens a new Access Database, right clicks, selects "Link Table" and selects ODBC as the file type, then selects the System DSN he set up. When setting up the System DSN it said "Test Completed Successfully" so I don't understand why he's getting this message.

Thanks for any ideas.

dqmq

One thought that comes to mind is there is a corrupt USER DSN (or artifacts of it) by the same name. Check the USER tab of the ODBC control panel. For grins, try using a different DSN name.

synapse88

ASKER

I've already tried that and it was no help :(

ASKER CERTIFIED SOLUTION

LukeB

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

LukeB

PS: with the second one you can omit the Trusted_Connection line to begin with, SQLServer will pop that up if the user is known or if you do not have iintegrated SQLServer login enabled on the server.

Even if the user is not include in SQLServer ACL then the SQLServer login prompt will come up, I just tried the updated system on one of the users that had problems before and now they can connect to the SQLServer, I just need to give them a log in

good luck

LukeB

PPS: and see PAQ /Q_23396055.html, that tweaked me to try gong to the user's machines and ttrying that way.