Error Messages/43140


Example error message

IM002:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.

Cause

This error is issued by the ODBC driver in Windows. This error may occur when DbQuery or DbWrite is evaluated with a DSN that is not configured. For example,

DbQuery("DSN = CAPlantDB","SELECT * FROM Plants")

If you don't have a data source named CAPlantDB configured on your computer, then this error will occur.

Remedy

In the Windows start menu search box, type "Data Sources (ODBC)" and run the matching program. This should bring up the ODBC Data Source Administrator dialog. Click the System tab and if your database is not listed (e.g., CAPlantDB in the example), press the Add... button to add and configure it.

32-bit vs. 64-bit

If you are using 64-bit Analytica, you need to run the 64-bit version of "Data Sources (ODBC)". If you are running 32-bit Analytica, you need to run the 32-bit "Data Sources (ODBC)". Windows treats these as totally separate configurations, so if you define the 32-bit data source but run 64-bit Analytica, it is as if the data source is not defined.

On 64-bit Windows, the 64-bit "Data Sources (ODBC)" is this program

C:\Windows\System32\odbcad32.exe

and the 32-bit is at

C:\Windows\SysWow64\odbcad32.exe

See Also

Comments


You are not allowed to post comments.