[ psqlodbc-Bugs-1010509 ] SQLDriverconnect() failed in solaris 10 Sparc

Bugs item #1010509, was opened at 2008-11-14 11:44
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1010509&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Anshuen Luo (aluo)
Assigned to: Nobody (None)
Summary: SQLDriverconnect() failed in solaris 10 Sparc

Initial Comment:
We have been testing with 2.2.12 unixODBC driver manager and 08.03.0400 driver in solaris 10 environment. Both isql and
odbctest32can connect to psql 8.1.4 with 08.01.0200 driver but not 08.03.0300 or 08.03.0400. 

odbctest32.C is attached for your reference.

Please help us to find the solution.
Thanks.


n440da22:/platdb/odbc32/bin-# ./isql PostgreSQL scncraft scncraft91
[ISQL]ERROR: Could not SQLConnect

n440da22:/u/ainet/aluo-# ./odbctest32
connection string:DSN=PostgreSQL;UID=scncraft;PWD=scncraft91;
failed,rc:-1
DB Pool ODBC Error: SQLSTATE = IM005
,NATIVE ERROR = 0
, MSG = [unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_DBC failed

The odbc.ini file

[PostgreSQL]
Description      = PostgreSQL A
#Driver           = /platdb/odbc32/lib/psqlodbc.so
Driver           = /platdb/odbc32/lib/psqlodbca.so
Trace            = Yes
Debug            = 1
TraceFile        = /tmp/psqlodbc32.log
Database         = A
Servername       = localhost
UserName         =
Password         =
Port             = 5333
Protocol         = 7.3
ReadOnly         = Yes
RowVersioning    = No
ShowSystemTables = No
ShowOidColumn    = No
FakeOidIndex     = No
ConnSettings     =


n440da22:/platdb/odbc32/lib-# ldd -r psqlodbca.so
        librt.so.1 =>    /lib/librt.so.1
        libsocket.so.1 =>        /lib/libsocket.so.1
        libnsl.so.1 =>   /lib/libnsl.so.1
        libpq.so.4 =>    /platdb/lib/libpq.so.4
        libpthread.so.1 =>       /lib/libpthread.so.1
        libodbcinst.so.1 =>      /platdb/odbc32/lib/libodbcinst.so.1
        libodbc.so.1 =>  /platdb/odbc32/lib/libodbc.so.1
        libc.so.1 =>     /lib/libc.so.1
        libaio.so.1 =>   /lib/libaio.so.1
        libmd.so.1 =>    /lib/libmd.so.1
        libmp.so.2 =>    /lib/libmp.so.2
        libscf.so.1 =>   /lib/libscf.so.1
        libresolv.so.2 =>        /lib/libresolv.so.2
        libdl.so.1 =>    /lib/libdl.so.1
        libthread.so.1 =>        /lib/libthread.so.1
        libdoor.so.1 =>  /lib/libdoor.so.1
        libuutil.so.1 =>         /lib/libuutil.so.1
        libgen.so.1 =>   /lib/libgen.so.1
        /platform/SUNW,Netra-440/lib/libc_psr.so.1
        /platform/SUNW,Netra-440/lib/libmd_psr.so.1
        libm.so.2 =>     /lib/libm.so.2
n440da22:/platdb/odbc32/lib-#




----------------------------------------------------------------------

You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1010509&group_id=1000125