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