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:
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
Trace = no
ForceTrace = No
Pooling = Yes
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
pgsql-odbc by date
|Next:||From: Guillaume Gautreau||Date: 2008-01-21 09:29:55|
|Subject: Driver 8.1 : fails contacting the server with routable address|
|Previous:||From: Hiroshi Saito||Date: 2008-01-18 15:49:41|
|Subject: Re: Time to new release ?|