Solved

FM - Issue with Using ODBC

Posted on 2013-02-04
8
311 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
[X]
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
  • 4
  • 2
  • 2
8 Comments
 
LVL 83

Assisted Solution

by:Dave Baldwin
Dave Baldwin earned 100 total points
ID: 38852077
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
ID: 38852493
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
ID: 38852542
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 38852544
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
 
LVL 2

Author Comment

by:rvfowler2
ID: 38852632
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
ID: 38853061
I don't see a jpeg attached anywhere..??
0
 
LVL 2

Author Comment

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

Author Closing Comment

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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

623 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