Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

Wwwxxx.comvam, WWWXXX AMS, WWWXXX.APC, should producers of software based systems services such as atms be held liable for economic injuries suffered when their systems failed, WWWXXX DOCO, WWWXXX BDCE, WWWXXX DACB, wwwxxx,nvif, why atm producer might be held liable for economic injury, wwwxxxy=ServiceLogin

Links

XODOX
Impressum

#1: Driver"s SQLAllocHandle on SQL_HANDLE_DBC failed

Posted on 2010-03-24 19:13:55 by 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,<div><br></div><div>I have compiled unixodbc and postgressql odbc driver=
on solaris 10 server to connect to postgressql database and I am having fo=
llowing issues</div><div><br></div><div><div>./isql -vvv DG4ODBC</div><div>
[IM005][unixODBC][Driver Manager]Driver&#39;s SQLAllocHandle on SQL_HANDLE_=
DBC failed</div><div>[ISQL]ERROR: Could not SQLConnect</div><div><br></div>=
<div><br></div><div>Here is the trace file:</div><div><br></div><div><div>
[DEVL] oradevl@dbdev&gt; vi trace.log</div><div>[ODBC][23264][1269453011.64=
1639][__handles.c][450]</div><div>   =A0 =A0 =A0 =A0 =A0 =A0 =A0Exit:[S=
QL_SUCCESS]</div><div>   =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Env=
ironment =3D 2b048</div><div>[ODBC][23264][1269453011.641760][SQLAllocHandl=
e.c][364]</div>
<div>   =A0 =A0 =A0 =A0 =A0 =A0 =A0Entry:</div><div>   =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Handle Type =3D 2</div><div>   =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Input Handle =3D 2b048</div><div>[ODBC][=
23264][1269453011.641801][SQLAllocHandle.c][482]</div><div>   =A0 =A0 =
=A0 =A0 =A0 =A0 =A0Exit:[SQL_SUCCESS]</div>
<div>   =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Output Handle =3D 2b=
670</div><div>[ODBC][23264][1269453011.641911][SQLConnect.c][3614]</div><di=
v>   =A0 =A0 =A0 =A0 =A0 =A0 =A0Entry:</div><div>   =A0 =A0 =A0 =A0=
=A0 =A0 =A0 =A0 =A0 =A0 =A0Connection =3D 2b670</div><div>   =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Server Name =3D [DG4ODBC][length =3D 7 (=
SQL_NTS)]</div>
<div>   =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0User Name =3D [NULL]=
</div><div>   =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Authentication=
=3D [NULL]</div><div>[ODBC][23264][1269453011.666745][SQLAllocHandle.c][33=
7]Error: SQL_INVALID_HANDLE</div><div>[ODBC][23264][1269453011.666776][SQLC=
onnect.c][1583]Error: IM005</div>
<div>[ODBC][23264][1269453011.666818][SQLError.c][482]Error: SQL_INVALID_HA=
NDLE</div><div>[ODBC][23264][1269453011.666852][SQLError.c][430]</div><div>=
   =A0 =A0 =A0 =A0 =A0 =A0 =A0Entry:</div><div>   =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0 =A0Connection =3D 2b670</div>
<div>   =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0SQLState =3D ffbff2e=
0</div><div>   =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Native =3D ff=
bff2d8</div><div>   =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Message =
Text =3D ffbff2f0</div><div>   =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0Buffer Length =3D 500</div><div>
   =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Text Len Ptr =3D ffbff2de=
</div><div>[ODBC][23264][1269453011.666894][SQLError.c][467]</div><div>=A0=
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Exit:[SQL_SUCCESS]</div><div>   =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0SQLState =3D IM005</div><div>   =A0 =
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Native =3D ffbff2d8 -&gt; 0</div>
<div>   =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Message Text =3D [[u=
nixODBC][Driver Manager]Driver&#39;s SQLAllocHandle on SQL_HANDLE_DBC faile=
d]</div><div>[ODBC][23264][1269453011.667036][SQLError.c][430]</div><div>=
   =A0 =A0 =A0 =A0 =A0 =A0 =A0Entry:</div>
<div>   =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Connection =3D 2b670=
</div><div>   =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0SQLState =3D f=
fbff2e0</div><div>   =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Native =
=3D ffbff2d8</div><div>   =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Me=
ssage Text =3D ffbff2f0</div><div>
   =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Buffer Length =3D 500</di=
v><div>   =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Text Len Ptr =3D f=
fbff2de</div><div>[ODBC][23264][1269453011.667063][SQLError.c][467]</div><d=
iv>   =A0 =A0 =A0 =A0 =A0 =A0 =A0Exit:[SQL_NO_DATA]</div><div>[ODBC][23=
264][1269453011.667089][SQLError.c][510]</div>
<div>   =A0 =A0 =A0 =A0 =A0 =A0 =A0Entry:</div><div>   =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Environment =3D 2b048</div><div>   =A0 =
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0SQLState =3D ffbff2e0</div><div>=A0=
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Native =3D ffbff2d8</div><di=
v>   =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Message Text =3D ffbff2=
f0</div>
<div>   =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Buffer Length =3D 50=
0</div><div>   =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Text Len Ptr =
=3D ffbff2de</div><div>[ODBC][23264][1269453011.667117][SQLError.c][547]</d=
iv><div>   =A0 =A0 =A0 =A0 =A0 =A0 =A0Exit:[SQL_NO_DATA]</div><div>
[ODBC][23264][1269453011.667178][SQLFreeHandle.c][279]</div><div>   =A0=
=A0 =A0 =A0 =A0 =A0 =A0Entry:</div><div>   =A0 =A0 =A0 =A0 =A0 =A0 =A0=
=A0 =A0 =A0 =A0Handle Type =3D 2</div><div>   =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0Input Handle =3D 2b670</div><div>[ODBC][23264][126945301=
1.667207][SQLFreeHandle.c][194]Error: SQL_INVALID_HANDLE</div>
<div>[ODBC][23264][1269453011.667239][SQLFreeHandle.c][330]</div><div>=A0=
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Exit:[SQL_SUCCESS]</div><div>[ODBC][23264][1=
269453011.667271][SQLFreeHandle.c][212]</div><div>   =A0 =A0 =A0 =A0 =
=A0 =A0 =A0Entry:</div><div>   =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0Handle Type =3D 1</div>
<div>   =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Input Handle =3D 2b0=
48</div><div><br></div><div><br></div><div>===========
===========3D</div><div>Here is my odbc.ini file:</div>=
<div>===============3D</div><div><br></div><div=
><div>[DG4ODBC]</div><div>
Description =3D Services Database</div><div>Driver =3D PostgreSQL</div><div=
>Database =3D vidb05</div><div>Servername =3D 192.168.17.13</div><div>UserN=
ame =3D username</div><div>Password =3D password</div><div>Port =3D 5432</d=
iv><div>ReadOnly =3D No</div>
<div>RowVersioning =3D No</div><div>ShowSystemTables =3D No</div><div>ShowO=
idColumn =3D No</div><div>FakeOidIndex =3D No</div><div>ConnSettings =3D</d=
iv><div><br></div><div>==============</div><div=
>Here is my odbcinst.ini</div><div>
=================3D</div><div><div>[ODBC]</=
div><div>Trace =3D yes</div><div>TraceFile =3D /tmp/trace.log</div><div><br=
></div><div>[PostgreSQL]</div><div>Description =3D PostgreSQL Official ODBC=
Driver</div><div>Driver =3D /usr/tmp/raja/psqlodbc/lib/psqlodbca.so</div>
<div>Debug =3D 1</div><div>CommLog =3D 1</div><div><br></div></div></div></=
div></div>

--0016e6d64861b478b304828fe47d--

Report this message