Skip site navigation (1) Skip section navigation (2)

odbc otl lockup in rlogon

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 (view raw or flat)
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 

pgsql-odbc by date

Next:From: Guillaume GautreauDate: 2008-01-21 09:29:55
Subject: Driver 8.1 : fails contacting the server with routable address
Previous:From: Hiroshi SaitoDate: 2008-01-18 15:49:41
Subject: Re: Time to new release ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group