000012227 - ODBC DSN issue - Data source name not found and no default driver specified

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000012227
Applies ToThis 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.

RSA enVision
IssueTo 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"

ResolutionTo 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 IDa64309

Attachments

    Outcomes