odbc otl lockup in rlogon

odbc otl lockup in rlogon

am 18.01.2008 17:44:03 von Davebo Rodrigues

--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

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???




Never miss a thing.


--0-840774825-1200674643=:2181--