Oracle Database Discussions

I am trying to set up ODBC on Red Hat Enterprise Linux ES release 4 (Nahant Update 4). My odbc.ini and odbcinst.ini are modelled after those provided by Oracle. I display them below.

I have 2 problems.

1. /usr/bin/iodbctest fails because it doesn't know about bcuMsgBoxError.

$ /usr/bin/iodbctest
iODBC Demonstration program
This program shows an interactive SQL processor
Driver Manager: 03.52.0507.0105

Enter ODBC connect string (? shows list): ?

DSN | Driver
------------------------------------------------------------------------------
Oracle | Oracle 10g driver

Enter ODBC connect string (? shows list): DSN=Oracle;UID=craig;PWD=<removed>

1: SQLDriverConnect = [iODBC][Driver Manager]/oracle/product/10.2.0/db_1/lib/libsqora.so.10.1: undefined symbol: bcuMsgBoxError (0) SQLSTATE=00000
2: SQLDriverConnect = [iODBC][Driver Manager]Specified driver could not be loaded (0) SQLSTATE=IM003

The specified driver, /oracle/product/10.2.0/db_1/lib/libsqora.so.10.1, exists.

2./usr/bin/ODBCConfig crashes and nothing is written to the log file.
When I open ODBCConfig, click on the “System DSN” tab, click on the Oracle line, click on the Configure button, ODBCConfig crashes without displaying any errors.

Any suggestions are appreciated. More details are given below.

Thanks,
Griff


My odbc.ini and odbcinst.ini are modelled after those in odbc_update_ini.sh. This script is available from http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/linuxsoft.html in the instantclient-odbc-linux32-10.2.0.3-20061115.zip.

$ cat /etc/odbcinst.ini
[Oracle_10g_Driver]
Description = ODBC driver for Oracle in odbcinst.ini
Driver = /oracle/product/10.2.0/db_1/lib/libsqora.so.10.1
Setup =
FileUsage =
CPTimeout =
CPReuse =

# added by ODBCConfig
[ODBC]
Trace = Yes
TraceFile = /tmp/odbc_trace.txt
ForceTrace = Yes
Pooling = No

$ cat /etc/odbc.ini
[ODBC Data Sources]
Oracle = Oracle 10g driver

[Oracle]
Description = Oracle in /etc/odbc.ini
Driver = Oracle_10g_Driver
DSN = Oracle
Application Attributes = T
Attributes = W
BatchAutocommitMode = IfAllSuccessful
BindAsFLOAT = F
CloseCursor = F
DisableDPM = F
DisableMTS = T
EXECSchemaOpt =
EXECSyntax = T
Failover = T
FailoverDelay = 10
FailoverRetryCount = 10
FetchBufferSize = 64000
ForceWCHAR = F
Lobs = T
Longs = T
MetadataIdDefault = F
QueryTimeout = T
ResultSets = T
ServerName =
SQLGetData extensions = F
Translation DLL =
Translation Option = 0
DisableRULEHint = T
UserID =


$ echo $ORACLE_HOME
/oracle/product/10.2.0/db_1

$ echo $ORACLE_SID
CRAIGSDB

$ echo $LD_LIBRARY_PATH
/oracle/product/10.2.0/db_1/lib

$ echo $TNS_ADMIN
/oracle/product/10.2.0/db_1/network/admin
$ ls -l $TNS_ADMIN | grep -i \\.ora
-rw-r----- 1 oracle oinstall 502 Apr 24 13:36 listener.ora
-rw-r----- 1 oracle oinstall 183 Apr 20 23:37 sqlnet.ora
-rw-r----- 1 oracle oinstall 549 Apr 24 13:36 tnsnames.ora


$ rpm -qa | grep -i odbc
libiodbc-3.52.5-1
unixODBC-2.2.11-1.RHEL4.1
MyODBC-2.50.39-21.RHEL4.1
libiodbc-admin-3.52.5-1
php-odbc-4.3.9-3.22.4
libiodbc-devel-3.52.5-1
qt-ODBC-3.3.3-10.RHEL4
unixODBC-kde-2.2.11-1.RHEL4.1

$ rpm -qa | grep -i ora
libtheora-1.0alpha3-5
oracle-instantclient-basic-10.2.0.3-1

rpm -qa | grep -i libsqora returns nothing but /oracle/product/10.2.0/db_1/lib/libsqora.so.10.1 exists.