Linked server access - SQL Server Forums

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

SQL Server Administration (2000)

Linked server access

Author

Topic

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2005-03-02 : 08:19:14

I want to access a linked server table without using OPENDATASOURCE or OPENROWSET.

The oledb provider should support four-part naming for this. Any one has more information on this?

------------------------
I think, therefore I am

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2005-03-02 : 16:56:31

What kind of server are You linking

select ... from server.catalog.owner.table /* straightforward for linked mssql server */
for other servers the 4-part naming might be:
server.schema..table
server..schema.table

rockmoose

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2005-03-03 : 01:13:37

My target linked server is sybase. The four part naming doesn't work there. It works only for SQL2K..

------------------------
I think, therefore I am

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2005-03-03 : 06:46:21

We have a linked sybase server.
We can use both openquery + 4-part naming.

rockmoose

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2005-03-03 : 07:20:52

which driver you are using?

------------------------
I think, therefore I am

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2005-03-03 : 08:14:25

Sybase System 11 ODBC Driver.
3.11.00.01
We link it with Microsoft OLEDB Provider for ODBC.

rockmoose