|Applies To||This issue can most likely happen on the enVision appliances where the shortcut for "Data Sources (32-bit)" is not available readily under "Administrative tools" left over with "Data Sources" or "Data Sources (64-bit)".|
As the NIC ODBC service is a 32-bit one, it is compulsory to have the DSN created using the 'Data Sources (32-bit)". But in cases where this shortcut is unavailable, there are chances User may consider "Data Sources" as 32-bit one and configuring the DSN through it.
This results in the above ODBC error.
|Issue||To fix the "Data source name not found and no default driver specified" error which comes in the NIC ODBC messages|
Actual error is as below,
Error "ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"
|Resolution||To fix the issue, please keep in mind on the 32-bit Data Sources executable and configure through it.|
ODBC DSN Versions
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
|Legacy Article ID||a64309|