• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1489
  • Last Modified:

ODBC--Connection to 'DataSourceName' failed.

Good afternoon expert,

We have an Access database which is linked to
a MS SQL Server databse. The application works
fine for every one except a new user. When she brings up the application, when she submits he user name and password she gets
ODBC--Connection to 'DataSourceName' failed.
This error message is followed by another error message:
Microsoft Access cannot open the table in Datasheet view.
I have checked her ODBC connection in Control Panel
Administrative Tools Datasources (ODBC) and made sure that there is a System DNS exactly like the other users. There is a permission granted to all the users
in her Domain to the SQL server database but I went ahead and added her specifically. Still the same message.
Any ideas how to troubleshoot this?

Thanks.

Allen in Dallas
 

0
Allen Pitts
Asked:
Allen Pitts
1 Solution
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
(Knee-jerk, Help Desk-like comment) Did you destroy and re-create the linked table, and try again?
0
 
Jokra_the_BarbarianCommented:
1. If you create a new DSN in the ODBC Manager (on her machine) using her NT credentials, does it connect?
2. Could be problem with MDAC version on her machine.
3. Experience a problem once with ODBC registry entry.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now