No connection to the database when using ODBC

%3CLINGO-SUB%20id%3D%22lingo-sub-2594912%22%20slang%3D%22en-US%22%3ENo%20connection%20to%20the%20database%20when%20using%20ODBC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2594912%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20an%20Access%20application%20with%205%20users%2C%20an%20ODBC%20is%20set%20up%20locally%20as%20a%20System%20DSN%20for%20each%20user.%20Since%20yesterday%2C%20one%20of%20the%20users%20got%20the%20message%20%22No%20connection%20to%20the%20database%22.%20All%20other%20users%20could%20continue%20working%20normally.%3CBR%20%2F%3EThe%20existing%20ODBC%20could%20no%20longer%20be%20edited%2C%20not%20even%20as%20an%20administrator.%3CBR%20%2F%3EI%20created%20a%20new%20DSN%20user%20already%2C%20but%20it%20doesn't%20work.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2594912%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2596162%22%20slang%3D%22en-US%22%3ERe%3A%20No%20connection%20to%20the%20database%20when%20using%20ODBC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2596162%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F331904%22%20target%3D%22_blank%22%3E%40AtanasM%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3E%22%3CSPAN%3ECan%20you%20log%20into%20the%20server%20from%20this%20user's%20computer%20with%20your%20own%20login%3F%20%3CSTRONG%3E%3CEM%3ENo%3C%2FEM%3E%3C%2FSTRONG%3E%22%20%5Bemphasis%20added%5D%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CBR%20%2F%3EThat%20suggests%20the%20problem%20is%20NOT%20the%20DSN.%20That%20suggests%20the%20problem%20is%20with%20the%20connection%20between%20that%20computer%20and%20the%20server.%20I%20should%20have%20asked%20also%2C%20if%20this%20user%20can%20log%20in%20using%20their%20credentials%20from%20a%20different%20computer%20(that%20would%20help%20confirm%20the%20diagnosis).%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EIt%20could%20be%20a%20firewall%20problem%20on%20that%20computer%2C%20for%20example.%20If%20recent%20updates%20to%20the%20Windows%20OS%20were%20made%2C%20that%20could%20also%20be%20implicated.%20I%20think%20you%20need%20to%20focus%2C%20not%20on%20the%20DSN%20itself%2C%20but%20on%20the%20connectivity%20between%20that%20one%20computer%20and%20the%20database%20on%20the%20server.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2595875%22%20slang%3D%22en-US%22%3ERe%3A%20No%20connection%20to%20the%20database%20when%20using%20ODBC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2595875%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F46682%22%20target%3D%22_blank%22%3E%40George%20Hepworth%3C%2FA%3E%3CBR%20%2F%3EPlease%20check%20below%20the%20answers%3A%3CBR%20%2F%3EDoes%20the%20affected%20user%20have%20the%20same%20rights%20as%20other%20users%3F%20Yes%3CBR%20%2F%3EAre%20you%20using%20Windows%20Authentication%20or%20SQL%20Server%20Authentication%3F%20Windows%20authentication%3CBR%20%2F%3EIs%20the%20location%20of%20the%20server%20accessible%20to%20this%20user%20over%20the%20network%3F%20Yes%3CBR%20%2F%3ECan%20you%20log%20into%20the%20server%20from%20this%20user's%20computer%20with%20your%20own%20login%3F%20No%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2595022%22%20slang%3D%22en-US%22%3ERe%3A%20No%20connection%20to%20the%20database%20when%20using%20ODBC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2595022%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F331904%22%20target%3D%22_blank%22%3E%40AtanasM%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3EDoes%20this%20user%20have%20the%20same%20rights%20as%20other%20users%3F%3C%2FLI%3E%3CLI%3EAre%20you%20using%20Windows%20Authentication%20or%20SQL%20Server%20Authentication%3F%3C%2FLI%3E%3CLI%3EIs%20the%20location%20of%20the%20server%20accessible%20to%20this%20user%20via%20the%20network%3F%26nbsp%3B%3C%2FLI%3E%3CLI%3ECan%20you%20log%20on%20to%20the%20server%20from%20this%20user's%20computer%20using%20your%20own%20login%3F%3C%2FLI%3E%3C%2FUL%3E%3CP%3EThis%20kind%20of%20information%20can%20help%20find%20the%20problem....%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Frequent Contributor

In an Access application with 5 users, an ODBC is set up locally as a System DSN for each user. Since yesterday, one of the users got the message "No connection to the database". All other users could continue working normally.
The existing ODBC could no longer be edited, not even as an administrator.
I created a new DSN user already, but it doesn't work.

3 Replies

@AtanasM 

  • Does this user have the same rights as other users?
  • Are you using Windows Authentication or SQL Server Authentication?
  • Is the location of the server accessible to this user via the network? 
  • Can you log on to the server from this user's computer using your own login?

This kind of information can help find the problem....

 

@George Hepworth
Please check below the answers:
Does the affected user have the same rights as other users? Yes
Are you using Windows Authentication or SQL Server Authentication? Windows authentication
Is the location of the server accessible to this user over the network? Yes
Can you log into the server from this user's computer with your own login? No

@AtanasM 
"Can you log into the server from this user's computer with your own login? No" [emphasis added]


That suggests the problem is NOT the DSN. That suggests the problem is with the connection between that computer and the server. I should have asked also, if this user can log in using their credentials from a different computer (that would help confirm the diagnosis).

 

It could be a firewall problem on that computer, for example. If recent updates to the Windows OS were made, that could also be implicated. I think you need to focus, not on the DSN itself, but on the connectivity between that one computer and the database on the server.