PDA

View Full Version : error when connect to paradox 4.0 table


jayson_13
03-05-03, 21:00
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

Shores
08-27-03, 17:59
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.