ADO Connect to Paradox via ADOConnection

TECH TIP: Connect To Paradox Via ADOConnection

1. Create a TADOConnection
2. Launch the Data Link Properties Dialog by double clicking on the ADOConnection on the Form
3. Set the Provider to be the Microsoft OLE DB Provider for ODBC Drivers
4. Select Next or Select the Connection tab of the Data Link dialog
5. Specify the source of data by using a connection string and press Build.
6. Create a new DSN for DBDemos in C:\Program Files\Common Files\Borland Shared\Data\DBDemos.DSN
7. Check the directory shown in the ODBC Paradox setup dialog to be the same as shown in step 5.
8. Select 'OK' in the ODBC Paradox setup dialog and return to the Data Link Dialog
9. Select the path for the initial catalog to use from the drop down list.
10. Test Connection

Now you should be able to connect to DBDemos via ADO. Surf this example for a demo.

http://www.digital-metaphors.com/tips/ADOLinkParadoxToSQLServer.zip