[egenix-users] help

Fabio Rizzo Matos fabiorizzo at gmail.com
Fri Dec 15 13:46:56 CET 2006


Hi Gianluca,

You set the variables of the Oracle? you need to set then to run correctly
the connection.

Cheers

On 12/15/06, Gianluca Mattiuzzi <g.mattiuzzi at miriade.it> wrote:
>
> *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.
> With $ORACLE_HOME set isql work, but mxODBC DA return the error.
> Can I tell to mxODBC DA where is the Oracle Home?
> Is there a workaround or a special Linux configuration?ù
>
> THANK YOU FOR SUPPORT
>
> BYE
> *
>
>
> _______________________________________________________________________
> eGenix.com User Mailing List                     http://www.egenix.com/
> https://www.egenix.com/mailman/listinfo/egenix-users
>



-- 
Fabio Rizzo
ThreePointsWeb
fabiorizzo at threepointsweb.com
------------------ next part --------------
An HTML attachment was scrubbed...
URL: /mailman-archives/egenix-users/attachments/20061215/c7f080a9/attachment.htm


More information about the egenix-users mailing list