WinSQL » Knowledge base

Document information

Document ID:2084
Subject:I don't see my datasources in WinSQL
Creation date:6/7/12 6:01 AM
Last modified on:6/7/12 7:00 AM


Datasource visible through Control Panel, but not in WinSQL

Question: You are using WinSQL on a 64-bit machine? If yes, make sure you invoke the ODBC manager from WinSQL. Click "ODBCMgr" button in the connection Window or "Open ODBC Manager" under File menu.

There are two ODBC managers on a 64-bit machine. One for 32-bit and other for 64-bit. When you use Control Panel to open the manager, you will most likely see the 64-bit version. Therefore, it is important you invoke the manager from WinSQL.

Since WinSQL is a 32-bit program, you can only use a 32-bit driver in WinSQL.


The executable name for ODBC Manager is Odbcad32.exe.
  • The 32-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\SysWoW64 folder.
  • The 64-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\System32 folder.

I see both 32 and 64 bit data sources in WinSQL, why?

When registry redirection is not enabled, the OS will display both 64-bit and 32-bit datasources regardless of the program. However, WinSQL will only be able to connect to 32-bit drivers. Check here for more information about registry redirection.

Related article.





Add a comment to this document

Do you have a helpful tip related to this document that you'd like to share with other users? Please add it below. Your name and tip will appear at the end of the document text.
Your name:
Your email:
Hide my email address
Verification code:
Enter the verification code you see above more submitting your tip
Tip:Please limit tips to 1000 characters

Navigation

Social Media

Powered by 10MinutesWeb.com