Access Error: ODBC Call Failed: Data source name was not found and no default drivers specified (#0)
Posted on 2008-10-06
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.