Install the appropriate ODBC driver. Know the IP address or domain name of the ODBC data source or FileMaker custom app. Know the user name and password for the ODBC data source as supplied by the database administrator. Whether you are importing ODBC data or working with ODBC tables in the relationships graph, as a client application, you must configure a driver for the ODBC data source you’re using. For example, if you will be accessing records from an Oracle database, you will configure an Oracle client driver. FileMaker Pro includes all the software you need to share your database as a data source via ODBC and JDBC, including the client drivers you use to access your database from other applications. To share your FileMaker database file as a data source over a network, use FileMaker Server.
I started this thread in the Office for Mac forum (without solution), but was advised by the moderator to try to post here. I am trying to get Excel 2016 (15.30, Office 365 subscription) to acces a filemaker database via ODBC, as a client. If you have previously installed the ODBC client driver for Mac OS, install it before installing an updated version. To install the ODBC client driver: From the folder /xDBC/ODBC Client Driver Installer, copy the file SequeLink.bundle to either your System or User library. Jun 19, 2009 If you have previously installed the ODBC client driver for Mac OS, install it before installing an updated version. To install the ODBC client driver: From the folder /xDBC/ODBC Client Driver Installer, copy the file SequeLink.bundle to either your System or User library.
I'm trying to set up pyodbc on a mac so I can run python scripts to talk to a filemaker database.
I am running python2.7
I have installed ODBC Manager, and the Filemaker odbc client driver. I have tested this connection and it connects fine.
However when I run the python script i get this error
pyodbc.Error: ('01000', u'[01000] [unixODBC][Driver Manager]Can't open lib 'FileMaker ODBC' : file not found (0) (SQLDriverConnect)')
Any help would be really appreciated.
RichardRichard
2 Answers
Problem fixed. My odbc.ini file was in the wrong place.
I ran the command
odbcinst -j
unixODBC 2.3.5DRIVERS......: /usr/local/etc/odbcinst.iniSYSTEM DATA SOURCES: /usr/local/etc/odbc.iniFILE DATA SOURCES.: /usr/local/etc/ODBCDataSources
and moved the odbc.ini file from /Library/ODBC/odbc.ini to /usr/local/etc/odbc.ini
Filemaker Odbc Connection
problem solved.
RichardRichard
Other options:
Download Odbc Drivers Filemaker 13
PyFileMaker - using XML APIhttps://github.com/aeguana/PyFileMaker