| 
        
 
    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 
 |