View source for 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,

:<code>[[DbQuery]]("DSN=CAPlantDB","SELECT * FROM Plants")</code>

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
:<code>C:\Windows\System32\odbcad32.exe</code>
and the 32-bit is at
:<code>C:\Windows\SysWow64\odbcad32.exe</code>

= See Also =

* [[DbQuery]], [[DbWrite]]
* Analytica User Guide, Chapter 23 (Analytica Enterprise), "Accessing Databases" section.