Example error message
IM002:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.
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.
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
and the 32-bit is at