Connection failed [was: Re: Distribution package for OSX] - Mailing list pgsql-odbc

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]

Please tell me if I made a mistake configuring the DSN.

Now when trying to connect to the database I'm getting following error:

[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