I am running PB 6.5 with IBM UNIDATA connected thru ODBC. The application was working fine and all of sudden got the following problems.

The login/password/privileges are not changed.
Reading from the database is successful in 1 & 2, but updates/deletes/commits are not successful. Please see the below error
messages. 3 - reading from the database returns error.

1. 030529 11:11:06 > DW Error: (999 Row 1) SQLSTATE = S1000
[Ardent][UniData ODBC Driver][Informix][SQL Client][UNIDATA]Open file error

2. DELETE FROM PTRN WHERE ID = '001*GANGTEST*12924*54720*10-40*170*1502'
030529 11:11:09 > DW Error: (999 Row 1) SQLSTATE = S1000
[Ardent][UniData ODBC Driver][Informix][SQL Client][UNIDATA]Open file error

3. 030529 11:11:11 > DW Error: (999 Row 0) Select error: SQLSTATE = S1000
[Ardent][UniData ODBC Driver][Informix][SQL Client][UNIDATA]Unidata lower level function error with fetch