[egenix-users] help

Fabio Rizzo Matos fabiorizzo at gmail.com
Fri Dec 15 14:19:54 CET 2006


the user that run zope, must set this variables. do you do that?

On 12/15/06, Gianluca Mattiuzzi <g.mattiuzzi at miriade.it> wrote:
>
> Dear,
> what are the varibles?
> how I can set the variables?
>
> I set ORACLE_HOME :
> export ORACLE_HOME=<path>
>
> with isql it's all ok, but in mxODBC DA an error occur.
>
> Fabio Rizzo Matos ha scritto:
> > 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
> > <mailto: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 <mailto:fabiorizzo at threepointsweb.com>
> > ----
>
>
>


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


More information about the egenix-users mailing list