Linked Server From SQL 2005 to FileMaker 9 Pro

Posted on 2007-10-17
Last Modified: 2008-09-20
I would like to create a linked server between an instance of SQL 2005 and FileMaker Pro 9 server.  What is the best way to do this?
    LVL 28

    Accepted Solution

    the best? don't make any link, have filemaker client to work on SQL direct via an odbc driver.
    if you don't like the idea of having to setup the odbc driver on all clients machines, then use the odbc feature of filemaker server, but you need the advanced version then, much more expensive.
    I have tested filemaker client using mysql5 as its data storage, and the speed is very decent, I expect even better results with MsSQL (generally faster than mysql)
    LVL 9

    Assisted Solution

    To set up a table from the server you ned toserve the application from the server, Have the appropriate ODBC drivers on the server, Then point to the External Database from inside the Filemaker database. Once you have done that the MSSQL table will show up in your application's database relationship screen. Link the appropriate keys and you are off to the races.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
    In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now