Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

Catastrophic failure Unexpected method call sequence. 0x8000ffff (-2147418113)., ksh lock a file, [unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_DBC failed, sed: -e expression #1, char 1: unterminated address regex, procmail + change subject, w2ksp4.exe download, /proc/kallsyms format, sqldatasource dal, wwwxxxenden, convert raid5 to raid 10 mdadm

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