PDA

View Full Version : Ado


folch
05-19-03, 13:34
I'm trying to open a Paradox table with ADO.
I use the setence:

ob_conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\paradox\data;Extended Properties=Paradox 5.X;"

In general, It's ok, but with 1 table i get the error:
"The external table has not the expected format"

So I try with Extended Properties=Paradox 7.X

but it says me "Operation not valid"

I'm using the references: "Microsoft Activex Data Objects 2.7 Library"
Can anybody help me?

Shores
08-27-03, 17:36
If i remeber it well the Ms Pdox Odbc Driver is quite limited: no locking, no blobs, no pdox table format >4.5...

If you really need access, you should go for a better ODBC driver, but there's no one i'm aware of that's free. One good you can buy is MERANT.

Bye!