Solved

How do I connect FileMaker Pro to my MSSql via ODBC

Posted on 2010-08-16
3
707 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
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

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…
I designed this idea while studying technology in the classroom.  This is a semester long project.  Students are asked to take photographs on a specific topic which they find meaningful, it can be a place or situation such as travel or homelessness.…
This is a video that shows how the OnPage alerts system integrates into ConnectWise, how a trigger is set, how a page is sent via the trigger, and how the SENT, DELIVERED, READ & REPLIED receipts get entered into the internal tab of the ConnectWise …

932 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

11 Experts available now in Live!

Get 1:1 Help Now