Sign in to follow this  
Followers 0
rmstar

MAC
FMS10 ODBC fuctionality

2 posts in this topic

I have an application with a FMS10 server under Tiger, multiple FM9/10 clients, & a remote MySQL/PHP/Ajax/Apache webserver.

We need Filemaker 9 to make reports based on data from both FMS and MySQL tables. The FM programmer we use proposes to put an ODBC driver on one of the client machines, have it interrogate the MySQL server, and then build the reports only on that machine.

I am wondering if it is possible to have FMS-10 instead do the connection to the MySQL, so that any client could read the data & create reports. But I'm clueless as to what server ODBC support really means.

Thanks...

Share this post


Link to post
Share on other sites

"Server ODBC support" means that FMS can act as a data host so that data clients can retrieve filemaker data through ODBC and JDBC. You're talking about making the server a data client with MySQL being the data host.

Look into the ESS feature of FileMaker Pro and Server. That supports making a connection to MySQL (from the server) so that all FM Pro clients can see the MySQL data.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0

  • Similar Content

    • By MikeKD
      Hi Folks,
      I've broken a pdf saving script which used to work. The filename itself hasn't changed so I don't think that's the problem (there are no /s for instance) - I'm pretty sure it's the file path and Mac OS re-organising itself to sync with iCloud.
      I'm trying to save PDFs to Dropbox and I think that the Dropbox folder on my my has changed location. According to info, the location is /Users/mikekentdavies/Dropbox/KJA Music Library.
      The calculation I'm using to set the location variable is below; can anyone see where I'm going wrong? (I've also tried various combinations of filemac: / file: / .. / : etc having read the FM creating file paths webpage.)
      "filemac:../Users/mikekentdavies/Dropbox/KJA Music Library/Set Lists/"  &  Gig::Gig Name & " - "  &  Gig::Version  &  " Set List.pdf"  
    • By LelandLong
      I read that the new 3.01 version does not require Java.
      When I run FMPAv16 on my Mac (10.11.6) and use the sample Email database it works just fine and I see nothing related to Java. I had the older v2.12 plugin installed on here and have just updated to v3.01 today.
      When I run FMPAv16 on a different Mac (10.11.6) and install the v3.01 plugin (never had the plugin installed on this machine before today) and run the sample database a Java App runs without any windows, Just visible in the lower right dock and its single menu is titled "Java"
      Any ideas as to this oddity?
       
      Leland Long
    • By Mr. B
      We are Americans who are a non-profit and have a school for squatter children in the slums of the Philippines and would like to create student attendance database that provides various rewards. 
      Our goal is to encourage the kids to attend school who otherwise wouldn't and provide them with a reward point type of system. Each day they attend school, they get 5pts. If they remembered to wear their school uniform they get additional 5 pts.  At the end of the day or the end of the week, they can use their points and trade them in for rice, milk, things that will help them feed their family, get school supplies etc. 
      We would like to account for how often they come to track their daily attendance.  We are hoping to include other fields that would be helpful to medical assistance, needs, etc.
      As of now, we print and laminte, cutout little paper coins we give them and it is a lot of work. We have around 400-600 kids who attend class. Annually we have several large community events where we track the daily attendance during summer of up to 3,000 students who attend. This is all done by hand so a digital type system would really benefit, save time, manpower, and streamline what we are doing. 
       
      To Summarize:
      - track attendance
      - reward attendance and such by point system
      - can use their student card points at cafeteria for snacks or for extra stuff as incentive to help their families.
       
      If you know of something that would help us, or have some ideas, please let us know. 
       
      ~ Mark
    • By GeoSteven
      I am running a server side script that attempts to update records in a MySQL table that is set up as an external data source. It runs without issue for hours to weeks at a time then gets hung on error 512 (Record was already modified by another user). The problem is that I can't figure out how to capture and handle this error. I've tried adding "If get(lasterror)=512 then <skip this record and continue to next> just after the 'Go to Record(next)' but it never gets to that step. Instead hangs on try to move the record pointer and writing error after error to the log. 
      I've searched the forums fairly thoroughly but there is not a lot of info forthcoming. Surely this has been a problem for someone else that has figured out how to handle it. Any suggestions appreciated.
      Will be glad to provide more info on the environment if needed.
      Thanks in advance,
      Steve
    • By calebruth
      I tried to install MirrorSync 3.17 today on a MacOS with 10.12.3 and FMS 15.0.3.308. The installer is hanging at about 80% progress at "Running package scripts..."
      Is there an installer log file that I can examine?
      In addition I noted in the docs the restriction against multiple users sharing the same file on the same device:
      http://docs.360works.com/index.php/MirrorSync_advanced_topics#Can_I_share_a_device_among_multiple_users.3F
      I am wondering about the details of this restriction and is it possible for multiple users to share the same db file on the same device if there is no record filtering or record-level access features enabled?