Re: Problem connecting to the DSN
Igor Korot <[email protected]> Sun, 5 Jun 2016 18:23:06 -0400
| Newsgroups | gmane.comp.db.unixodbc.devel |
|---|---|
| Message-ID | <CA+FnnTxOipemBcyGnJf6V=2SMQnXePwRP=BrXnMuQKwsDgG-Qg@mail.gmail.com> |
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 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 > [email protected] > http://mailman.unixodbc.org/mailman/listinfo/unixodbc-dev _______________________________________________ unixODBC-dev mailing list [email protected] http://mailman.unixodbc.org/mailman/listinfo/unixodbc-dev