Paradox linked server

[NathanGriffiths]

Can a Paradox 5.X database or free table directory be added as a linked server in SQL Server 2000?

In theory it seems to be possible but we are having no success either using EM or sp_addlinkedserver and OLE DB connection or ODBC.

Any advice much appreciated!

thanks,



Nathan

 

[donutman]

Using Paradox with MS SQL Server

http://www.thedbcommunity.com/solution/mssql1.htm

-Karl

 

[NathanGriffiths]

Thanks, that article was about using Paradox as a front end for SQL Server though.

Our problem is we are not using Paradox, we are just trying to migrate a system into SQL Server and we need to be able to link to the Paradox tables directly from SQL Server. We can browse the tables using Paradox and manually import them to SQL Server but operationally it would be a whole lot simpler if we could access the tables as a linked server.

Does anyone know how to set up linked server ODBC or OLE DB connections from SQL Server to Paradox?

thanks,




Nathan

 

[donutman]

I had trouble linking 2 SQL Servers (over the internet), then I checked the sysservers table in database that created the link (not the master) on the local server. I noticed a connection string error and was able to fix it. This was a long time ago so I don't recall the details, but I may have had to turn on/off the ability/disability to update a system table.
Before I made the change I wasn't able to see the linked tables in the Security.LinkedServers.Name.Tables tree path in EM. After the change I could. And everything work fine since. Hope this can be of some help. Good Luck.
-Karl