Any ideas why an informix database DSN, which works fine in Access, keeps crashing when I place the SQLTransaction and an ODBCConnection on a form? I set up the ODBCConnection with just the DSN Name in the DatabaseName and then add a SQLTransaction with just the Database set to the ODBCConnection, I can enable/disable the ODBCConnection when it is by itself but when I connect the SQLTransaction to it and enable it I get an error when I try and make it un-active or the ODBCConnection un-active.
Here is the error:
"COULD not rollback! ODBC error details: LastReturnCode: SQL_ERROR; Record 1: SQLSTATE: HYC00; NativeError: -11092; Message: [Informix][Informix ODBC Driver]Driver not capable;"
At this point I can't modify either control without this error popping up. Seems as long as i don't enable the SQLTransaction I can modify anything but the moment I connect it to the ODBCConnection and activate it nothinig can be changed and I have to exit Lazarus. Even upon re-running Lazarus I cannot change either object without getting the error.
What am I doing wrong?
By the way I only want this to be a read-only connection.
Recent
