> 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
