[egenix-users] Error message: ('IM004', 0, "[unixODBC][Driver Manager]Driver'sSQLA llocHandle on SQL_HANDLE_HENV failed", 8227)

[Gianluca Mattiuzzi]

*Dear,
when I try to connect to Oracle 10g with mxODBC DA Plone reports this 
error :*

-------------------------
Problem connecting to the database

      Connection string: DSN=DBTEST

    Connection pool entry: 0

    Error message: ('IM004', 0, "[unixODBC][Driver Manager]Driver's SQLA 
llocHandle on SQL_HANDLE_HENV failed", 8227)
-------------------------

*The unixODBC log is :*

-------------------------
[ODBC][1280][SQLAllocHandle.c][345]
        Entry:
            Handle Type = 2
            Input Handle = 0xa85a4b0
[ODBC][1280][SQLAllocHandle.c][463]
        Exit:[SQL_SUCCESS]
            Output Handle = 0xbaa45d8
[ODBC][1280][SQLDriverConnect.c][678]
        Entry:           
            Connection = 0xbaa45d8           
            Window Hdl = (nil)           
            Str In = [DSN=DBTEST;UID=reporter;PWD=**********][length = 
38 (SQL_NTS)]           
            Str Out = 0x5c491f8           
            Str Out Max = 512           
            Str Out Ptr = 0x5c491f6           
            Completion = 0
        UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'

[ODBC][1280][SQLConnect.c][1293]Error: IM004
[ODBC][1280][SQLError.c][424]
        Entry:               
            Connection = 0xbaa45d8               
            SQLState = 0x5c48f78               
            Native = 0x5c48f70               
            Message Text = 0x5c48f88               
            Buffer Length = 511               
            Text Len Ptr = 0x5c48f76
[ODBC][1280][SQLError.c][461]
        Exit:[SQL_SUCCESS]                   
            SQLState = IM004                   
            Native = 0x5c48f70 -> 0                   
            Message Text = [[unixODBC][Driver Manager]Driver's 
SQLAllocHandle on SQL_HANDLE_HENV failed]
[ODBC][1280][SQLError.c][424]
        Entry:               
            Connection = 0xbaa45d8               
            SQLState = 0x5c48f78               
            Native = 0x5c48f70               
            Message Text = 0x5c48f88               
            Buffer Length = 511               
            Text Len Ptr = 0x5c48f76
[ODBC][1280][SQLError.c][461]
        Exit:[SQL_NO_DATA]
[ODBC][1280][SQLFreeHandle.c][268]
        Entry:
            Handle Type = 2
            Input Handle = 0xbaa45d8
[ODBC][1280][SQLFreeHandle.c][317]
        Exit:[SQL_SUCCESS]
[ODBC][1280][SQLAllocHandle.c][345]
        Entry:
            Handle Type = 2
            Input Handle = 0xa85a4b0
[ODBC][1280][SQLAllocHandle.c][463]
        Exit:[SQL_SUCCESS]
            Output Handle = 0xbaa45d8
[ODBC][1280][SQLDriverConnect.c][678]
        Entry:           
            Connection = 0xbaa45d8           
            Window Hdl = (nil)           
            Str In = [DSN=DBTEST;UID=reporter;PWD=**********][length = 
38 (SQL_NTS)]           
            Str Out = 0x5c491f8           
            Str Out Max = 512           
            Str Out Ptr = 0x5c491f6           
            Completion = 0
        UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'

[ODBC][1280][SQLConnect.c][1293]Error: IM004
[ODBC][1280][SQLError.c][424]
        Entry:               
            Connection = 0xbaa45d8               
            SQLState = 0x5c48f78               
            Native = 0x5c48f70               
            Message Text = 0x5c48f88               
            Buffer Length = 511               
            Text Len Ptr = 0x5c48f76
[ODBC][1280][SQLError.c][461]
        Exit:[SQL_SUCCESS]                   
            SQLState = IM004                   
            Native = 0x5c48f70 -> 0                   
            Message Text = [[unixODBC][Driver Manager]Driver's 
SQLAllocHandle on SQL_HANDLE_HENV failed]
[ODBC][1280][SQLError.c][424]
        Entry:               
            Connection = 0xbaa45d8               
            SQLState = 0x5c48f78               
            Native = 0x5c48f70               
            Message Text = 0x5c48f88               
            Buffer Length = 511               
            Text Len Ptr = 0x5c48f76
[ODBC][1280][SQLError.c][461]
        Exit:[SQL_NO_DATA]
[ODBC][1280][SQLFreeHandle.c][268]
        Entry:
            Handle Type = 2
            Input Handle = 0xbaa45d8
[ODBC][1280][SQLFreeHandle.c][317]
        Exit:[SQL_SUCCESS]
[ODBC][1280][SQLAllocHandle.c][345]
        Entry:
            Handle Type = 2
            Input Handle = 0xa85a4b0
[ODBC][1280][SQLAllocHandle.c][463]
        Exit:[SQL_SUCCESS]
            Output Handle = 0xbaa45d8
[ODBC][1280][SQLDriverConnect.c][678]
        Entry:           
            Connection = 0xbaa45d8           
            Window Hdl = (nil)           
            Str In = [DSN=DBTEST;UID=reporter;PWD=**********][length = 
38 (SQL_NTS)]           
            Str Out = 0x5c491f8           
            Str Out Max = 512           
            Str Out Ptr = 0x5c491f6           
            Completion = 0
        UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'

[ODBC][1280][SQLConnect.c][1293]Error: IM004
[ODBC][1280][SQLError.c][424]
        Entry:               
            Connection = 0xbaa45d8               
            SQLState = 0x5c48f78               
            Native = 0x5c48f70               
            Message Text = 0x5c48f88               
            Buffer Length = 511               
            Text Len Ptr = 0x5c48f76
[ODBC][1280][SQLError.c][461]
        Exit:[SQL_SUCCESS]                   
            SQLState = IM004                   
            Native = 0x5c48f70 -> 0                   
            Message Text = [[unixODBC][Driver Manager]Driver's 
SQLAllocHandle on SQL_HANDLE_HENV failed]
[ODBC][1280][SQLError.c][424]
        Entry:               
            Connection = 0xbaa45d8               
            SQLState = 0x5c48f78               
            Native = 0x5c48f70               
            Message Text = 0x5c48f88               
            Buffer Length = 511               
            Text Len Ptr = 0x5c48f76
[ODBC][1280][SQLError.c][461]
        Exit:[SQL_NO_DATA]
[ODBC][1280][SQLFreeHandle.c][268]
        Entry:
            Handle Type = 2
            Input Handle = 0xbaa45d8
[ODBC][1280][SQLFreeHandle.c][317]
        Exit:[SQL_SUCCESS]
-------------------------
*
The problem is the same if I connect with isql without set $ORACLE_HOME.
Can I tell to mxODBC DA where is the Oracle Home?
There is a workaround or a special Linux configuration?
*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: /mailman-archives/egenix-users/attachments/20061215/e6e201c7/attachment.htm