[unixODBC-support] SQL locking issues
John.Withers at RedPrairie.com
Wed Mar 28 23:13:54 BST 2007
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.
From: unixodbc-support-bounces at easysoft.com
[mailto:unixodbc-support-bounces at easysoft.com] On Behalf Of Nick Gorham
Sent: Wednesday, March 28, 2007 4:28 PM
To: Support for the unixODBC project
Subject: Re: [unixODBC-support] SQL locking issues
Withers, John wrote:
> Hello, I'm new this list, but am in desperate need of help (isn't
> everyone). I'm using unixodbc with freetds to connect to SQL Server
> and we experiencing terrible locking issues. We are running Oracle
> 10.1.0.5 and SQL 2000, and a newer version of the odbc software on RH
> Linux. The locking is not even on any user tables or anything (note, I
> have no access to this database), and the Oracle session just hangs. I
> have attempted to enable logging at the ODBC level and the TDS level,
> but none seem to work. Has anyone ever experienced the same issue?
Are there threads involved, or is it a database locking issue?
How did you (try to) turn on tracing?
unixODBC-support mailing list
unixODBC-support at easysoft.com
More information about the unixODBC-support