It is first time connecting to Microsoft Access, and I cannot even make a
simple connection.
The database is running and connected to the web using dreamweaver.
But I need to write perl scripts to update it.
use DBI;
$dsn = qq(dbi:Microsoft Access
Driver:D\:\\\\Inetpub\\wwwroot\\temp\\doc_archive_test.mdb);
my $dbh = DBI->connect($dsn);
This is the error message:
Can't connect (dbi:Microsoft Access
Driver:d:\\Inetput\wwwroot\temp\doc_archive_test.mdb), no database driver
specified and DBI_DSN env var not set at <script name>.
Isn't the driver named "Microsoft Access Driver"
I know it is installed in the system DSN.
any help is appretiated.
Jorge Allen