[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