[unixODBC-support] SQL locking issues

Withers, John 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.

 
-----Original Message-----
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?
>
> Thanks!
>
> John
>
Are there threads involved, or is it a database locking issue?

How did you (try to) turn on tracing?

-- 
Nick
_______________________________________________
unixODBC-support mailing list
unixODBC-support at easysoft.com
http://mail.easysoft.com/mailman/listinfo/unixodbc-support



More information about the unixODBC-support mailing list