I'm trying to decide if using ODBC will be helpful for a small project I just got. What I've been doing up to now is programmatically creating CSV files and importing those. Using this roundabout technique, I get the level of control I need in Filemaker. However, using ODBC, what I think is correct…

You're right, you have the Import script step for get data into filemaker and the Execute SQL script step for pushing data to the sql-db if you don't add it as external source. If your query just returns a single value, use a global field as import target and then post process the field value. For…

See the following FileMaker Help page: Claris FileMaker Pro 19 Help: Accessing external data sources . Hope this helps.

Thanks Otmar. Yeah, I'll stick with my current approach since it's free and really doesn't take very much time -- just an intermediate CSV creation. I was just hoping ODBC work for my case. Great reply, thanks again.

Do you know how to remove/un-install the "Actual" ODBC driver? I wrote the company for instructions but they never replied. Thanks.

The drivers get installed in /Library/ODBC, there are also two config files odbc.ini and odbcinst.ini at the same location, just remove the actual parts from them.

I'm worried that if I go removing items from /Library/ODBC that the machine might have a problem. Are you sure this will work? Have you done it yourself? Thanks.

I haven't done it, but don't see any danger for the machine. Just zip the ODBC content before so you can go back. As long you don't use a odbc connection, those drivers do nothing.

The Actual drivers come with an installer/ configuration tool. All you need to do is complete the fields. The installer includes connectivity tests. No headache, It just works.

I didn't see that. I was just install. No options. Could you be referring to a previous version? I tried unchecking all the drivers and running the installer, but that didn't do anything - all the drivers were still in /Library/ODBC. Thanks

ODBC Driver with MySQL Question

Questions

FabriceN February 4, 2022, 6:33am 5

Import from ODBC/Execute SQL is definitely the most flexible and fastest way.
Some valuable tricks here.

Topic		Replies	Views
Moving data from ODBC to FileMaker via script MBS Plugins scripting , sql , plugin , mbs	0	225	February 13, 2023
Unable to connect to FMS19 using Claris JDBC Questions community	4	328	February 9, 2022
ExecuteSQL, How to . . Questions sql	27	170	April 24, 2026
iODBC update needed for ODBC in MBS Plugin on macOS MBS Plugins sql , odbc , mbs	0	89	February 21, 2024
Connect to an external database server in FileMaker with MBS Plugin MBS Plugins integration , server , plugins , mbs	8	547	October 19, 2024

ODBC Driver with MySQL Question

Related topics