[unixODBC-dev] Problem connecting to the DSN

Nick Gorham nick at lurcher.org
Mon Jun 6 11:48:04 BST 2016


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.

-- 
Nick


More information about the unixODBC-dev mailing list