Results 1 to 2 of 2

Thread: Ado

  1. #1
    Join Date
    May 2003
    Posts
    2

    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
    Location
    Bologna - Italy
    Posts
    209
    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!
    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
  •