Neale, If you can, would you try to document exactly what you did to get this to go? I'm sure a lot of other people would like some help here. In the meantime, I'm flaming you on the linuxvm.org web site for your bad memory.
Mark -----Original Message----- From: Ferguson, Neale [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 05, 2001 12:31 PM To: [EMAIL PROTECTED] Subject: Oracle 9i - ODBC 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
