From: | Dmitry Pogorelov <dalex005(at)gmail(dot)com> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | PSQL iODBC driver on mac os x 10.10.3 (Yosemite) |
Date: | 2015-08-02 19:13:06 |
Message-ID: | CAKELO4iqP1P1YjVah=f=u787kPN76yRixwxLYGHs1L_ZAzJQ5g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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.
Best Regards
Dmitry Pogorelov
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2015-08-03 14:48:48 | Re: PSQL iODBC driver on mac os x 10.10.3 (Yosemite) |
Previous Message | Heikki Linnakangas | 2015-08-01 18:06:54 | Re: odbc vs. libpq performance |