Jump to content

  •  

Photo
MAC

FMS10 ODBC fuctionality

odbc fsm mysql

  • Please log in to reply
1 reply to this topic

#1 rmstar  novice

rmstar
  • Members
  • 15 posts
  • FM Application:9
  • Platform:Max OS X Tiger
  • Skill Level:Novice
  • Time Online: 1h 45m 59s

Posted 22 February 2012 - 10:38 PM

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...
  • 0

#2 Wim Decorte  Carpal Tunnel

Wim Decorte
  • Moderators
  • 3,504 posts
  • LocationToronto
  • FM Application:13 Advance
  • FMGo:iPhone / iPod Touch, iPad
  • Platform:Cross Platform
  • Skill Level:Expert
  • Certification:7, 8, 9, 10, 11, 12, 13
  • Membership:TechNet
  • Time Online: 31d 12h 41m 21s

Posted 01 March 2012 - 04:33 AM

"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.
  • 0





FMForum Advertisers