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 Harry
      Hi Board!
       
      We've just installed Sage 200; from Sage 50.

      So, now we have an SQL platform database to run our company on, moving up!
       
      We use FM and FMS to add function and output. Sage 200 will take over some of this; but we have Shipping and Inspection systems we've built that need to read data from Sage.
       
      The DSN has been setup and is working. The usr and pwd work. I can add a table to my FM database schema, go and select the data source and place/add a table. But there is no data inside any of the tables; and there should be.
       
      Anybody got any tips for me?
       
      Thank you!
    • By Roger Tuan
      This is about a Filemaker Server <--> MySQL sync setup.
      I have two fields, serialNumber and writeBackNumber, and an altogether separate primaryKey that isn't used for this part.
      If I create a new record on Filemaker, everything is fine. the serialNumber is auto-incremented on record creation and synced successfully.
      However, If I create a new record in MySQL, I can leave both serialNumber and writeBackNumber blank, but when the sync happens, Filemaker does not auto-increment the serial number and put it in the field. It looks like it's just skipping the auto-enter part altogether and leaving serialNumber blank. This seems like what's going on:
      Create new record in MySQL. serialNumber and writeBackNumber are blank. Click sync, 1 record gets synced to Filemaker. Record appears in Filemaker with both fields blank. Click sync, that record gets erased from MySQL but is still in Filemaker. Is this a bug?
      Do I need to edit the MirrorSync customization script to perform the auto-enter on hub (Filemaker) pre-sync and then copy that over to the spoke (MySQL) post-sync?
    • By eljefejb
      I've got a strange case on my hands.  Here's some background:
      I've got an ODBC connection to JD Edwards Enterprise 1 (Oracle DB).  I have a layout that shows fields from the RMA Line Items table.  There's a field at the top that lets you find by RMA number, then the matching records (found via self-join relationship) are displayed in a portal. 
      This has been working well for years, and then one of our users stumbled across a record that couldn't be found by FileMaker, though it definitely exists.  The problem seems to be limited to one specific RMA number.  If you go into Find mode and enter the number, FileMaker says there are no matching records.  However, if I run an ExecuteSQL statement in the Data Viewer tool, that is able to find the records.  There are 179 line item records for the problem RMA number.
      I'm pretty sure there's no limit on number of rows or anything like that.  I would have thought it to be some sort of record corruption in JDE that is preventing FileMaker from seeing the records, but that doesn't explain why I can see the data by doing an ExecuteSQL statement.  It must have something to do with the ODBC table occurrences, but I can't think of what that may be.  As I said, the problem seems to be limited to this one particular RMA number.
      Any thoughts or ideas?  Thanks in advance!
    • By djlane
      I'm creating a simple system to update a remote FM file from an android device, using Cellica Database". http://www.cellica.com/Products.html
      An ODBC connection has been created, and I can add, modify and delete records in my FM database from my android.
      I want to trigger a script in FM when a field is modified via the ODBC connection. None of the native FM script triggers work as they are dependent on layouts or user actions. I have tried DoScript, Scriptmaster and EventScript - using field validation. All work OK if I modify the value within FM, but none trigger when the value is modified via ODBC.  With EventScript and DoScript, I get a failure message on the device that the record failed validation. With ScriptMaster "CallScriptImmediately", the record updates OK, but the script is not triggered.
      Any suggestions ?
       
       
    • By dysong3
      HI all,
       
      I am a novice with ODBC.  I am trying to set up an ODBC access and am having a bit of trouble.  Perhaps someone can steer me in the right direction. My set up is FMS 13 on one dedicated machine.  And FMPA 14 on several other machines. On the server the ODBC Manager succeeds in establishing a "system DNS" with access to a given file.  However on the other computers I get this message
       
      I have given read and write permissions to the file odic.ini and its enclosing folder and yet I keep on getting this error message. I have installed the latest ODBC drivers, opened port 2399, installed the latest FM updates for xDBC in their various versions.  I'm at a loss