Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Posts
    4

    Unanswered: error when connect to paradox 4.0 table

    Hi guys,
    i don know in which forum i should post, so i just post this in vb and paradox forum.
    i have a vb application that read data from paradox table. I have set up a ODBC DSN and it work. but sometime it give me error too.
    i hope that you guy can tell me what i miss here.

    conn.open("DSN=doxDSN") <------- this line of code can run sometime.
    But it will give me "Catastrophic error" sometimes.

    here is the ODBC user dsn
    [ODBC]
    DRIVER=Microsoft Paradox Driver (*.db )
    UID=admin
    UserCommitSync=Yes
    Threads=3
    SafeTransactions=0
    ParadoxUserName=admin
    ParadoxNetStyle=4.x
    ParadoxNetPath=Q:\
    PageTimeout=5
    MaxScanRows=8
    MaxBufferSize=2048
    FIL=Paradox 4.X
    DriverId=282
    DefaultDir=Q:\
    DBQ=Q:\
    CollatingSequence=ASCII

  2. #2
    Join Date
    Aug 2003
    Location
    Bologna - Italy
    Posts
    209
    If you're using the Ms ODBC driver and you're trying to access the table with multiple concurrent connections, be aware that the ms driver is known to have problems in this situation.

    You should have a "locking" kind of code, which prevents from opening it twice, or go for a better ODBC Pdox Driver.
    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
  •