LuckyLucks
asked on
user dsn tests successfully but datasource specified does not exist
Hi:
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\odbcad 32.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)
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\odbcad
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)
ASKER
Its in the right place. Used below to verify:
%systemdrive%\Windows\SysW oW64\Odbca d32.exe
%systemdrive%\Windows\SysW
Sorry, yes did specify that. "Datasource you specified does not exist." sounds like your app is not referring to the Datasource properly.
A user dsn is only visible to the user who created that dsn. A system dsn is visible to all users on that machine.
https://support.microsoft.com/en-us/kb/966915
Did you launch the app using the same user account you created the USER DSN with? If not then that's a problem.
A user dsn is only visible to the user who created that dsn. A system dsn is visible to all users on that machine.
https://support.microsoft.com/en-us/kb/966915
Did you launch the app using the same user account you created the USER DSN with? If not then that's a problem.
ASKER
Yes, with the same account. I logged on to the server, created it in ODBC exe and then launched the app with my account again.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Create a 32-bit DSN on 64-bit machine for SQL Server: https://www.mssqltips.com/sqlservertip/2498/create-a-32bit-dsn-on-64bit-machine-for-sql-server/