Sintaxis of the linked servers

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

Sintaxis of the linked servers

Author

Topic

nati_nieves
Starting Member

4 Posts

Posted - 2002-05-03 : 04:16:24

Hi,

I have created a linked server:

Sql Server------->Ingres

but when I execute the next:

select *
from PruebaDefinitiva.SDatabase.propietario.tblprueba

the analyzer gives me the next error:

Server: Msg 7313, Level 16, State 1, Line 1
Invalid schema or catalog specified for provider 'MSDASQL'.

Why???

Peter Dutch
Posting Yak Master

127 Posts

Posted - 2002-05-08 : 04:21:41

I think you've added the Sybase linked server, with the driver of SQL Server (MSDASQL). You have to use the Sybase driver.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources