0x80040E37 error during an ldap query 1

[w1nd]

Hello,
I'm making a script finding out if the mailbox size quotas are bigger than defaults. It says to me it's error 0x80040E37 - table does not exist. I want to find all private mailox stores that exist on the server and then, using the homeMDBBL property, iterate through their mailboxes and estimate their storage limits.
I'm using VBS. The script is run on the server.
My script (the "wrong" part of it):

Set objConn = CreateObject("ADODB.Connection")
objConn.Provider = "ADsDSOObject"
objConn.Open "Active Directory Provider"
Set objCommand = CreateObject("ADODB.Command")
Set objCommand.ActiveConnection = objConn
Set objRoot = GetObject("LDAP://myserver/RootDSE")
strNameContext = objRoot.Get("ConfigurationNamingContext")
strQuery = "<" & strNameContext & ">;(objectClass=msExchPrivateMDB);homeMDBBL;subTree"
objCommand.Commandtext = strQuery
objRecordSet = objCommand.Execute

I suppose there's something wrong with my rights, though I'm a local admin on the server.

PS. I DO know there was a similar thread on this forum about ASP, but it didn't really help me.
PPS. Yes, I AM a newb

 

[tsuji]

>[tt]strQuery = "<" & strNameContext & ">;(objectClass=msExchPrivateMDB);homeMDBBL;subTree"[/tt]
Try this instead.
[tt]strQuery = "<LDAP://" & strNameContext & ">;(objectCategory=msExchPrivateMDB);homeMDBBL;subTree"
[/tt]

 

[w1nd]

Didn't help, but thank you anyway

 

[tsuji]

>Didn't help
Thanks for the feedback. Are you saying you do not need LDAP:// protocol explicitly shown in your query string? It is nowhere in the strNameContext the way you retrieve it.

http://msdn.microsoft.com/library/d...ode_for_locating_the_partitions_container.asp

 

[w1nd]

I've added the LDAP:// part to the query string. That's what the debugger says about its content:
strQuery
<LDAP://CN=Configuration,DC=e2kdewdfe1y,DC=sap,DC=corp>;(objectClass=msExchPrivateMDB);homeMDBBL;subTree

 

[tsuji]

okay, at least members can see what you actually are working on with.

 

[w1nd]

I've got it!!! A colleague helped me.
It should be
strQuery = "<LDAP://myserver" & strNameContext & ">;(objectCategory=msExchPrivateMDB);homeMDBBL;subTree

 

[tsuji]

>[tt]strQuery = "<LDAP://myserver" & strNameContext & ">;(objectCategory=msExchPrivateMDB);homeMDBBL;subTree"[/tt]
[tt]strQuery = "<LDAP://myserver[red]/[/red]" & strNameContext & ">;(objectCategory=msExchPrivateMDB);homeMDBBL;subTree"[/tt]

 

[w1nd]

That's what I've wanted to say. Anyway, thank you!!

 

[tsuji]

Thanks w1nd for the good spirit and feedback. I know that's what you were intended to tell the forum. I too make typos all the time. It is just for the general audience. Thanks!