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…

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.

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

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

bdbd February 1, 2022, 9:57pm 2

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

Hope this helps.

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	171	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