Re: PSQL iODBC driver on mac os x 10.10.3 (Yosemite) - Mailing list pgsql-odbc
From | Adrian Klaver |
---|---|
Subject | Re: PSQL iODBC driver on mac os x 10.10.3 (Yosemite) |
Date | |
Msg-id | 55BF7F50.9020303@aklaver.com Whole thread Raw |
In response to | PSQL iODBC driver on mac os x 10.10.3 (Yosemite) (Dmitry Pogorelov <dalex005@gmail.com>) |
List | pgsql-odbc |
On 08/02/2015 12:13 PM, Dmitry Pogorelov wrote: > 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 > <https://ftp.postgresql.org/pub/odbc/versions/src/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. All I can think to do is enable MyLog and/or CommLog: https://odbc.postgresql.org/docs/config.html and see what happens when you use LO or Excel. FYI, logging in particular MyLog, will really slow things down. > > Best Regards > Dmitry Pogorelov -- Adrian Klaver adrian.klaver@aklaver.com
pgsql-odbc by date: