ODBC Error: Data Source name Not Found and No Default Driver Specified

R

Rich Wallach

Eric,
When you query an external database you need to set up and
ODBC data source name (DSN). This allows your query to
connect to the data source. You'll need the ODBC driver
for the type of database your connecting to. (e.g. Access).
Most likely this driver already exists on your system.

To configure a DSN, go to Control Panel, then
Administrative Tools, then Data Sources ODBC. Then:
1) Click the Add butoon
2) Select the driver for the database you're using
3) Name and configure the DSN (different for each db type)

When you create the query you'll need to select the DSN
you created to establish the connection between the query
and the database.
Hope that helps,
Rich
 
Top