Postgres Pro
Downloads
Home   >   mailing lists

PSQL iODBC driver on mac os x 10.10.3 (Yosemite) - Mailing list pgsql-odbc

From Dmitry Pogorelov
Subject PSQL iODBC driver on mac os x 10.10.3 (Yosemite)
Date
Msg-id CAKELO4iqP1P1YjVah=f=u787kPN76yRixwxLYGHs1L_ZAzJQ5g@mail.gmail.com
Whole thread Raw
Responses Re: PSQL iODBC driver on mac os x 10.10.3 (Yosemite)
List pgsql-odbc
Tree view
Hi,

I've got postges 9.4 installed on Mac OS X 10.10.3 (Yosemite) I have access to it from psql and I have set up and filled a database I now want to access via ODBC - all on the localhost, no remote access involved. To get the 32 bit PSQL iODBC driver I've run the following command on the latest source code (psqlodbc-09.03.0400.tar.gz): 

./configure CFLAGS="-arch i386 -D ENABLE_MYLOG" --with-iodbc=/usr/local/iODBC --with-libpq=/Library/PostgreSQL/9.4

make

I've also built the latest version (3.52.10) of iODBC (https://github.com/openlink/iODBC) by the instruction from https://github.com/openlink/iODBC/blob/develop/README.MACOSX link (see method 1).

Further I copied the built in first step PSQL iODBC driver to /Library/ODBC/PSQL/bin/iODBC/ folder, I also added all necessaries libs:
1. iODBC from /Library/Frameworks/iODBC.framework/Versions/3.52/iODBC,
2. iODBCinst from /Library/Frameworks/iODBCinst.framework/Versions/3.52/iODBCinst
3. libpq.5.dylib from /Library/PostgreSQL/9.4/lib/libpq.5.7.dylib (renamed it to libpq.5.dylib)
4. libssl.1.0.0.dylib from /usr/local/Cellar/openssl/1.0.2/lib (installed openssl via brew)
 to /Library/ODBC/test/lib folder and changed paths to .dylib in built psql driver by the following commands:

install_name_tool -change libssl.1.0.0.dylib /Library/ODBC/PSQL/lib/libssl.1.0.0.dylib /Library/ODBC/PSQL/bin/iODBC/psqlodbcw.so

install_name_tool -change libpq.5.dylib /Library/ODBC/PSQL/lib/libpq.5.dylib /Library/ODBC/PSQL/bin/iODBC/psqlodbcw.so

install_name_tool -change /Library/Frameworks/iODBC.framework/Versions/3.52/iODBC /Library/ODBC/PSQL/lib/iODBC /Library/ODBC/PSQL/bin/iODBC/psqlodbcw.so

install_name_tool -change /Library/Frameworks/iODBCinst.framework/Versions/3.52/iODBCinst /Library/ODBC/PSQL/lib/iODBCinst /Library/ODBC/PSQL/bin/iODBC/psqlodbcw.so

I've also created odbc.ini and odbcinst.ini files in /Library/ODBC folder. The odbc.ini contains:

[ODBC Data Sources]

PSQL_Unicode_32           = PSQL iODBC Driver 32 bit (Unicode)

[PSQL_Unicode_32]

Driver           = /Library/ODBC/PSQL/bin/iODBC/psqlodbcw.so

ServerName       = 127.0.0.1

Port             = 5432

Database         = test_tables

Username         = postgres

Password         = sa

UpdatableCursors = false

The odbcinst.ini contains:

[ODBC Drivers]

PSQL iODBC Driver 32 bit (Unicode)            = Installed

[PSQL iODBC Driver 32 bit (Unicode)]

Driver = /Library/ODBC/PSQL/bin/iODBC/psqlodbcw.so

Setup  =

In the OpenLink ODBC Administrator I can see the configured odbc driver and the driver also passes test connection.
Further I installed LibreOffice 4.3.7 32 bit to check the PSQL Driver 32 bit. So when I tried to connect to PostgreSQL via PSQL iODBC driver I couldn't get list of tables though sql queries worked correctly (the problem was only in getting of list tables). After that I installed the latest version of Microsoft Excel 2016 on mac (Microsoft Office for mac is supplied as 32 bit so far), when I also tried to connect to PostgreSQL via PSQL iODBC driver the Excel just hanged though on Windows both LibreOffice of the same version and Excel worked correctly. Could you please help me to solve the problem related to LibreOffice (couldn't get list of tables) and Excel 2016?
 
Thank you in advance.

Best Regards
Dmitry Pogorelov

pgsql-odbc by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: odbc vs. libpq performance
Next
From: Adrian Klaver
Date:
Subject: Re: PSQL iODBC driver on mac os x 10.10.3 (Yosemite)