ok, i'm at wits end here
i am trying to query exchange server using like, however i receive "Could not complete operation due to error 80041024"
this is the code that has the error:
every google query i came upon when using the like statement and WQL(sql subset) needs to be xp...i have xp pro and server is 2003....i am totally lost as this code is presented everywhere but i am having problems tracking down the mistake...please advise...i'm going nuts
code that does work with where statement but w/o like
i am trying to query exchange server using like, however i receive "Could not complete operation due to error 80041024"
this is the code that has the error:
Code:
Set SWbemLocator = CreateObject("WbemScripting.SWBemlocator")
Set objWMIService = SWBemlocator.ConnectServer _
("excchangeserver123", "root\MicrosoftExchangeV2","Domain\admin","123456789")
Set colItems = objWMIService.ExecQuery("SELECT * FROM Exchange_Mailbox WHERE MailBoxDisplayName LIKE 'joe*'")
for each objItem in colItems
sResults = sResults & objItem.MailboxDisplayName & " " & objItem.StoreName & "<br>"
next
results.innerhtml = sResults
every google query i came upon when using the like statement and WQL(sql subset) needs to be xp...i have xp pro and server is 2003....i am totally lost as this code is presented everywhere but i am having problems tracking down the mistake...please advise...i'm going nuts
code that does work with where statement but w/o like
Code:
Set SWbemLocator = CreateObject("WbemScripting.SWBemlocator")
Set objWMIService = SWBemlocator.ConnectServer _
("excchangeserver123", "root\MicrosoftExchangeV2","Domain\admin","123456789")
Set colItems = objWMIService.ExecQuery("SELECT * FROM Exchange_Mailbox WHERE ServerName = 'joe'")
for each objItem in colItems
sResults = sResults & objItem.MailboxDisplayName & " " & objItem.StoreName & "<br>"
next
results.innerhtml = sResults