Tux on VM

Last updated on:
Sunday, July 06, 2008

Software

Information

Community

News

Fun

Credits




Valid HTML 4.01!
Linux for Big Iron
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
 

Site hosting courtesy of Velocity Software