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.
Oracle LazyDBA home page