Paradox Linked Table Settings

[scriggs]

I have inherited a paradox database which I need to use in a new VB front end.

I want to setup as a linked table to SQL Server but have never done this.

Can anyone give me any details on how to complete the fields in SQL Server Linked Table Manager.

I can setup an ODBC link from MS Query and the database details I am linking to is:
Type: Paradox 5
Driver: Microsoft Paradox Driver (*.db)
Path: \\hal\database\
Password: password

I have tried to use some of these but don't know how to convert this into the DSN string and Connection String linked table requests.

 

[rdandrade]

As long as you don't have proprietary software using the paradox database, import the entire thing into SQL. Create your VB app to use SQL. You'll be much happier with the results.

Your VB front end should access the paradox files directly, not go through a linked server if you have no choice but to keep the data in Paradox. I don't see anyway to set that up and I'd imagine that if you could, it would be extremely slow. Paradox is slow enough on its own.

Ray D'Andrade

http://www.raydandrade.com