Jump to content
The site is updated on a beta version. Maintenance tasks are running so search and index may not function at this time. ×

read/write Filemaker data from MySQL database using ODBC connection to Filemaker


Recommended Posts

  • Newbies

 

Apologies if I've put this in the wrong place.

My Filemaker solution uses a FM database and an ODBC connection to a MySql database that is used to serve data to a website.

I have complete read/write access to the data in the MySql database from inside FM and thus control of data published on the site.

I would like the MySql database to be able to access tables in the FM database in the same manner.

I have set up an FM ODBC connection to our FM server and that is visible in my local ODBC Manager, have tested the connection and that is good, but I can't see any way in the MySql apps I have installed on my system to create a table in the MySql database using live FM data, in the same way that I can make a table in FM using live data from the MySql database.

Is it possible to do this?

My main MySQL app is SequelPro.  And occasionally MySQL workbench and associated tools.

Thank you.

 

Andy Codling

 

 

 

Link to post
Share on other sites

No.

The FM feature you are describing is called "ESS" and that is basically FM doing a lot of work for you exposing the MySQL tables as if they exist in FM, but they don't.

There is no equivalent feature in the apps you are using to see MySQL data.  If you want FM data in MySQL you will have to create the matching table in MySQL and physically sync data.

SequelPro can of course connect to FM and see its tables and data.

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Similar Content

    • By charlitoA
      Hey Everyone
       
      We are having this issue with the change of any of this variables
      IOS 13
      FileMaker 18
      FileMaker Server 18
      FileMaker Go 18
       
      We have a Layout for FileMaker go to upload photos from an iPod Touch or iPhone Pro 11, and when we use a script to take the photo directly from the camera works perfectly, but when we use the another one that has to open the library from the device it will happen either of this 2 things
       
      1. It will duplicate on the mini preview the last "good" picture and when try to maximize the picture nothing shows up
      2. It will happen this weird "no signal tv" ( that's how I call this lol ) image and there's no way to see the picture
       
      Discoverys
      On MacOS the pictures looks great, also con iOS , it seems that windows it's not detecting as a valid file when the photo is taken from the library of the iPhone or the iPod Touch (this never happen in older versions of filemaker or iOS)
       
      Any ideas ?

    • By stan111
      Gents, would you please help me to create a script?

    • By stan111
      Gents, I have an excel price list with header fields. I want to import it into a newly created FM database. Is it possible to make FM use those header fields instead of me manually creating corresponding fields in FM?
       
    • By everythingFileMaker
      The short video linked below shows a radio button value list that shouldn't work because the 2nd field is an unstored calculation however it does some of the time and others not. I've been noticing this for some considerable time and I'd love to get to the bottom of why. Any thoughts will be greatly appreciated. https://www.screencast.com/t/7CWCfpqfeP
    • By 34South
      I previously used ODBC Manager (32 bit)  to great success importing data directly from Filemaker Server to JMP. I recently upgraded to Catalina (MacOS 10.15.5) and knew that one of the casualties would be this ODBC utility. I downloaded the 64 bit ODBC manager from Actual Technologies and successfully installed it but get the following message when trying to open an FM database from within the ODBC interface in JMP:
      dlopen(/Library/ODBC/FileMaker ODBC.bundle/Contents/MacOS/fmodbc.so, 6): image not found
      I have navigated to Actual Technologies' web site believing I should download an ODBC driver but this comes at a hefty price tag, especially when converted to my local currency. Given the increasing costs of maintenance contracts and SSL certificates I had hoped to avoid further expenditure. Do I really need this and is there an alternative?
  • Who Viewed the Topic

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.