Re: Linked server

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Admin (admin_at_admin.com)
Date: 05/28/04 

Date: Fri, 28 May 2004 15:02:34 +0300

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

Relevant Pages

  • Re: Linked server
    ... this is paradox file and the provider name is ODBC drivers ... > Replace the server name and table name based on ur requirement. ... but the linked server is paradox. ...
    (microsoft.public.sqlserver.programming)
  • Re: Linked server
    ... this is paradox file and the provider name is ODBC drivers ... > Replace the server name and table name based on ur requirement. ... but the linked server is paradox. ...
    (microsoft.public.sqlserver.connect)
  • Re: teaching a child - console or GUI
    ... written back in '95 based on Paradox, now I'm asked to do a new version. ... universe - the demanding and unpredictable database. ... > is fully capable of running without the server online... ... What if the customer has more than 65535 items in stock? ...
    (comp.lang.pascal.delphi.misc)
  • Re: VFP ODBC Problem - Unable to create temporary work files
    ... Microsoft OLE DB Provider for Visual FoxPro ... OLE Server: Crystal Reports ActiveX Designer ... > Microsoft OLE DB Provider for ODBC Drivers error '80004005' ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Same form, but one system GPFs...?
    ... Since you went back to a system-image of a time when all worked fine, you should not be dealing with a paradox, bde or windows problem. ... that you are either dealing with a hardware problem in either the PC itself or it's connection to the network. ... Then the next best place to look, would be the server or networksettings; could there be anything on there, that restrict this specific PC in a way that the other PC's are not restricted? ...
    (comp.databases.paradox)