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...
> > 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" <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...
> > 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?
> > >
> > >
> >
> >
>
>

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...
> > 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...
> > > > 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?
> > > >
> > > >
> > >
> > >
> >
> >
>
>