SQLAllocHandle failed

SQLAllocHandle failed

am 14.05.2007 16:45:34 von Al

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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match