Solved

FM - Issue with Using ODBC

Posted on 2013-02-04
8
302 Views
Last Modified: 2013-02-11
Using ODBC was such a pain, I bailed on it 6 months ago.  Trying again, however, when I follow the directions, it tells me to "Choose File menu > Sharing > ODBC/JDBC, and click "on" then "Select the filename(s) to share from the list of open files."  However, no file names appear.  See attached.  (Note:  Yes, I do have Advanced Server and ODBC is turned on in it.)  Not sure why using ODBC with FM has been so difficult.  10 years ago, I used ODBC with MS Access and it was as easy as using Word or Excel.
0
Comment
Question by:rvfowler2
  • 4
  • 2
  • 2
8 Comments
 
LVL 82

Assisted Solution

by:Dave Baldwin
Dave Baldwin earned 100 total points
Comment Utility
ODBC drivers for Microsoft Office products come with Windows.  Most other drivers do not.  The most common problems in questions here about ODBC get resolved when the right driver is installed.  If Filemaker is on your machine, the driver was probably installed with it.  If Filemaker is on a different machine, then you probably don't have the driver and will have to get it and install it.

http://www.filemaker.com/support/technologies/odbc.html
0
 
LVL 2

Author Comment

by:rvfowler2
Comment Utility
I went to your link and the last in the list is what I wanted to do - use Filemaker as a data source (for Word).  However, when I clicked on that link, it just brought me to the same Help page I've been using.  In following the directions, I still end up with no db files showing.  If there is some ODBC driver I need to install on my local machine, what is it and where is it.  The Help page says nothing of downloading a driver to my local machine.
0
 
LVL 11

Accepted Solution

by:
Andrew Angell earned 400 total points
Comment Utility
FileMaker was not built with connections from 3rd party applications in mind.  Even when you get their ODBC driver working it will not perform well at all.  Fair warning.

FileMaker's "solution" to this problem was the introduction of External SQL Sources.  If you're going to be working with web apps, mobile apps, or whatever, they recommend that you use a platform like MySQL, Access, etc. to connect to your app.  Then you can hook that database up to FileMaker using External SQL Sources and you'll have access to that 3rd party DB data within FM just like it was actual FM data.  You can create layouts with it, create scripts, calculations etc.

It's a big pain in the ass, quite frankly.  I've been begging FM for years to just solve their issues with ODBC and Custom Web Publishing / PHP API.  They all perform horribly and they know it.  Again, though, their solution was to tell you to use a different database and hook it up to FM.

Then you'll have to write FM scripts to sync all of that data with your actual FM layouts/tables, or leave it in the 3rd party database and work with it from there directly.
0
 
LVL 82

Expert Comment

by:Dave Baldwin
Comment Utility
If you click on the link in blue, it says that if you have Filemaker on your local machine, the driver should have installed with it.  If Filemaker is running on a remote machine, only FileMaker Server Advanced will work with the remote connection.

To share your FileMaker database file as a data source over a network, use FileMaker Server Advanced.
0
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 
LVL 2

Author Comment

by:rvfowler2
Comment Utility
First, I'm wanting at this point to do something very simple by creating ODBC merge fields in Word that link back to Filemaker.  

Second, I do have Filemaker Server Advanced, but of course am managing it from my local machine.  My local machine has Windows 7, which it says should have the drivers already downloaded.  However, I think my question is even before this point.  In Filemaker, I can't even see my own databases listed (shown in the jpg file I attached earlier).
0
 
LVL 11

Expert Comment

by:Andrew Angell
Comment Utility
I don't see a jpeg attached anywhere..??
0
 
LVL 2

Author Comment

by:rvfowler2
Comment Utility
Sorry, my bad.  Didn't attach for some reason.
-ODBC-Capture.jpg
0
 
LVL 2

Author Closing Comment

by:rvfowler2
Comment Utility
Just appreciated that someone finally stated the obvious that the way Filemaker works with ODBC is very un-user friendly.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

763 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