Invalid schema or catalog specified for provider 'SQLOLEDB'

Hi,
I'm getting the following message when querying a database of a second
sql server.
"Invalid schema or catalog specified for provider 'SQLOLEDB'.
OLE DB error trace [Non-interface error: Invalid schema or catalog
specified for the provider.]."
This does not occur when querying other databases from the second
server. Is the problem a naming problem? If so, how can i correct it.
The name of the database as i can see in the enterprise manager has a
different name than the database's filename.
ThnxKommt darauf an welche Art von datenbank Du abfragst (hast Du leider nciht in
Deinem Posting genannt). Entsprechend der Datenbank stimmt der Katalog nicht
(z.B. bei einer AS/400, oder evtl. der Schema Owner z.B. Oracle nicht. Nähere
Informationen sollten Dir und uns helfen das Problem zu finden.
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Jason" wrote:
> Hi,
> I'm getting the following message when querying a database of a second
> sql server.
> "Invalid schema or catalog specified for provider 'SQLOLEDB'.
> OLE DB error trace [Non-interface error: Invalid schema or catalog
> specified for the provider.]."
> This does not occur when querying other databases from the second
> server. Is the problem a naming problem? If so, how can i correct it.
> The name of the database as i can see in the enterprise manager has a
> different name than the database's filename.
> Thnx
>|||Sorry, posted in the wrong language to the wrong thread :-). Ok , again...
If the second server (linked server i guess, or do you use a openquery or
opensource statement =) is a sql server you should check the owner of the
database objects you are quering for, perhaps they are created under a
special user account. ?
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Jason" wrote:
> Hi,
> I'm getting the following message when querying a database of a second
> sql server.
> "Invalid schema or catalog specified for provider 'SQLOLEDB'.
> OLE DB error trace [Non-interface error: Invalid schema or catalog
> specified for the provider.]."
> This does not occur when querying other databases from the second
> server. Is the problem a naming problem? If so, how can i correct it.
> The name of the database as i can see in the enterprise manager has a
> different name than the database's filename.
> Thnx
>|||Hi
If your server is SP4 and the server you are conenction to is SP3 and
earlier, the catalogue stored procedures are out of date.
Run Instcat.sql, using the copy on the SP4 server against the SP3 server.
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jason" wrote:
> Hi,
> I'm getting the following message when querying a database of a second
> sql server.
> "Invalid schema or catalog specified for provider 'SQLOLEDB'.
> OLE DB error trace [Non-interface error: Invalid schema or catalog
> specified for the provider.]."
> This does not occur when querying other databases from the second
> server. Is the problem a naming problem? If so, how can i correct it.
> The name of the database as i can see in the enterprise manager has a
> different name than the database's filename.
> Thnx
>|||Hi Mike,
Both machines are sp4. Like i said earlier. It doesn't occur when
querying other databases on the second server. The only difference i can
see is that the database has a different filename than the databasename.
Mike Epprecht (SQL MVP) wrote:
> Hi
> If your server is SP4 and the server you are conenction to is SP3 and
> earlier, the catalogue stored procedures are out of date.
> Run Instcat.sql, using the copy on the SP4 server against the SP3 server.|||Dear All,
I am looking for data one server to another server which
invoicenumber not same in the table.
Thanks
Prabhakar|||Dear all,
I am getting this error while looking query the data from one server which
is not match from another server.
pleae let us know the reply
OLE DB error trace [Non-interface error: Invalid schema or catalog
specified for the provider.].
Thanks
Prabhakar|||Dear all,
I am getting this error while looking query the data from one server which
is not match from another server.
pleae let us know the reply
OLE DB error trace [Non-interface error: Invalid schema or catalog
specified for the provider.].
Thanks
Prabhakar