OK, I've got this chunk of code that is importing a bunch of user data
into SQL. Part of the process is to pull some user infromation from
active directory. This prcess works fine for 12,000 to 16,000
iterations, then I get this:
OLE exception from "Provider":
Table does not exist.
Win32::OLE(0.1601) error 0x80040e37
in METHOD/PROPERTYGET "Execute" at import.pl line 91
The offending line of code is:
my $objRS = $objConn->Execute($strBase . $strFilter . $strAttrs .
$strScope);
The block of code this comes from:
$Win32::OLE::Warn = 3;
my $objConn = Win32::OLE->CreateObject("ADODB.Connection");
$objConn->{Provider} = "ADsDSOObject";
$objConn->Open;
my $objRS = $objConn->Execute($strBase . $strFilter . $strAttrs .
$strScope);
I'm thinking I must be running into some type of connection limit, but
can't get past it. I've even added an $obRS->Close and
$objConn->close, but that hasn't helped. Any ideas??