
February 16th, 2004, 11:02 AM
|
|
Registered User
|
|
Join Date: Feb 2004
Posts: 10
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
help with error on SQL
When I try to make a linked server connection to my exchange server and try to run the following query
exec sp_addlinkedserver 'test', 'Exchange OLE DB provider',
'exoledb.DataSource.1',
'file:%5C\.\backofficestorage\visibility.exchg.com \public folders'
;
SELECT Convert(nvarchar(30), "urn:schemas:contacts:sn") LastName
FROM OpenQuery(test, 'SELECT "urn:schemas:contacts:sn"
FROM ".\Contact"')
, I get this error
Server: Msg 7304, Level 16, State 2, Line 1
Could not create a new session on OLE DB provider 'exoledb.DataSource.1'.
OLE DB error trace [OLE/DB Provider 'exoledb.DataSource.1' IDBCreateSession::CreateSession returned 0x80040e19].
anyone who can help me?
|