--0-840774825-1200674643=:2181
Content-Type: text/plain; charset=us-ascii
I am using he latest otl header (v 4.0.159) with the latest odbc library.
I have a heavily multi-threaded application using otl to do many
simultaneous read/writes on my postgres database.
Randomly, I will see the rlogon function lockup on the SQLSetEnvAttr
function call.
When I set Threading=3 or Threading=1, it locks up more often.
Also, I have compiled odbc and postgres for multi-threaded use. I also
call the otl_initialize(1), so that otl lets the driver know it is
multithreaded.
My odbcinst.ini is setup as follows:
[PostgreSQL]
Description = ODBC for PostgreSQL
Driver = /usr/local/odbc/lib/libodbcpsql.so.2
Setup = /usr/local/odbc/lib/libodbcpsqlS.so.2
FileUsage = 1
CPTimeout = 1000
CPReuse = 20
Threading = 2
[ODBC]
Trace = no
TraceFile =
ForceTrace = No
Pooling = Yes
Any ideas???
____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
--0-840774825-1200674643=:2181
Content-Type: text/html; charset=us-ascii
<html><head><style type="text/css"><!-- DIV {margin:0px;}
--></style></head><body><div style="font-family:times new roman, new york,
times, serif;font-size:12pt"><div>I am using he latest otl header (v
4.0.159) with the latest odbc library. I have a heavily
multi-threaded application using otl to do many simultaneous read/writes
on my postgres database. <br><br>Randomly, I will see the rlogon
function lockup on the SQLSetEnvAttr function call. <br><br>When I
set Threading=3 or Threading=1, it locks up more often.<br>Also, I have
compiled odbc and postgres for multi-threaded use. I also call the
otl_initialize(1), so that otl lets the driver know it is
multithreaded.<br><br>My odbcinst.ini is setup as
follows:<br>[PostgreSQL]<br>Description = ODBC for
PostgreSQL<br>Driver =
/usr/local/odbc/lib/libodbcpsql.so.2<br>Setup
=
/usr/local/odbc/lib/libodbcpsqlS.so.2<br>FileUsage =
1<br>CPTimeout = 1000<br>CPReuse
= 20<br>Threading =
2<br><br>[ODBC]<br>Trace =
no<br>TraceFile = <br>ForceTrace =
No<br>Pooling = Yes<br><br>Any
ideas???<br></div></div><br>
<hr size=1>Never miss a thing. <a
href="http://us.rd.yahoo.com/evt=51438/*http://www.yahoo.com/r/hs">
Make
Yahoo your homepage.</a>
</body></html>
--0-840774825-1200674643=:2181--
|
