error 7399, OLE DB-errorrtrace, opendatasource

I would like to read data from an sql server using ad hoc queries in two sep
erate sessions (opendatasource). However, when I try to access both databan
ks the following error is generated:
Server: Nachr.-Nr. 7399, Schweregrad 16, Status 1, Zeile 3
Der OLE DB-Provider 'Microsoft.Jet.OLEDB.4.0' meldete einen Fehler. Der Prov
ider hat keine Informationen zu dem Fehler bereitgestellt.
OLE DB-Fehlertrace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IOpenRowse
t::OpenRowset returned 0x80004005: Der Provider hat keine Informationen zu
dem Fehler bereitgestellt.].
thanksTulpe,
This looks like your SQL Server is actually passing you through to a linked
server for a Jet database (Access). Is that what is happening? If so,
there are a few KB articles that may help.
http://support.microsoft.com/defaul...kb;en-us;296711
http://support.microsoft.com/defaul...kb;en-us;818182
http://support.microsoft.com/defaul...kb;en-us;814398
http://support.microsoft.com/defaul...kb;en-us;285833
Russell Fields
"Tulpe" <anonymous@.discussions.microsoft.com> wrote in message
news:A6F5B481-5BAE-4DEB-AF78-D6147D5C1FB7@.microsoft.com...
> I would like to read data from an sql server using ad hoc queries in two
seperate sessions (opendatasource). However, when I try to access both
databanks the following error is generated:
> Server: Nachr.-Nr. 7399, Schweregrad 16, Status 1, Zeile 3
> Der OLE DB-Provider 'Microsoft.Jet.OLEDB.4.0' meldete einen Fehler. Der
Provider hat keine Informationen zu dem Fehler bereitgestellt.
> OLE DB-Fehlertrace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'
IOpenRowset::OpenRowset returned 0x80004005: Der Provider hat keine
Informationen zu dem Fehler bereitgestellt.].
> thanks