This version of Excel does provide an ODBC driver for connecting to SQL Server Databases. On the Data tab, click New Database Query > SQL Server ODBC.
Installnametool -change libssl.1.0.0.dylib /Library/ODBC/PSQL/lib/libssl.1.0.0.dylib /Library/ODBC/PSQL/bin/iODBC/psqlodbcw.so installnametool -change libpq.5.dylib /Library/ODBC/PSQL/lib/libpq.5.dylib /Library/ODBC/PSQL/bin/iODBC/psqlodbcw.so installnametool -change /Library/Frameworks/iODBC.framework/Versions/3.52/iODBC /Library/ODBC/PSQL/lib/iODBC /Library/ODBC/PSQL/bin/iODBC/psqlodbcw.so installnametool -change /Library/Frameworks/iODBCinst.framework/Versions/3.52/iODBCinst /Library/ODBC/PSQL/lib/iODBCinst /Library/ODBC/PSQL/bin/iODBC/psqlodbcw.so. 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?
HiI'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.tar.gz ):./configure CFLAGS='-arch i386 -D ENABLEMYLOG' -with-iodbc=/usr/local/iODBC -with-libpq=/Library/PostgreSQL/9.4 make I've also built the latest version (3.52.10) of iODBC by the instruction from 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/iODBC2. 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.
HiSorry for the too late answer but at last I could get free time for the issue. Still I have the problem related to not shown table list in LibreOffice.
I've built the latest version of 32/64 bit postgresql odbc driver but already under El Capitan OS X (10.11.3) with iODBC 3.52. I've tried to use the driver by different versions of 32 bit LibreOffice - didn't help. I turned on mylog and got logs (attached).
There was just only one 'testtable' table with one 'a' column. In LibreOffice in tables I saw only empty list, without any tables.
![Driver Driver](https://cdn-images-1.medium.com/max/1552/1*auuPJjtOsWwUIqoQvIIKuQ.png)
I gave up on LO/OO Base as a database frontend some time ago as it's performance was spotty at best. I do remember that LO/OO was finicky about there being a primary key on a table. Does the table you mention have a primary key? Best RegardsDmitry Best Regards Dmitry Pogorelov. On 02:18 PM, Dmitry Pogorelov wrote: Hi, Sorry for the too late answer but at last I could get free time for the issue.
Still I have the problem related to not shown table list in LibreOffice. I've built the latest version of 32/64 bit postgresql odbc driver but already under El Capitan OS X (10.11.3) with iODBC 3.52. I've tried to use the driver by different versions of 32 bit LibreOffice - didn't help. I turned on mylog and got logs (attached).
There was just only one 'testtable' table with one 'a' column. In LibreOffice in tables I saw only empty list, without any tables. I gave up on LO/OO Base as a database frontend some time ago as it's performance was spotty at best. I do remember that LO/OO was finicky about there being a primary key on a table. Does the table you mention have a primary key? Best Regards, Dmitry Best Regards Dmitry Pogorelov All I can think to do is enable MyLog and/or CommLog: 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 - Adrian Klaver - Sent via pgsql-odbc mailing list To make changes to your subscription.
I am trying to get Excel 2016 (15.30, Office 365 subscription) to acces a filemaker database via ODBC, as a client. The database seems to communicate via ODBC and iQueryODBC can see the tables and data in the Filemaker Database. I can configure DSNs using Actual's ODBC manager (1.0.14), and these test OK.
When I try to establish a link between Excel and Filemaker via ODBC (Data / Get External Data / From Database) the iODBC chooser window opens but with no functionality - DSN connections cannot be tested (nothing happens) or configured, and clicking OK to advance to Query just brings me back to the Spreadsheet, with no data. I suspect there is some confusion with the versions of the iODBC chooser that Excel is calling up, but I do not see how I can check to see that its 64 bit and, if its not, how I can force Excel to use a different Data Source Chooser that is 64 bit. Any ideas very much appreciated.
PS I am unable to find MS Query in my office instalation - where should it be residing with Office 2016? Hi The3rdParty, To clarify the issue, Iād like you to confirm and provide the following. Provide us with a full screenshot showing the version information of Excel 2016 for Mac via ExcelAbout Excel. How do you configure DSNs using Actual's ODBC manager (1.0.14)? Could you provide us with some steps? About ā When I try to establish a link between Excel and Filemaker via ODBC (Data / Get External Data / From Database) the iODBC chooser window opens but with no functionality - DSN connections cannot be tested (nothing happens) or configured, and clicking OK to advance to Query just brings me back to the Spreadsheet, with no data.ā, could you provide us with some reproducing steps and related screenshots?
![Postgres Odbc Driver Excel For Mac Postgres Odbc Driver Excel For Mac](/uploads/1/2/5/6/125657317/272668376.png)
Thanks, Cliff. Version Info: 2. Configuring ODBC manager: i. Launch Filemaker and open the intended source datatbase, verify that ODBC sharing is enabled ii. Outside of excel launch ODBC manager iii. Under System DSN, click Add iv.
Select the Filemaker ODBC driver, OK v. In the 'Filemaker DSN Configuration' window go through all the configuation steps. Note that the database is local (Host: localhost). On the last page clck Test to verify connectivity. This gives a positve result vi.
Click OK and the configuration is complete 3. Data link between Excel & Filemaker: i. Open the source database in filemaker ii.
Open new worksheet in Excel, selevcet menu items Data / Get External Data / From Database iii. This opens the iODBC data source chooser (not ODBC, but iODBC) iv. Select the DSN that I created for the database that I want to connect to, and is open.
In this case it is 'registration'. Check the connectivity by clicking 'Test' in the iODBC Data Chooser Window. And nothing happens at all. Vi Click 'OK' in the same window and the iODBC Data Source Chooser closes, and I am returned to the spreadsheet, with no warnings, no dialogue boxes.
I would have expected this step to have launched Microsoft Query (at least this is what happens in Office Mac 2011). Please tell me if I can help you with any further information.