Solved

How do I connect FileMaker Pro to my MSSql via ODBC

Posted on 2010-08-16
3
713 Views
Last Modified: 2012-08-13
I have just created my FIRST Filemaker Pro Layout that I want to connect to an MSSQL database...

Here's what I have done so far..
Set up ODBC and that is working I can see the data if I IMPORT it in to Filemaker Pro/
I've got 2 tables. One is the FileMaker Source the other is the MSSQL source.
Filemaker Source has 28 fields, 0 records.
SQL has 46 fields, 38940 records.

I've set up relationships from the FMP to SQL.

But for some reason I can not see any data or Records in the File Maker Pro Form or Table views.

I only see data when I do a File> Import>ODBC. But I think this is importing it direct to the FMP database. Is that right?

So how do I get the records from the SQL to show up in the FMP??
I guess basically I want to be able to EDIT some data using FMP as a front end, but have this pushed back to SQL so changes are in SQL.

Please Help a n00b figure out what he is doing wrong..

Thanks

Chip

tbls.jpg
relate.jpg
0
Comment
Question by:OSXFreak
[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
3 Comments
 
LVL 6

Accepted Solution

by:
ThomDroz earned 250 total points
ID: 33450818
Hi Chip
Make certain that ODBC is enabled in the console (last item-- Enable
ODBC/JDBC), and that 'Access Via ODBC/JDBC (fmxdbc)' is enabled in the
clients' privilege sets. .

Hope that helps!

Thom Droz
0
 
LVL 8

Assisted Solution

by:Tocacar
Tocacar earned 250 total points
ID: 33452574
I would do this through ESS (FM9+) - have a look at these:

www.filemaker.com/downloads/.../techbrief_intro_ess.pdf
http://sixfriedrice.com/wp/getting-started-with-external-sql-sources/

The sixfriedrice site is excellent and covers a wide range of useful topics brilliantly.
0
 

Author Comment

by:OSXFreak
ID: 33458241
Thom and Tocacar,

 Thanks for the info. I'm not sure where to set that up but I figured it was not worth it. I could keep the filemaker pro locally and go from there..

I do have other issues and will post on a separate topic..

Thanks

Chip
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Do I have to manually open all FMP9 database files after a reboot of file server computer? 7 240
Filemaker 13 Export / Import Records 1 1,055
audit trail 6 214
Printing Portal records 7 186
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…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

738 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