Re: Connection failed [was: Re: Distribution package for OSX]
От | Igor Korot |
---|---|
Тема | Re: Connection failed [was: Re: Distribution package for OSX] |
Дата | |
Msg-id | CA+FnnTwrO2RkDeVYoB-U5aTrQvcD7uSvzHt0iorOirCWFOhSBA@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Connection failed [was: Re: Distribution package for OSX] (Adrian Klaver <adrian.klaver@aklaver.com>) |
Список | pgsql-odbc |
Adrian, On Wed, Dec 7, 2016 at 12:15 AM, Adrian Klaver <adrian.klaver@aklaver.com> wrote: > On 12/06/2016 08:48 PM, Igor Korot wrote: >> >> Hi, guys, >> So I moved a little further with this. >> >> First of all I found out that default OSX install comes with client tools >> pre-installed. No server. >> >> So I installed the PostgreSQL server on my Mac. >> >> Next is trying to connect with iODBC. >> >> But first I tried to open SQL Shell (psql). Here is the session log: >> >> [code] >> Last login: Tue Dec 6 23:11:08 on ttys001 >> /Library/PostgreSQL/9.1/scripts/runpsql.sh; exit >> Igors-MacBook-Air:~ igorkorot$ /Library/PostgreSQL/9.1/scripts/runpsql.sh; >> exit >> Server [localhost]: >> Database [postgres]: >> Port [5432]: >> Username [postgres]: >> Password for user postgres: >> psql (9.1.24) >> Type "help" for help. >> >> postgres=# \q >> logout >> >> [Process completed] >> [/code] >> >> So I presume that the server is running. >> >> Next I tried to configure ODBC. Since there is no psqlODBCS.so to >> setup the connection, >> I tried to do it manually. >> >> Here are the files: >> >> [code] >> Igors-MacBook-Air:~ igorkorot$ cat .odbcinst.ini >> [ODBC Drivers] >> MySQL ODBC 5.3 Unicode Driver = Installed >> MySQL ODBC 5.3 ANSI Driver = Installed >> PostgreSQL Unicode Driver = Installed >> >> [ODBC Connection Pooling] >> PerfMon = 0 >> Retry Wait = >> >> [MySQL ODBC 5.3 Unicode Driver] >> Driver = /usr/local/lib/libmyodbc5w.so >> >> [MySQL ODBC 5.3 ANSI Driver] >> Driver = /usr/local/lib/libmyodbc5a.so >> >> [PostgreSQL Unicode Driver] >> Driver = /usr/local/lib/psqlodbcw.so >> >> Igors-MacBook-Air:~ igorkorot$ cat .odbc.ini >> [ODBC Data Sources] >> myodbc = MySQL ODBC 5.3 Unicode Driver >> myodbca = MySQL ODBC 5.3 ANSI Driver >> postgre = PostgreSQL Unicode Driver >> >> [ODBC] >> Trace = 0 >> TraceAutoStop = 0 >> TraceFile = >> TraceLibrary = >> >> [myodbc] >> Driver = MySQL ODBC 5.3 Unicode Driver >> SERVER = localhost >> PORT = 3306 >> >> [myodbca] >> Driver = MySQL ODBC 5.3 ANSI Driver >> SERVER = localhost >> PORT = 3306 >> >> [postgre] >> Driver = PostgreSQL Unicode Driver >> SERVER = localhost >> PORT = 5432 >> User = postgres >> Password = wasqra >> Database = postgres >> [/code] > > > If I am following this: > > http://www.iodbc.org/dataspace/doc/iodbc/wiki/iodbcWiki/FAQ#What%27s%20an%20odbc.ini%20and%20what%20do%20I%20put%20in%20it%3F > > then should it not be: > > [postgre] > Driver = /usr/local/lib/psqlodbcw.so > host = localhost > SERVER = localhost > ServerName = localhost > PORT = 5432 > UserName = postgres > Password = wasqra > Database = postgres Thank you for the help. Changing the ~/odbc.ini as per your writing made my code connect to the DB. > >> >> Please tell me if I made a mistake configuring the DSN. >> >> Now when trying to connect to the database I'm getting following error: > > > How did you connect? > >> >> [quote] >> Could not connect to server. No such file or directory. >> [/quote] >> >> Also, just for the reference, here is the files in /usr/local/lib: >> >> [code] >> Igors-MacBook-Air:~ igorkorot$ ls -la /usr/local/lib/ >> total 27152 >> drwxr-xr-x 14 root wheel 476 Dec 3 10:45 . >> drwxrwxr-x 9 root wheel 306 Jun 4 2016 .. >> -rwxr-xr-x 1 root wheel 367404 Jan 12 2016 >> libcppunit-1.12.1.0.0.dylib >> lrwxr-xr-x 1 root wheel 27 Jan 12 2016 >> libcppunit-1.12.1.dylib -> libcppunit-1.12.1.0.0.dylib >> -rw-r--r-- 1 root wheel 3740688 Jan 12 2016 libcppunit.a >> lrwxr-xr-x 1 root wheel 27 Jan 12 2016 libcppunit.dylib -> >> libcppunit-1.12.1.0.0.dylib >> -rwxr-xr-x 1 root wheel 860 Jan 12 2016 libcppunit.la >> -rwxr-xr-x 1 root wheel 4604056 Jun 18 2014 libmyodbc5a.so >> -rwxr-xr-x 1 root wheel 4600096 Jun 18 2014 libmyodbc5w.so >> drwxr-xr-x 3 root wheel 102 Jan 12 2016 pkgconfig >> -rwxr-xr-x 1 root wheel 945 Dec 3 10:45 psqlodbcw.la >> -rwxr-xr-x 1 root wheel 555716 Dec 3 10:45 psqlodbcw.so >> lrwxr-xr-x 1 root wheel 16 Jan 31 2016 wxPython -> >> wxPython-3.0.2.0 >> drwxr-xr-x 6 root wheel 204 Nov 27 2014 wxPython-3.0.2.0 >> [/code] >> >> Could anyone spot an error? >> Or maybe I have to have a non-default database in order to connect via >> ODBC? >> >> Thank you. >> >> P.S.: Hopefully the mailer will understand that there is a >> continuation of the old thread... >> >> On Sat, Dec 3, 2016 at 2:30 PM, Adrian Klaver <adrian.klaver@aklaver.com> >> wrote: >>> >>> On 12/03/2016 11:00 AM, Igor Korot wrote: >>>> >>>> >>>> Adrian, >>> >>> >>> >>>> >>>> Thank you. >>>> >>>> BTW, is there a setup library generated? Maybe that the reason the >>>> driver >>>> is >>>> not in the list? >>>> >>>>> >>> >>> To add: >>> >>> http://www.iodbc.org/dataspace/doc/iodbc/wiki/iodbcWiki/ODBCOnUnix >>> >>> >>> -- >>> Adrian Klaver >>> adrian.klaver@aklaver.com >> >> > > > -- > Adrian Klaver > adrian.klaver@aklaver.com
В списке pgsql-odbc по дате отправления:
Предыдущее
От: Igor KorotДата:
Сообщение: Re: Connection failed [was: Re: Distribution package for OSX]
Следующее
От: sunshavi@fastmail.fm (Andrés Ramírez)Дата:
Сообщение: [ODBC] weird problem when running a sql stmt