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

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

From: <noreply(at)pgfoundry(dot)org>
To: noreply(at)pgfoundry(dot)org
Subject: [ psqlodbc-Bugs-1010509 ] SQLDriverconnect() failed in solaris 10 Sparc
Date: 2008-11-14 11:44:10
Message-ID: 20081114114410.B60C117ADE30@pgfoundry.org (view raw or flat)
Thread:
Lists: pgsql-odbc
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 odbctest32 can 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

pgsql-odbc by date

Next:From: serge.luc-cayolDate: 2008-11-14 12:56:34
Subject: trouble in installing postgreSQL 8.3
Previous:From: Zoltan BoszormenyiDate: 2008-11-11 19:43:44
Subject: Re: Compiler warnings in psqloodbc 08.03.0200

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