SELECT FROM ANOTHER DATABASE TYPE (Paradox)

[t0Mi]

Ahojte,

well, heh, imagine this: In Borland C+ Builder I've got an ADO Connection which is used to work with *.mdb files and it works correctly. I can even make a query for comparing data from 2 db's (both *.mdb), using IN clause. This works just perfect.

... FROM Table IN '' ';DATABASE=C:\PROGRAM\DB1.mdb' WHERE ...
​

Now I need a similar query, which would take data from PARADOX database and insert them into my *.mdb file. I don't want to talk about INSERT INTO syntax here, that's kinda familiar. Just focus on the "SELECT from another database" part. In MS ACCESS Help I found this:

... FROM Table IN '' [dBASE IV; DATABASE=C:\DBASE\DATA\SALES;] ...
... FROM Table IN 'C:\DBASE\DATA\SALES' 'dBASE IV;' ...

And there is a note that the IN clause can be also used to take data from Paradox db. So then:

... FROM Table IN '' [Paradox 4.0; DATABASE=C:\PROGRAM\PDX1.DB;] ...

It works fine with the both MS ACCESS db's when I replace the square brackets with single quotes (check out the first query). So I've tried to do the same with this query:

... FROM Table IN '' 'Paradox 4.0; DATABASE=C:\PROGRAM\PDX1.DB;' ...

And this is the end of the road for me. It keeps on returning this error msg:

"Could not find installable ISAM."

Even if I use the second syntax from MS ACCESS Help. Still the same. I found something about this error msg on the internet. According to that I have to re-register my .dll files by using Regsvr32.exe. It didn't help and I don't think this is my case... Any ideas ?

 

[mearle]

Just an educated guess, but does the index file exist for this table, which I think ends in .px ? Otherwise try linking the table, and see if you get the same error.

 

[t0Mi]

When I make another ADO Connection for paradox queries, it works. I can even make a SELECT query from the paradox file and everything's OK. But in that case I would have to use loop while inserting the data into MS ACCESS db. So I CAN CONNECT to the paradox file (that means the linking and index file is OK, I guess...), but I want to have access to that file from the MS ACCESS query.

 

[ByteMyzer]

You might try something like:
...FROM Table
IN ''[ODBC;Driver={Microsoft Paradox Driver (*.db )};
DriverID=538;
Fil=Paradox 5.X;
DefaultDir=c:\pathToDb\;
Dbq=c:\pathToDb\;
CollatingSequence=ASCII;];

 

[t0Mi]

"You cannot use ODBC to import from, export to, or link an external Microsoft Jet or ISAM database table to your database."