Use 4D ODBC as Datasource

[jchallenw]

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!

[Tom Assia]

Hello,

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

Tom

[jchallenw]

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.

[Tom Assia]

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

Tom

[jchallenw]

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

[Tom Assia]

Are you using Windows or Mac OS X ?

Could you display the DSN ?

Tom

[jchallenw]

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.

[Tom Assia]

Hello,

Which rights have the user ? admin ?

 

[jchallenw]

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.

[Josh Ormond]

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.