Filemaker ODBC/JDBC to Coldfusion

I have successfully got coldfusion talking to a Filemaker 9 database. It turned out to be pretty simple really.

I enabled ODBC/JDBC in Filemaker server. Installed the latest SequeLink on the coldfusion server. Setup a System DSN and pointed to it in the coldfusion admin. The only odd thing I ran into is in Filemaker field names can have spaces so when I do an insert into a field I have to put double quotes on the field name.

8 Responses To  “Filemaker ODBC/JDBC to Coldfusion”
  • ahamad
    April 14, 2008 · Reply

    Cool… :)

  • web development
    October 8, 2008 · Reply

    I have been using Lasso with Filemaker, but I recently saw a need to use Filemaker With ColdFusion 8. Glad to see it worked out for you. Hopefully it will as easy for me.

  • Chris
    April 29, 2009 · Reply

    Hi, this is a great little post and is giving me hope but I am a bit stuck. I am trying to use FileMaker with Coldfusion. I am actually taking over the site and setting it up on a new server so I can see the CF datasource but not sure how it works. I am using Filemaker Pro 10 and CF 8. I have enabled ODBC/JDBC in filemaker but now need help with SequeLink. I'm not sure what version I should be using or how exactly to set it up. I am on a Windows 2003 server.

    Thanks in advance.

  • damonledet
    April 29, 2009 · Reply

    On the Filemaker database create a user File -> Manage Accounts & Privileges and give that user the rights that you want Coldfusion to have (read only, write, etc)

    Run Filemaker server admin and make sure you have ODBC/JDBC checked for the database you want to access via ODBC.

    On the server running Coldfusion install SequeLink, create a System DSN using the ip address of your filemaker server and the user credentials you created in step one.

    Lastly in coldfusion administrator create a new datasource point to the system DSN you created.

    • Chris
      April 29, 2009 · Reply

      ok, i now have sequelink installed but need to set port 2399 to listening for sequelink to work. I get sequelink error 2306 when trying to set up the DSN. how can i edit ports.. can't find this info anywhere :(

      • damonledet
        April 29, 2009 · Reply

        You will have to open port 2399 on the filemaker server computer.

        If on Windows Control Panel -> Firewall
        If on Macintosh System Preferences -> Security -> Firewall

        • Chris
          May 3, 2009 · Reply

          I am just trying to make this connection on the local web server for a development site. I am using Filemaker Pro 10 and sequelink 6.0 but still getting error 2315 when trying to create the system DSN. Any thoughts?

  • damonledet
    May 8, 2009 · Reply

    Not sure about this error I did find this http://media.datadirect.com/download/docs/slnk/er…

    "Error 2315. The server received the handshake request and returned a non-IIOP reply that the client could not understand.

    # You may be connecting with a previous, incompatible version of the SequeLink Client (SequeLink 4.x) to a SequeLink 5.5 Server:

    * The client receives an error message that informs you that the server has closed the connection during the initial handshake."

Leave A Reply