gp_paoli

Hello,
Is it possible to write SQL requests in C programm as we can do with
Oracle with "precomp" but to extract data from Paradox Database. I
would like to develop with gcc because I have the choise of linux or
solaris plateform...
unixodbc is a solution?

Thank

liz

GP,

Why not use MySQL or another native Linux/Unix database?

Otherwise, see the LocalSQL.HLP file in the BDE's install dir.

Liz

larry digiovanni

I looked at this briefly 2 years ago for a client. We did not move
forward with it, but I do recall it was not pretty.

As an alternative, if you require read-only access to the data files and
they won't be in use by BDE clients at the same time, there is some Perl
code floating around that you could possibly either use as-is or use as a
roadmap to access the files under C.

http://els.donpac.ru/~cae/eng/paradox.shtml

It wouldn't let you make SQL requests, but you could unload the table and
load it into MySQL. If you need to access the Paradox tables while they
are being accessed by BDE clients, I would not attempt the above.

If you make headway using unixodbc, please post back with your results.
I'm sure folks here will be interested.

You might also contact Borland directly, or post this message on an NG on
one of the BDE fora at news.borland.com.


--
Larry DiGiovanni
Digico, Inc
IT Consulting and Staffing Solutions
http://www.digicoinc.com
Check out http://www.thedbcommunity.com for Paradox resources

gp_paoli

In fact, i want to integrate in an existing C program functions that
extract data from Paradox database. The C program runs under Solaris
plateform (but could migrate under Linux Red-Hat server). The Paradox
Database is under a WinNT4.0 Server, so it is not on the same
server...
Thank for all responses