in reply to Trouble with accessing MS Access database via Perl on web host........

Hello,

This should do the trick - you'll need to make sure that the Data Source points to the database on your site. It's using OLE (probably should use Win32::OLE, but I am adapting some old code).
use strict; use OLE; my $dbh; $dbh = CreateObject OLE "ADODB.Connection" or die "Can't create connec +tion to DataBase: $!" unless $dbh; $dbh->Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=\\_private\\ +db1.mdb"); my $sql = "SELECT email, password FROM surya"; my $rs = $dbh->Execute($sql); while (!$rs->EOF()) { print $rs->Fields('email')->Value . " " . $rs->Fields('password')- +>Value . "\n"; $rs->MoveNext; } $dbh->Close();
Update: The "Open" string above is using the Access 2000 driver installed with ADO 2.5, you can substitute that line for :
$dbh->Open("Driver={Microsoft Access Driver (*.mdb)};DBQ=\\_private\\d +b1.mdb");