----- Original Message -----
From: Jorge L. Allen <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, May 14, 2001 11:34 PM
Subject: Using perl to connec to ACCESS
>
> 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"
As far as i recall there is no DBI driver called DBD::Microsoft Access
Driver
Maybe you want to use DBD::ADO or DBD::ODBC.
See the fine manual on DBI and DBD.
Greetings,
Maarten.
