Linked server

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



--
Roji. P. Thomas
SQL Server Programmer
"Admin" wrote in message
...
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?

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

"Roji. P. Thomas" wrote in message
...
Use four part naming like

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



--
Roji. P. Thomas
SQL Server Programmer
"Admin" wrote in message
...
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?

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" wrote in message
...
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

"Roji. P. Thomas" wrote in message
...
Use four part naming like

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



--
Roji. P. Thomas
SQL Server Programmer
"Admin" wrote in message
...
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?

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


"Hari" wrote in message
...
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" wrote in message
...
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

"Roji. P. Thomas" wrote in message
...
Use four part naming like

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



--
Roji. P. Thomas
SQL Server Programmer
"Admin" wrote in message
...
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?