12/5/2023 0 Comments Windows odbc manager![]() You can use the 32-bit ODBC Administrator tool to manage user DSNs and system DSNs that are used by WOW64 processes. You must directly invoke the 32-bit ODBC Administrator tool from the SysWoW64 folder. On a 64-bit operating system, the 32-bit ODBC Administrator tool is used for Windows on Windows 64 (WOW64) processes. The 64-bit ODBC Administrator tool can be invoked from Control Panel to manage user DSNs and system DSNs that are used by 64-bit processes. To indicate the type of DSN, you can add '_32' to the 32-bit user DSNs and '_64' to the 64-bit user DSNs. If you build and then run an application as a 32-bit application on a 64-bit operating system, you need to use the %windir%\SysWOW64\odbcad32.exe ODBC Administrator tool to create the ODBC data source. To work around this problem, use the appropriate version of the ODBC Administrator tool. To maintain backward compatibility, no resolution for this problem is currently available. Therefore, user DSNs are visible in both the 32-bit and 64-bit versions of the ODBC Administrator tool. Registry redirection isn't enabled for this registry subkey. The user DSNs are stored under the following registry subkey: ![]() However, if you make a connection through this 32-bit user DSN, you receive the error message that is mentioned earlier in this section. The SQLDataSources function that is called in a 64-bit application returns this 32-bit user DSN. This driver doesn't have a corresponding 64-bit version. You create a user DSN for the 32-bit driver 'Microsoft Access Driver (*.mdb)'. Therefore, if the application makes a connection by using a user DSN that is returned from the SQLDataSources function, you may receive the following error message:ĭata source name not found and no default driver specifiedįor example, consider the following scenario. Similarly, the SQLDataSources function that is called in a 64-bit application returns only system DSNs for 64-bit drivers but returns user DSNs for both 32-bit drivers and 64-bit drivers. The SQLDataSources function that is called in a 32-bit application returns only system DSNs for 32-bit drivers but returns user DSNs for both 32-bit drivers and 64-bit drivers. The SQLDataSources function returns all versions of user DSNs, regardless of the architecture of the application. The 64-bit version of the ODBC Administrator tool displays 64-bit system DSNs, 32-bit user DSNs, and 64-bit user DSNs. The 32-bit version of the ODBC Administrator tool displays 32-bit system DSNs, 32-bit user DSNs, and 64-bit user DSNs. The Odbcad32.exe file displays the following types of data source names (DSNs): The 64-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\SysWoW64 folder.The 32-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\System32 folder.Original product version: SQL Server Original KB number: 942976 SymptomsĪ 64-bit version of the Microsoft Windows operating system includes the following versions of the ODBC Data Source Administrator tool ( Odbcad32.exe): This article provides workaround for the problem that occurs in the ODBC Data Source Administrator tool.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |