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
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.]
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/default.aspx?scid=kb;en-us;296711
http://support.microsoft.com/default.aspx?scid=kb;en-us;818182
http://support.microsoft.com/default.aspx?scid=kb;en-us;814398
http://support.microsoft.com/default.aspx?scid=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.].
> thankssql
No comments:
Post a Comment