[unixODBC-support] how to connect to oracle xe?

[GianLuca Sarto]

Nick,

thanks for your kind reply.

I am not sure I fully understood the Oracle ReadME, but I managed to 
install the driver.

Well, almost...

ODBCConfig crashes when I try to configure the driver:
gian at hp-gls:/usr/lib/oracle/instantclient_10_2$ sudo ODBCConfig
ODBCConfig: libltdl/ltdl.c:1178: try_dlopen: Assertion `filename && 
*filename' failed.
Aborted

This is what I've done:

1. ensured that instant client was setup:
gian at hp-gls:/usr/lib/oracle/instantclient_10_2$ ./sqlplus 
user/pwd@//192.168.1.126:1521/XE

2. make script executable:
gian at hp-gls:/usr/lib/oracle/instantclient_10_2$ sudo chmod a+x 
odbc_update_ini.sh

3. run script:
gian at hp-gls:/usr/lib/oracle/instantclient_10_2$ sudo ./odbc_update_ini.sh /

4. content of odbc.ini
gian at hp-gls:/usr/lib/oracle/instantclient_10_2$ cat /etc/odbc.ini
[oracle]
Driver        = /usr/lib/oracle/instantclient_10_2/libsqora.so.10.1
Database    = //192.168.1.126:1521/XE
User        = user
Password    = pwd

5. content of odbcinst.ini
gian at hp-gls:/usr/lib/oracle/instantclient_10_2$ cat /etc/odbcinst.ini
[Oracle 10g ODBC driver]
Description     = Oracle ODBC driver for Oracle 10g
Driver          = /usr/lib/oracle/instantclient_10_2/libsqora.so.10.1
Setup           =
FileUsage       =
CPTimeout       =
CPReuse         =

I must have missed something...
-Gian

Nick Gorham wrote:
> GianLuca Sarto wrote:
>> Hello All,
>>
>> I was ready to leave my XP Desktop and move it to Ubuntu Karmic, when 
>> I realized that I never tried my OpenOffice Base queries on Linux.
>>
>> I installed the Oracle Instant Client Basic and Odbc, and it works, 
>> i.e. I can connect to our Oracle XE database with SqlPlus.
>>
>> However, no matter how I googled, I wasn't able to find a tutorial or 
>> how-to setup the Oracle driver with UnixOdbc. 
>> gian at hp-gls:/usr/lib/oracle/instantclient_10_2$ sudo ODBCConfig
>> ODBCConfig: libltdl/ltdl.c:1178: try_dlopen: Assertion `filename && 
>> *filename' failed.
>> Aborted
>>
>> I did find that Easysoft has commercial solutions for this issue, but 
>> I can't afford 1500 euro: I'd rather keep my XP desktop... :-(
>>
>> thanks for your time,
>> -GianLuca
> I think the XE driver itself contains docs about setting up with unixODBC
>