[unixODBC-dev] Problem connecting to the DSN

Igor Korot ikorot01 at gmail.com
Mon Jun 6 14:57:12 BST 2016


Nick,

On Mon, Jun 6, 2016 at 8:35 AM, Nick Gorham <nick at lurcher.org> wrote:
> On 06/06/16 13:24, Igor Korot wrote:
>>
>> Nick,
>>
>> On Mon, Jun 6, 2016 at 6:48 AM, Nick Gorham <nick at lurcher.org> wrote:
>>>
>>> On 06/06/16 11:42, Igor Korot wrote:
>>>>
>>>> Nick,
>>>>
>>>> On Mon, Jun 6, 2016 at 3:18 AM, Nick Gorham <nick at lurcher.org> wrote:
>>>>>
>>>>> On 05/06/16 23:23, Igor Korot wrote:
>>>>>>
>>>>>> Nick,
>>>>>>
>>>>>> On Sun, Jun 5, 2016 at 2:30 PM, Nick Gorham <nick at lurcher.org> wrote:
>>>>>>>
>>>>>>> On 05/06/16 18:27, Igor Korot wrote:
>>>>>>>>
>>>>>>>> Do you see anything wrong with my .ini files?
>>>>>>>
>>>>>>>
>>>>>>> No. I would normally try and connect using isql and see what error
>>>>>>> that
>>>>>>> gives.
>>>>>>
>>>>>> igor at IgorDellGentoo ~/dbhandler $ isql mypdbc-5.2-test root
>>>>>> [ISQL]ERROR: Could not SQLConnect
>>>>>
>>>>>
>>>>> Try
>>>>>
>>>>> isql -v mypdbc-5.2-test root
>>>>
>>>> igor at IgorDellGentoo ~/dbhandler $ isql -v mypdbc-5.2-test root
>>>> [IM002][unixODBC][Driver Manager]Data source name not found, and no
>>>> default driver specified
>>>> [ISQL]ERROR: Could not SQLConnect
>>>
>>>
>>> You get that error if:
>>>
>>> 1. The DSN doesn't exist
>>> 2. The DSN exists, but it points to a driver entry that does not exist in
>>> odbcinst.ini
>>> 3. The DSN exists, but the lib entry it contains for Driver= either
>>> doesn't
>>> exist, or fails to load
>>>
>>> ldd /usr/lib/libmyodbc5a.so
>>>
>>> would be my first move.
>>
>> IgorDellGentoo igor # ls -la /usr/lib/libmyo*
>> -rwxr-xr-x 1 root root 351656 Nov 11  2015 /usr/lib/libmyodbc5a.so
>> -rwxr-xr-x 1 root root 347560 Nov 11  2015 /usr/lib/libmyodbc5w.so
>> IgorDellGentoo igor # ldd /usr/lib/libmyodbc5a.so
>>          linux-vdso.so.1 (0x00007ffccddb5000)
>>          libmysqlclient.so.18 => /usr/lib64/libmysqlclient.so.18
>> (0x00007f403436d000)
>>          libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f4034152000)
>>          libodbcinst.so.2 => /usr/lib64/libodbcinst.so.2
>> (0x00007f4033f3f000)
>>          libdl.so.2 => /lib64/libdl.so.2 (0x00007f4033d3b000)
>>          libc.so.6 => /lib64/libc.so.6 (0x00007f40339a4000)
>>          libz.so.1 => /lib64/libz.so.1 (0x00007f403378d000)
>>          libssl.so.1.0.0 => /usr/lib64/libssl.so.1.0.0
>> (0x00007f403351d000)
>>          libcrypto.so.1.0.0 => /usr/lib64/libcrypto.so.1.0.0
>> (0x00007f4033137000)
>>          libm.so.6 => /lib64/libm.so.6 (0x00007f4032e35000)
>>          /lib64/ld-linux-x86-64.so.2 (0x0000564dc3dc5000)
>>          libltdl.so.7 => /usr/lib64/libltdl.so.7 (0x00007f4032c2b000)
>> IgorDellGentoo igor # nano /etc/unixODBC/odbcinst.ini
>>
>> I changed the driver to be a UNICODE one.
>>
>> IgorDellGentoo igor # ldd /usr/lib/libmyodbc5w.so
>>          linux-vdso.so.1 (0x00007fff45302000)
>>          libmysqlclient.so.18 => /usr/lib64/libmysqlclient.so.18
>> (0x00007efff998f000)
>>          libpthread.so.0 => /lib64/libpthread.so.0 (0x00007efff9774000)
>>          libodbcinst.so.2 => /usr/lib64/libodbcinst.so.2
>> (0x00007efff9561000)
>>          libdl.so.2 => /lib64/libdl.so.2 (0x00007efff935d000)
>>          libc.so.6 => /lib64/libc.so.6 (0x00007efff8fc6000)
>>          libz.so.1 => /lib64/libz.so.1 (0x00007efff8daf000)
>>          libssl.so.1.0.0 => /usr/lib64/libssl.so.1.0.0
>> (0x00007efff8b3f000)
>>          libcrypto.so.1.0.0 => /usr/lib64/libcrypto.so.1.0.0
>> (0x00007efff8759000)
>>          libm.so.6 => /lib64/libm.so.6 (0x00007efff8457000)
>>          /lib64/ld-linux-x86-64.so.2 (0x0000563e5e47d000)
>>          libltdl.so.7 => /usr/lib64/libltdl.so.7 (0x00007efff824d000)
>>
>> IgorDellGentoo igor # ls -la /usr/lib/linux-v*
>> ls: cannot access /usr/lib/linux-v*: No such file or directory
>>
>> Any idea what package I'm missing?
>>
>> Thank you.
>
>
> Seems ok. Check they are all 64 bit

But I'm missing "linux-vds.so.1".
Is it OK?

>
> file `which isql`
> file usr/lib/libmyodbc5w.so
>
> Other than that try strace to see what goes on.

I will check those when I come back home.

Thank you.

>
>
> --
> Nick
> _______________________________________________
> unixODBC-dev mailing list
> unixODBC-dev at mailman.unixodbc.org
> http://mailman.unixodbc.org/mailman/listinfo/unixodbc-dev


More information about the unixODBC-dev mailing list