Results 1 to 2 of 2

Thread: Ado

  1. #1
    Join Date
    May 2003

    Unanswered: Ado

    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?

  2. #2
    Join Date
    Aug 2003
    Bologna - Italy
    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.

    The only failure is not trying to do it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts