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

[Nick Gorham]

GianLuca Sarto wrote:
> Nick Gorham wrote:
>> GianLuca Sarto wrote:
>>> Nick Gorham wrote:
>>>> GianLuca Sarto wrote:
>>>>> 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
>>>>>
>>>> I would avoid ODBCConfig and just edit the ini files. You haven't 
>>>> got a setup lib
>>>>
>>> How should I edit my ini files? are there any required entries I 
>>> should add?
>> Should be documented with the driver.
>>
> it should, but it is not.
>
> I'm asking what are the UnixOdbc requirements in the ini files.
>
> If I'm OT or on the wrong list please forgive me.
It fine asking, I just don't know the full answer :-)

All unixODBC needs is a [DSN] section in the odbc.ini file that contains a

Driver = NameofDriver

That refers to a [NameofDriver] section on odbcinst.ini that contains a

Driver = /path/to/the/driver/libdriver.so

All the other entries are up to the driver. Thats why it needs info from 
the driver. I would expect there wil be a sample ini setup somewhere in 
the docs, it would be a mistake assuming that everyone can use (or wants 
to use) the GUI tools.

-- 
Nick