Aug 21, 2000, 10:29 PM
Post #2 of 2
<BLOCKQUOTE><font size="1" face="Arial,Helvetica,sans serif">quote:</font><HR>data source name not found<HR></BLOCKQUOTE>
Re: Help in connecting to the database using DBI
[In reply to]
You didn't configure Windows to recognize db1.mdb as a valid datasource in Control Panel -> ODBC Data Source -> System DSNs (hint: you may not have called your DSN the same as the filename).
<BLOCKQUOTE><font size="1" face="Arial,Helvetica,sans serif">quote:</font><HR>and no default driver specified<HR></BLOCKQUOTE>
Since db1.mdb isn't a DSN, it must be a file, but you didn't tell DBD::ODBC which driver to use to read that file so it has no idea whether its really an Access db, an Excel spreadsheet, or something else entirely.
So your options are ...
Set a DSN, and connect to that.
See the DBD::ODBC documentation for explicit details on how to connect to an Access database w/o setting a DSN.
[This message has been edited by Kanji (edited 08-22-2000).]