Home > Archive > LDAP > December 2006 > OLE exception - table does not exist
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
OLE exception - table does not exist
|
|
| bubslg 2006-12-11, 7:30 pm |
| 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??
| |
| Peter Marschall 2006-12-11, 7:30 pm |
| Hi,
On Friday, 8. December 2006 01:17, bubslg wrote:
> 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??
Your posting is off-topic for this mailing list.
This list is about perl-ldap, the package that provides
Perl::LDAP and related modules.
Regards
PEter
--
Peter Marschall
peter@adpm.de
|
|
|
|
|