"mc" <mchenna2000@yahoo.com> wrote in message
news:a388d1ff.0409022030.1e0552c4@posting.google.com...
> I am using SQL Server 2000 and trying to add linked server to a
> paradox server. First I have created DSN and used this dsn name in the
> linked server connection. It failed. Then I tried creating the linked
> server using the server name instead of dsn. It failed. I used
> OpenRowSet and SQLOLEDB provider and it worked. I need to be able to
> connect through linked server for our application. Please help me on
> how to create linked server.
> Thanks in advance,
> Mani

"oj" <nospam_ojngo@home.com> wrote in message news:<OM#M3XYkEHA.2436@TK2MSFTNGP09.phx.gbl>...
> try:
>
> EXEC sp_addlinkedserver 'pdox',
> '',
> 'MSDASQL',
> 'your_system_dsn'
>
> EXEC sp_addlinkedsrvlogin 'pdox',
> 'false',
> null,
> 'admin',
> ''
>
>
>
> "mc" <mchenna2000@yahoo.com> wrote in message
> news:a388d1ff.0409022030.1e0552c4@posting.google.com...
> > I am using SQL Server 2000 and trying to add linked server to a
> > paradox server. First I have created DSN and used this dsn name in the
> > linked server connection. It failed. Then I tried creating the linked
> > server using the server name instead of dsn. It failed. I used
> > OpenRowSet and SQLOLEDB provider and it worked. I need to be able to
> > connect through linked server for our application. Please help me on
> > how to create linked server.
> > Thanks in advance,