Hi,
I am running perl 5 on a win2K server machine. I
am connecting to an Access database via DBI as follows
my $DSN = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=$path/database.mdb";
#my $DSN = "databasedsn";
#print $DSN;
my $dbh = DBI->connect("dbi:ADO:$DSN",'','') or die "$DBI::errstr\n";
if, instead of the explicit reference to the Jet database driver I use
the commented dsn "databasedsn" which points to the same database, my
performance drops by a factor of 10. Meaning that it takes forever for
any database actions to return. SELECT, INSERT doesn't matter they
take a ridiculously long time. Any ideas why this is happening? I
am using access 2000 and the DSN is a system dsn if that makes any
difference. The machine is a dual processor, 1Ghz, 512 MB ram, 18GB
(about 5GB free) and it is hardly being worked so hardware is not an
issue. The script is being called by IIS and is a .pl not .plx so it
is not using ISAPI (I think?).
thanks,
andrew
