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

[GianLuca Sarto]

Nick Gorham wrote:
> 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.
>
it's fine for me to use the command line, but reading unixODBC docs I found:
*NOTE: odbc.ini and odbcinst.ini are considered to be ODBC System 
Information. All access (read or write) to this System Information 
should occur via the Driver Manager or the ODBCINST 
<http://www.unixodbc.org/utilities.html> share library. Do not access 
these INI files directly!

*That's why I tried ODBCConfig.

I 'll go on googling...

thanks for your help,
-Gian


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20100102/f22df5e5/attachment.html>