Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

SQLAllocHandle failed



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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group