Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » suse oracle »

[suse-oracle] Oracle ODBC

Manuel Soriano

2005-09-30

Replies:

Hi gents,

I get this error with the unixODBC DataManager with the Oracle ODBC driver :

Driver's SQLAllocHandle on SQL_HANDLE_HENV failed

My /etc/unixODBC/odbcinst.ini :

=======================
[OracleODBC-10g]
Description    = Oracle ODBC driver for Oracle 10g
Driver    = /home/manu/misc/Oracle/ODBC/libsqora.so.10.1
Driver64    =
Setup    =
Setup64    =
UsageCount    = 1
CPTimeout    =
CPReuse    =

[PostgreSQL]
Description    = PostgreSQL driver for Linux & Win32
Driver    = /usr/lib/unixODBC/libodbcpsql.so
Setup    = /usr/lib/unixODBC/libodbcpsqlS.so
UsageCount    = 1
=========================

My ~/.odbc.ini :

=========================
[OracleODBC-10g]
Application Attributes = T
Attributes = W
BatchAutocommitMode = IfAllSuccessful
CloseCursor = F
DisableDPM = F
DisableMTS = T
Driver = OracleODBC-10g
DSN = OracleODBC-10g
EXECSchemaOpt =
EXECSyntax = T
Failover = T
FailoverDelay = 10
FailoverRetryCount = 10
FetchBufferSize = 64000
ForceWCHAR = F
Lobs = T
Longs = T
MetadataIdDefault = F
QueryTimeout = T
ResultSets = T
ServerName = ora10g3.michuka
SQLGetData extensions = F
Translation DLL =
Translation Option = 0
UserID = manu
[PostgreSQL]
Description      = Test to Postgres
Driver         = PostgreSQL
Trace          = Yes
TraceFile       = sql.log
Database        = manu
Servername       = localhost
UserName        =
Password        =
Port           = 5432
Protocol        = 6.4
ReadOnly        = No
RowVersioning     = No
ShowSystemTables   = No
ShowOidColumn     = No
FakeOidIndex     = No
ConnSettings     =
===============================

Postgres is working fine....

Any idea ?

Thanks...

--

Bye, Manu.

  (o_.'           Break the rules! Break the windows! Use Linux!
  //\c{}    \|/    manu at valux.org  http://www.valux.org
  V__)_     0-0    Linux is here to stay. FUD won't make it go away.
  *****---oOo-(_)-oOo---**********************************************
  * Manuel Soriano   * Lo Perello/Valencia/Spain * ( AbM Compliant )
 Linux Counter NÂș: 294597

--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting

©2008 dba.5341.com - Jax Systems, LLC, U.S.A.