Does anyone have experience and/or success using a 4D database as an external datasource through ODBC. I can add the system DSN and add it to FMP. Once I attempt to view the tables in the 4D database, I receive an error that the "ODBC connection is not compatible". Does anyone have a work around or suggestions? Thanks!

Hello,

If you using Windows, be careful of version 32 or 64 bits i think.

Tom

Tom, thanks for the input. I have the proper 64bit driver installed. FMP can load the 4D data source but is giving me an error when trying to view any of the tables.

Have you or could you test ODBC connection with another product for example Excel or a sql tools ?

Tom

Yes, I was able to connect and view the tables using RazorSQL. 

Are you using Windows or Mac OS X ?

Could you display the DSN ?

Tom

I am using windows.  The DNS shows up inside of FMP as it should. Within the ODBC  manager in Windows I can test the connection and it is successful, so that all seems to be correct. It's after I add the external data source within FMP and then do to manage database to pull in the tables I get the error message. I have attached a couple of screen shots.

Hello,

Which rights have the user ? admin ?

 

I am the user and I have full admin rights. I can connect using a SQL tool using my credentials without any issue. The error that I am getting doesn't seem to point towards a rights issue. The error is indicating a compatibility issue. I was hoping to find someone that has successfully connect to a 4D database through ODBC in FileMaker. There are very few details on the web. Thanks.

What is the database in 4D? It is SQL-lite, correct? That is not supported for ESS ( External Sql Source ). You could do an ODBC import. But that functions very differently.