Sql & Filemaker

Discussion in 'Mac Apps and Mac App Store' started by Thessman, Dec 8, 2005.

  1. Thessman macrumors regular

    Dec 8, 2005
    I'm interested in using Filemaker as a front end for a MsSql server 2000 database, but i don't know if odbc will allow realtime updates of the data, or is just for import. Any input appreciated
  2. belvdr macrumors 603

    Aug 15, 2005
    ODBC is an interface to a database, be it Oracle, MS SQL, or any other variant. If you insert 5 rows over ODBC, your database server is responsible for inserting and writing that data.
  3. ahunter3 macrumors 6502

    Oct 15, 2003
    I tend to think FileMaker is the best box of bits and bytes ever assembled. While its ODBC capabilities are adequate for doing a PUT as well as a GET, thereby functioning as a front end, it ain't fast. (JDBC is somewhat faster, if I recall correctly).

    We briefly connected parts of a sprawling FileMaker system to an Oracle mess in this fashion, on a LAN with decent pipes, but it was sufficiently miserable for us that we gave up and exported as tab-delimited text and imported that into Oracle instead.

    This was Fm6 architecture, it may have improved under Fm7-Fm8.

Share This Page