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" <admin@.admin.com> wrote in message
news:uT0Me0JREHA.2404@.TK2MSFTNGP09.phx.gbl...
> 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" <lazydragon@.nowhere.com> wrote in message
news:#jTet4JREHA.2876@.TK2MSFTNGP09.phx.gbl...
> 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" <admin@.admin.com> wrote in message
> news:uT0Me0JREHA.2404@.TK2MSFTNGP09.phx.gbl...
all[vbcol=seagreen]
>|||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" <admin@.admin.com> wrote in message
news:elffm9JREHA.3016@.tk2msftngp13.phx.gbl...
> 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" <lazydragon@.nowhere.com> wrote in message
> news:#jTet4JREHA.2876@.TK2MSFTNGP09.phx.gbl...
> all
>|||I do that and it's not working
Note: this is paradox file and the provider name is ODBC drivers
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:uB#BPWKREHA.2112@.TK2MSFTNGP11.phx.gbl...
> 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" <admin@.admin.com> wrote in message
> news:elffm9JREHA.3016@.tk2msftngp13.phx.gbl...
> paradox
saw[vbcol=seagreen]
>