Can Filemaker Pro connect to a MS SQL Server DB through ODBC?

Posted on 2010-11-29
Last Modified: 2012-05-10
I am building a web site for a client in ColdFusion using a SQL Server database.  My client has data locally in a Filemaker Pro database.  Can she set up an ODBC connection to connect to the SQL Server database on the web server?  
Question by:ssailer
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
LVL 12

Accepted Solution

North2Alaska earned 250 total points
ID: 34231763
Yes and it is a pretty straight forward process.

Author Comment

ID: 34231817
Does the version of Filemaker matter, or do all versions have this option.  I'm not sure what version she's using - I will have to ask her.  
LVL 12

Expert Comment

ID: 34232154
I believe any version above 7 has the functionality.  I've only used 8.5 and above and they have worked fine.
Get Actionable Data from Your Monitoring Solution

Your communication platform is only as good as the relevance of the information you send. Ensure your alerts get to the right people every time with actionable responses. Create escalation rules that ensure everyone follows the process and nothing is left to chance.


Assisted Solution

ThomDroz earned 250 total points
ID: 34238042
Filemaker also has a API for PHP

Author Comment

ID: 34238669
ThomDroz.  I'm using ColdFusion and SQL Server.  Will this API work for that as well?

Expert Comment

ID: 34239421

Sorry the only API out there for filemaker is the PHP, (there are 2 verison, FXPHP and Filemaker PHP, both are free)

SQL with odbc is probably faster, but if you are building it with PHP it is nice to have the PHP talk directly to the database.

Author Closing Comment

ID: 34360039
I did not pursue this as the client changed her mind about connecting to the DB on the server.

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

689 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