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

Nick Gorham nick at lurcher.org
Sat Jan 2 12:34:57 GMT 2010


GianLuca Sarto wrote:
> 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!
>
> *
Ok, I should read the docs sometime :-)

But I would hope the above is more about applications reading and 
writing the libs. Anyway, its your system edit what you want, its just a 
text file no hidden magic.

-- 
Nick


More information about the unixODBC-support mailing list