Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

ExOLEDB Error: Invalid object name 'SCOPE'??

14 views
Skip to first unread message

Jaco van der Merwe

unread,
Mar 26, 2002, 2:10:01 AM3/26/02
to
Hi,

My computer is configured as follows:
MS Windows 2000 Server with SP 2
MS Exchange 2000 Server with SP 1
MS Visual Studio with SP 5
MDAC 2.7

I am coding a VB DLL and when I make a connection to the Webstore,
there is no error.
As soon as I query the Webstore, however then an error is returned.

The Code:
....
Conn.Provider = "ExOLEDB.Provider"
Conn.Open "http://webstore.url.here/myfolder/"
QueryStr = "SELECT * FROM SCOPE('shallow traversal of
""http://webstore.url.here/myfolder/""')"
Rec.Open QueryStr, Conn
....

The rest of the code is correct, because this has worked before. And
now suddenly I get this error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
'SCOPE'.

I know what the error means, but I don't know what is causing it and
how to fix it. Any help would be greatly appreciated.

Thanks
Jaco

0 new messages