Solved

FM - Issue with Using ODBC

Posted on 2013-02-04
8
306 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 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
ScreenConnect 6.0 Free Trial

At ScreenConnect, partner feedback doesn't fall on deaf ears. We collected partner suggestions off of their virtual wish list and transformed them into one game-changing release: ScreenConnect 6.0. Explore all of the extras and enhancements for yourself!

 
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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

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…
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…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

809 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