Linked server

  • Thread starter Thread starter Admin
  • Start date Start date
A

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?
 
Use four part naming like

SELECT A.Col1, A.col2,A.coln
FROM LinkedServername.Database.owner.Table A
 
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
 
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
 
I do that and it's not working
Note: this is paradox file and the provider name is ODBC drivers
 
Back
Top