I have created a User DSN on a Windows 2012 server that connects to a database MS SQL2012 on another Windows 2012 server.
On the first windows 2012 box, which contains the application, I set a connection string to the db (windows integrated) under the User DSN tab. I am using the C:\Windows\SysWow64\odbcad32.exe (note application using the db is 32 bits), . On Test connectivity it is successful. When I go to my application and log in using this User DSN I get the error:
Datasource you specified does not exist. !!!
Note: I have also created System DSN with the same specs and this works fine both on test connectivity and through the app. Can someone tell me why a user dsn on test connectivity through odbc works but may not be working through the app? (App is on the first Windows 2012 box where odbc was being set up)