SQLAllocHandle failed

From: Алексей Лутовинин <al(at)mnppsaturn(dot)ru>
To: pgsql-odbc(at)postgresql(dot)org
Subject: SQLAllocHandle failed
Date: 2007-05-14 14:45:34
Message-ID: 4648760E.7050400@mnppsaturn.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi!

I try to use the driver psqlodbc 08.02.0400 together with unixODBC (2.2.11).
Before the driver with the version 08.02.0200 was used, all worked well.
After successful build, installation and adjustment DSN try work by the
utility isql:

#isql mydsn -v
[IM005][unixODBC][Driver Manager]Driver's SQLAllocHandle on
SQL_HANDLE_DBC failed
[ISQL]ERROR: Could not SQLConnect

Identical result for the version UNICODE and ANSI.
Fragment of a file sql.log generated by the manager unixODBC:

sql.log:
[ODBC][31396][__handles.c][444]
Exit:[SQL_SUCCESS]
Environment = 0x8050dd8
[ODBC][31396][SQLAllocHandle.c][345]
Entry:
Handle Type = 2
Input Handle = 0x8050dd8
[ODBC][31396][SQLAllocHandle.c][463]
Exit:[SQL_SUCCESS]
Output Handle = 0x80513b0
[ODBC][31396][SQLConnect.c][3549]
Entry:
Connection = 0x80513b0
Server Name = [archives][length = 8 (SQL_NTS)]
User Name = [NULL]
Authentication = [NULL]
UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'

[ODBC][31396][SQLAllocHandle.c][318]Error: SQL_INVALID_HANDLE
[ODBC][31396][SQLConnect.c][1548]Error: IM005
[ODBC][31396][SQLError.c][476]Error: SQL_INVALID_HANDLE
[ODBC][31396][SQLFreeHandle.c][268]
Entry:
Handle Type = 2
Input Handle = 0x80513b0
[ODBC][31396][SQLFreeHandle.c][185]Error: SQL_INVALID_HANDLE
[ODBC][31396][SQLFreeHandle.c][317]
Exit:[SQL_SUCCESS]
[ODBC][31396][SQLFreeHandle.c][203]
Entry:
Handle Type = 1
Input Handle = 0x8050dd8

With best regards,
Alex Lutovinin

Browse pgsql-odbc by date

  From Date Subject
Next Message Terry Yapt 2007-05-15 07:11:02 Re: Setting null to date field from Delphi.
Previous Message Hiroshi Saito 2007-05-13 18:20:17 Re: non-unicode compiling bug