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.
Microsoft excel odbc for windows 7 32 bit drivers#
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 kommentar(er)
