Date sent: Tue, 13 Feb 2001 00:46:51 -0500
From: Thomas A.Lowery <[EMAIL PROTECTED]>
To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
Subject: Re: MS Access System Resource Exceeded Error
Hi interested,
on my system, I killed the script below using DBD::ODBC after 2 hours
(approx 25000 connects/disconnects). As far as I can guess from the
output of msinfo.exe, system resources do not decrease over time.
I am using a Pentium 166 MMX, 64 MB RAM, win95B, IE 5.5, Access 97,
my current Perl installation is completely from the latest ActiveState CD release, (I
think it is built 620, Perl version 5.6.0, DBI version 1.14, DBD::ODBC version 0.28)
exclusively using ppm for module installation.
not too sure that this helps, but hope so
Bodo
[EMAIL PROTECTED]
> > Any ideas?
>
> then don't do that.... <smile>
>
> At what number does it fail? (now switching to NT machine.
>
> Using DBD::ODBC, my fails at 109 connections with a connect error.
> However, when I change to DBD::ADO, well I killed the script at almost
> two hours. There does look like a small memory leak. When I started
> the script it consumed around 7 meg, after 2 hours around 20 meg.
>
> Not sure where to go from here.
>
> Tom
>
> On Sun, Feb 11, 2001 at 11:52:51AM -0800, Dave Hinkle wrote:
> >
> > I get the following error after connecting and disconnecting many times to
> > an Access DB from perl:
> >
> > DBI->connect(djhtest) failed: [Microsoft][ODBC Microsoft Access Driver]
> > System resource exceeded.
> > (SQL-S1001)(DBD: db_login/SQLConnect err=-1) at F:\TEMP\djh\b.pl line 10
> >
> > The code is as follows:
> >
> > use DBI;
> > use strict;
> >
> > my $i;
> >
> > while(1) {
> > my $dbh;
> > $dbh=DBI->connect("dbi:ODBC:djhtest");
> > $dbh->disconnect();
> >
> > $i++;
> > print "\nCount=$i\n";;
> > }
> >
> > The above code is just used to quickly recreate the error, but I will be
> > doing many connects/disconnects to access DB over time, which fails after a
> > while.
> >
> > I'm using ActiveState Perl build 620, DBI 1.14, DBD-ODBC v.28, MDAC v2.5, NT
> > 4.0 SP6.
>
> --
> Thomas A. Lowery [EMAIL PROTECTED]
> http://tlowery.hypermart.net
>
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>
