Driver"s SQLAllocHandle on SQL_HANDLE_DBC failed

Driver"s SQLAllocHandle on SQL_HANDLE_DBC failed

am 24.03.2010 19:13:55 von raja agireddy

--0016e6d64861b478b304828fe47d
Content-Type: text/plain; charset=ISO-8859-1

Hi,

I have compiled unixodbc and postgressql odbc driver on solaris 10 server to
connect to postgressql database and I am having following issues

../isql -vvv DG4ODBC
[IM005][unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_DBC
failed
[ISQL]ERROR: Could not SQLConnect


Here is the trace file:

[DEVL] oradevl@dbdev> vi trace.log
[ODBC][23264][1269453011.641639][__handles.c][450]
Exit:[SQL_SUCCESS]
Environment = 2b048
[ODBC][23264][1269453011.641760][SQLAllocHandle.c][364]
Entry:
Handle Type = 2
Input Handle = 2b048
[ODBC][23264][1269453011.641801][SQLAllocHandle.c][482]
Exit:[SQL_SUCCESS]
Output Handle = 2b670
[ODBC][23264][1269453011.641911][SQLConnect.c][3614]
Entry:
Connection = 2b670
Server Name = [DG4ODBC][length = 7 (SQL_NTS)]
User Name = [NULL]
Authentication = [NULL]
[ODBC][23264][1269453011.666745][SQLAllocHandle.c][337]Error :
SQL_INVALID_HANDLE
[ODBC][23264][1269453011.666776][SQLConnect.c][1583]Error: IM005
[ODBC][23264][1269453011.666818][SQLError.c][482]Error: SQL_INVALID_HANDLE
[ODBC][23264][1269453011.666852][SQLError.c][430]
Entry:
Connection = 2b670
SQLState = ffbff2e0
Native = ffbff2d8
Message Text = ffbff2f0
Buffer Length = 500
Text Len Ptr = ffbff2de
[ODBC][23264][1269453011.666894][SQLError.c][467]
Exit:[SQL_SUCCESS]
SQLState = IM005
Native = ffbff2d8 -> 0
Message Text = [[unixODBC][Driver Manager]Driver's
SQLAllocHandle on SQL_HANDLE_DBC failed]
[ODBC][23264][1269453011.667036][SQLError.c][430]
Entry:
Connection = 2b670
SQLState = ffbff2e0
Native = ffbff2d8
Message Text = ffbff2f0
Buffer Length = 500
Text Len Ptr = ffbff2de
[ODBC][23264][1269453011.667063][SQLError.c][467]
Exit:[SQL_NO_DATA]
[ODBC][23264][1269453011.667089][SQLError.c][510]
Entry:
Environment = 2b048
SQLState = ffbff2e0
Native = ffbff2d8
Message Text = ffbff2f0
Buffer Length = 500
Text Len Ptr = ffbff2de
[ODBC][23264][1269453011.667117][SQLError.c][547]
Exit:[SQL_NO_DATA]
[ODBC][23264][1269453011.667178][SQLFreeHandle.c][279]
Entry:
Handle Type = 2
Input Handle = 2b670
[ODBC][23264][1269453011.667207][SQLFreeHandle.c][194]Error:
SQL_INVALID_HANDLE
[ODBC][23264][1269453011.667239][SQLFreeHandle.c][330]
Exit:[SQL_SUCCESS]
[ODBC][23264][1269453011.667271][SQLFreeHandle.c][212]
Entry:
Handle Type = 1
Input Handle = 2b048


=====================
Here is my odbc.ini file:
===============

[DG4ODBC]
Description = Services Database
Driver = PostgreSQL
Database = vidb05
Servername = 192.168.17.13
UserName = username
Password = password
Port = 5432
ReadOnly = No
RowVersioning = No
ShowSystemTables = No
ShowOidColumn = No
FakeOidIndex = No
ConnSettings =

==============
Here is my odbcinst.ini
=================
[ODBC]
Trace = yes
TraceFile = /tmp/trace.log

[PostgreSQL]
Description = PostgreSQL Official ODBC Driver
Driver = /usr/tmp/raja/psqlodbc/lib/psqlodbca.so
Debug = 1
CommLog = 1

--0016e6d64861b478b304828fe47d
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi,


I have compiled unixodbc and postgressql odbc driver=
on solaris 10 server to connect to postgressql database and I am having fo=
llowing issues

./isql -vvv DG4ODBC

[IM005][unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_=
DBC failed
[ISQL]ERROR: Could not SQLConnect

=

Here is the trace file:


[DEVL] oradevl@dbdev> vi trace.log
[ODBC][23264][1269453011.64=
1639][__handles.c][450]
   =A0 =A0 =A0 =A0 =A0 =A0 =A0Exit:[S=
QL_SUCCESS]
   =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Env=
ironment =3D 2b048
[ODBC][23264][1269453011.641760][SQLAllocHandl=
e.c][364]

   =A0 =A0 =A0 =A0 =A0 =A0 =A0Entry:
   =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Handle Type =3D 2
   =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Input Handle =3D 2b048
[ODBC][=
23264][1269453011.641801][SQLAllocHandle.c][482]
   =A0 =A0 =
=A0 =A0 =A0 =A0 =A0Exit:[SQL_SUCCESS]

   =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Output Handle =3D 2b=
670
[ODBC][23264][1269453011.641911][SQLConnect.c][3614]
v>   =A0 =A0 =A0 =A0 =A0 =A0 =A0Entry:
   =A0 =A0 =A0 =A0=
=A0 =A0 =A0 =A0 =A0 =A0 =A0Connection =3D 2b670
   =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Server Name =3D [DG4ODBC][length =3D 7 (=
SQL_NTS)]

   =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0User Name =3D [NULL]=
   =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Authentication=
=3D [NULL]
[ODBC][23264][1269453011.666745][SQLAllocHandle.c][33=
7]Error: SQL_INVALID_HANDLE
[ODBC][23264][1269453011.666776][SQLC=
onnect.c][1583]Error: IM005

[ODBC][23264][1269453011.666818][SQLError.c][482]Error: SQL_INVALID_HA=
NDLE
[ODBC][23264][1269453011.666852][SQLError.c][430]
=
   =A0 =A0 =A0 =A0 =A0 =A0 =A0Entry:
   =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0 =A0Connection =3D 2b670

   =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0SQLState =3D ffbff2e=
0
   =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Native =3D ff=
bff2d8
   =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Message =
Text =3D ffbff2f0
   =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0Buffer Length =3D 500

   =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Text Len Ptr =3D ffbff2de=
[ODBC][23264][1269453011.666894][SQLError.c][467]
=A0=
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Exit:[SQL_SUCCESS]
   =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0SQLState =3D IM005
   =A0 =
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Native =3D ffbff2d8 -> 0

   =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Message Text =3D [[u=
nixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_DBC faile=
d]
[ODBC][23264][1269453011.667036][SQLError.c][430]
=
   =A0 =A0 =A0 =A0 =A0 =A0 =A0Entry:

   =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Connection =3D 2b670=
   =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0SQLState =3D f=
fbff2e0
   =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Native =
=3D ffbff2d8
   =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Me=
ssage Text =3D ffbff2f0

   =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Buffer Length =3D 500 v>
   =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Text Len Ptr =3D f=
fbff2de
[ODBC][23264][1269453011.667063][SQLError.c][467]
iv>   =A0 =A0 =A0 =A0 =A0 =A0 =A0Exit:[SQL_NO_DATA]
[ODBC][23=
264][1269453011.667089][SQLError.c][510]

   =A0 =A0 =A0 =A0 =A0 =A0 =A0Entry:
   =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Environment =3D 2b048
   =A0 =
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0SQLState =3D ffbff2e0
=A0=
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Native =3D ffbff2d8
v>   =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Message Text =3D ffbff2=
f0

   =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Buffer Length =3D 50=
0
   =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Text Len Ptr =
=3D ffbff2de
[ODBC][23264][1269453011.667117][SQLError.c][547] iv>
   =A0 =A0 =A0 =A0 =A0 =A0 =A0Exit:[SQL_NO_DATA]

[ODBC][23264][1269453011.667178][SQLFreeHandle.c][279]
   =A0=
=A0 =A0 =A0 =A0 =A0 =A0Entry:
   =A0 =A0 =A0 =A0 =A0 =A0 =A0=
=A0 =A0 =A0 =A0Handle Type =3D 2
   =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0Input Handle =3D 2b670
[ODBC][23264][126945301=
1.667207][SQLFreeHandle.c][194]Error: SQL_INVALID_HANDLE

[ODBC][23264][1269453011.667239][SQLFreeHandle.c][330]
=A0=
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Exit:[SQL_SUCCESS]
[ODBC][23264][1=
269453011.667271][SQLFreeHandle.c][212]
   =A0 =A0 =A0 =A0 =
=A0 =A0 =A0Entry:
   =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0Handle Type =3D 1

   =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Input Handle =3D 2b0=
48


===========
===========3D
Here is my odbc.ini file:
=
===============3D

>
[DG4ODBC]

Description =3D Services Database
Driver =3D PostgreSQL
>Database =3D vidb05
Servername =3D 192.168.17.13
UserN=
ame =3D username
Password =3D password
Port =3D 5432 iv>
ReadOnly =3D No

RowVersioning =3D No
ShowSystemTables =3D No
ShowO=
idColumn =3D No
FakeOidIndex =3D No
ConnSettings =3D iv>

==============
>Here is my odbcinst.ini

=================3D
[ODBC] div>
Trace =3D yes
TraceFile =3D /tmp/trace.log
>
[PostgreSQL]
Description =3D PostgreSQL Official ODBC=
Driver
Driver =3D /usr/tmp/raja/psqlodbc/lib/psqlodbca.so

Debug =3D 1
CommLog =3D 1

div>


--0016e6d64861b478b304828fe47d--