Fun with ODBC and Oracle

**jacek** · 26th July 2007, 01:14

You have to add a data source to unixODBC, but unfortunately I can't help you with this.

**KaptainKarl** · 26th July 2007, 18:52

This does seem to be a bit of mystery where Suse is concerned. I made sure I have all the ODBC packages installed and unixODBC is among them, but what is missing is the ODBCconfig program which allows you set up Data Sources.

Does anyone know where I can get a version of the Oracle OCI libraries that I could then link with QT to create a QOCI driver in Suse 10?

Karl

**jacek** · 27th July 2007, 11:38

Originally Posted by KaptainKarl

I made sure I have all the ODBC packages installed and unixODBC is among them, but what is missing is the ODBCconfig program which allows you set up Data Sources.

In my distribution, there's separate package with unixODBC tools. AFAIK its equivalent in in SuSE is called unixODBC-gui-qt.

Originally Posted by KaptainKarl

Does anyone know where I can get a version of the Oracle OCI libraries that I could then link with QT to create a QOCI driver in Suse 10?

QOCI driver is available with commercial edition of Qt, because Oracle drivers aren't compatible with GPL. According to the docs, you need "Instant Client Package - Basic" and "Instant Client Package - SDK" (http://www.oracle.com/technology/tec...ent/index.html).

**KaptainKarl** · 27th July 2007, 21:42

Thanks. I was typing the name incorrectly (ODBCconfig instead of ODBCConfig). I ran into a little trouble with an indefined reference but I downloaded a newer version and it worked.

The Oracle Instant Client also worked so I have an Oracle driver built in as well.

Karl