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
    No longer logging into MR
    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