[unixODBC-support] SQL locking issues
nick.gorham at easysoft.com
Thu Mar 29 00:50:14 BST 2007
Withers, John wrote:
>Just locking issues. On the Oracle side, we have created views that
>select against the remote SQL server tables, and we do DML on those.
>One thing I have just seen from enabling HS logging from Oracle is that
>we are violating integrity constraints on some inserts. I don't know if
>this is the culprit, but is definitely a place to start. I have our
>developers working on this and I'm hoping this will resolve, but can't
>be sure at this point. I tried enabling logging in the odbc.ini file by
>setting Trace and Tracefile parameters for the odbc database entry.
Ok, check that if you have a log file already, that its writable by
hsodbc. Maybe try setting its mode to 0666 to be sure.
More information about the unixODBC-support