Re: Problem connecting to the DSN

On 06/06/16 11:42, Igor Korot wrote:
> Nick,
>
> On Mon, Jun 6, 2016 at 3:18 AM, Nick Gorham <[email protected]> wrote:
>> On 05/06/16 23:23, Igor Korot wrote:
>>> Nick,
>>>
>>> On Sun, Jun 5, 2016 at 2:30 PM, Nick Gorham <[email protected]> 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@IgorDellGentoo ~/dbhandler $ isql mypdbc-5.2-test root
>>> [ISQL]ERROR: Could not SQLConnect
>>
>> Try
>>
>> isql -v mypdbc-5.2-test root
> igor@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
_______________________________________________
unixODBC-dev mailing list
[email protected]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-dev