[unixODBC-support] SQL locking issues

Nick Gorham 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.

-- 
Nick



More information about the unixODBC-support mailing list