azumaleasing
asked on
Using a Microsoft SQL Server with Paradox 8
What would be the best way to create a linked server for paradox 7 tables on an SQL Server. Currently it appears we're using a Miscrosoft SQL Server and we do have Paradox 8 installed.
ASKER
Do you know how to set up SQL to use ODBC or the Microsfot Jet OLE DB Provider to read Paradox tables?
When you create an SystemDSN, use the 'Microsoft Paradox Driver' and fill in a data source name, select the Paradox version (3.x, 4.x or 5.x) and set the correct directory if not the current. Never done that, but it looks pretty straightforward.
Once that one is working, use that DSN to setup a linked server from within SQL Server.
Hope this helps ...
Once that one is working, use that DSN to setup a linked server from within SQL Server.
Hope this helps ...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
@azumaleasing: Where did you get these drivers from? What paradox installation did you use?
I would be very interested to see your Linked Server setup. Would you mind scripting it, change user names and db names, but please leave in as much detail as you can...
Hope this helps ...