Thread: SQLAllocHandle failed

SQLAllocHandle failed

From
Алексей Лутовинин
Date:
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