[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