[unixODBC-dev] Problem connecting to the DSN

Igor Korot ikorot01 at gmail.com
Sun Jun 5 23:23:06 BST 2016


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

Trying to turn on logging gives:
IgorDellGentoo igor # cat /tmp/sql.log
[ODBC][16276][1465164925.483684][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/__handles.c][460]
                Exit:[SQL_SUCCESS]
                        Environment = 0x1681780
[ODBC][16276][1465164925.483745][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLAllocHandle.c][375]
                Entry:
                        Handle Type = 2
                        Input Handle = 0x1681780
[ODBC][16276][1465164925.483772][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLAllocHandle.c][493]
                Exit:[SQL_SUCCESS]
                        Output Handle = 0x1682080
[ODBC][16276][1465164925.483798][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLConnect.c][3727]
                Entry:
                        Connection = 0x1682080
                        Server Name = [mypdbc-5.2-test][length = 15 (SQL_NTS)]
                        User Name = [root][length = 4 (SQL_NTS)]
                        Authentication = [NULL]
[ODBC][16276][1465164925.484391][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLConnect.c][3935]Error:
IM002
[ODBC][16276][1465164925.484446][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLFreeHandle.c][284]
                Entry:
                        Handle Type = 2
                        Input Handle = 0x1682080
[ODBC][16276][1465164925.484472][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLFreeHandle.c][333]
                Exit:[SQL_SUCCESS]
[ODBC][16276][1465164925.484496][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLFreeHandle.c][219]
                Entry:
                        Handle Type = 1
                        Input Handle = 0x1681780

If I don't provide the password, the driver should ask for it, right?

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