Last updated on: Sunday, July 06, 2008
Software
Information
Community
News
Fun
Credits
|
Title: |
Oracle 9i and ODBC |
Categories/Keywords: |
database: oracle, odbc, connection, driver |
Contributors: |
Neale Ferguson |
Write Up By: |
"Samy Rengasamy" snrsamy@yahoo.com |
If you're interested in Oracle 9i and ODBC this may be of interest:
I installed Oracle 9i on one of our SuSE Linux Enterprise Server 7 for
S/390 systems and worked on getting it to talk ODBC.
I had to copy header files from a Solaris Oracle system we have
that can be found in rdbms/demo subdirectory and another whose
name I can't recall.
I built unixODBC-2.0.8 and an open source ODBC driver for Oracle
from Easysoft (oracle-0.0.3). Using these tools I managed to get
an ODBC connection to the database:
[oracle@reslx390 - oracle-0.0.3] isql -v oracle
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL> select tname from system.syscatalog where creator='SCOTT'
+--------------------------------------------+
TNAME |
+--------------------------------------------+
| BONUS |
| DEPT |
| EMP |
| LINEITEM |
| PROJ |
| SALGRADE |
+--------------------------------------------+
6 rows affected
The only problem I've found is that the driver seems to have
problems with CLOBs.
Here are the configuration files:
#
# odbc.ini
#
[ODBC Data Sources]
oracle = Oracle 9i for Linux/390
[oracle]
Driver = oracle-driver
Description =
ServerName = ora901
User = scott
Password = tiger
#
# odbcinst.ini
#
[oracle-driver]
Description = OpenSource Oracle Driver
Driver = /opt/unixODBC/lib/liboraodbc.so.1.0.0
DontDLClose = 1
|