Using Paradox to query an SQL7 database

[gregjp]

The SQL7 query is painful plus to use. The Paradox query interface is very good and self explanitory. Ideally I would like to query the SQL7 database using Paradox 9.
The SQL7 db is located on an application server running WinNT. Paradox is on the workstations.
What must I do to allow Paradox to talk to SQL and run Paradox query.

Greg

 

[Bystander]

The following thread in this forum might be useful:

Connecting To Oracle By ODBC

Regards

Bystander

 

[edunaway]

We create an alias for the SQL 7 database and reference it that way. Keep in mind that you need your working directory to be something else (local drive works just fine).

 

[newtechy]

Greg:

Have you found a solution to your problem with connecting to SQL Server from Paradox?? If so, I need your help. I'm basically trying to do the same thing. Do you have any sample Paradox script that allows you to insert records from Paradox 9 into a Sql Server table real-time???

Thanks,
newtechy