I'm currently trying to access data from a Cache DB using MSSQL. I have
linked the
Cache server through an ODBC connection. I can see in the Linked Server
expansion
all the tables in Cache for the File(?) I want to access.

Here is my problem: Normally to access a linked sever I would do the
following:

select *
from ServerName.DatabaseName.dbo.TableName

I have tried

select *
from ServerName.DSN.dbo.TableName

select *
from ServerName.DSN.SQLUser.TableName ("SQLUser" is the owner in Cache)

None have worked (error no such object...)

What is the syntax to select data on a linked sever via an ODBC connection?

In the Linked server set up I have also check the RPC and RPC Out options...
My ultimate goal is join tables in Cache and MSSQL into MSSQL.

Any help would be greatly appreciated!

Thanks,

-p

Oops, should have posted on comp.databases.ms-sqlserver...

-p

"Pippen" <123 (AT) hotmail (DOT) com> wrote