Linked server

[Admin]

I linked to paradox table from MSSQL 2000 enterprise server and I saw all
the table name
but my question is how can I make a select statment to see the data?

 

[Roji. P. Thomas]

Use four part naming like

SELECT A.Col1, A.col2,A.coln
FROM LinkedServername.Database.owner.Table A

 

[Admin]

THANKS A LOT, but the linked server is paradox.
I make a ODBC connection and then I linked into linked server
mean
Select * from LinkedServername...city
is this correct? bcs I have not database name and owner name this is paradox
table

 

[Hari]

Hi,

Try

select * from openquery(linked_server_name, 'select * from table_name')

Replace the server name and table name based on ur requirement.

Thanks
Hari
MCDBA

 

[Admin]

I do that and it's not working
Note: this is paradox file and the provider name is ODBC drivers