| From: | Davebo Rodrigues <mr_d_rod(at)yahoo(dot)com> | 
|---|---|
| To: | pgsql-odbc(at)postgresql(dot)org | 
| Subject: | odbc otl lockup in rlogon | 
| Date: | 2008-01-18 16:44:03 | 
| Message-ID: | 487247.2181.qm@web81410.mail.mud.yahoo.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-odbc | 
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 
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guillaume Gautreau | 2008-01-21 09:29:55 | Driver 8.1 : fails contacting the server with routable address | 
| Previous Message | Hiroshi Saito | 2008-01-18 15:49:41 | Re: Time to new release ? |