--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. Make Yahoo your homepage.
</body></html>
--0-840774825-1200674643=:2181--
