To view full details, sign in with your My Oracle Support account. |
Don't have a My Oracle Support account? Click to get started! |
Symptoms |
Changes |
Cause |
Solution |
References |
%systemdrive%WindowsSysWoW64
folder.%systemdrive%WindowsSystem32
folder.SQLDataSources
function returns all versions of user DSNs, regardless of the architecture of the application. 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. 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. 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:SQLDataSources
function that is called in a 64-bit application returns this 32-bit user DSN. However, if you make a connection through this 32-bit user DSN, you receive the error message that is mentioned earlier in this section.HKEY_CURRENT_USERSoftwareODBCODBC.INI
%windir%SysWOW64odbcad32
.exe. To indicate the type of DSN, you can add '_32' to the 32-bit user DSNs and '_64' to the 64-bit user DSNs.HKEY_LOCAL_MACHINESoftwareODBCODBC.INI
HKEY_CURRENT_USERSoftwareODBCODBC.INI