Can FileMaker read from SQL?
June 21, 2007 3:48 PM Subscribe
Can FileMaker read from a SQL database? I've talked to (SQL) developers and they can't find a way to do it.
I have a FileMaker 8 database which is hosted online (i.e. not just on my local computer). Separately I have a SQL database also online.
I'd like a script within the FileMaker database - or any way to do this within FileMaker, doesn't have to be ScriptMaker - such that the FileMaker database will reach into the SQL database and read some data.
I know there's some vague mention of ODBC in the FileMaker manual, but my developers can't figure out a way for FileMaker to do the above. Any help?
I have a FileMaker 8 database which is hosted online (i.e. not just on my local computer). Separately I have a SQL database also online.
I'd like a script within the FileMaker database - or any way to do this within FileMaker, doesn't have to be ScriptMaker - such that the FileMaker database will reach into the SQL database and read some data.
I know there's some vague mention of ODBC in the FileMaker manual, but my developers can't figure out a way for FileMaker to do the above. Any help?
You can import and export between Fielmaker and SQL, but it's not always simple and clean.
posted by spitbull at 5:59 PM on June 21, 2007
posted by spitbull at 5:59 PM on June 21, 2007
Best answer: Are you running FileMaker Server? I believe you need that for ODBC support, not just a client.
posted by mkultra at 7:46 PM on June 21, 2007
posted by mkultra at 7:46 PM on June 21, 2007
Best answer: Have you asked around on FileMakerForums.com? I don't have an answer for you, but some of the folks on that forum have just been outstandingly helpful in clearing up my weird FMP questions. If FileMaker doesn't pay them, well, they should.
Just do some searching first to make sure your question hasn't been answered. I think that what you want to do requires going through the ODBC functions, but I could be wrong.
posted by Kadin2048 at 8:43 PM on June 21, 2007
Just do some searching first to make sure your question hasn't been answered. I think that what you want to do requires going through the ODBC functions, but I could be wrong.
posted by Kadin2048 at 8:43 PM on June 21, 2007
Right at the top of my Google search was this $100 solution.
posted by genghis at 11:05 AM on June 22, 2007
posted by genghis at 11:05 AM on June 22, 2007
Right at the top of my Google search was this $100 solution.
Which is a migration tool, which is not what the poster is asking for.
If you don't know anything about the topic, don't blindly run a Google search and conclude that everyone else is a moron who missed the obvious.
posted by mkultra at 7:07 AM on June 25, 2007
Which is a migration tool, which is not what the poster is asking for.
If you don't know anything about the topic, don't blindly run a Google search and conclude that everyone else is a moron who missed the obvious.
posted by mkultra at 7:07 AM on June 25, 2007
As opposed to merely a moron who fails to recognise that read-only access and data porting are semantically almost the same thing?
posted by genghis at 7:51 PM on July 12, 2007
posted by genghis at 7:51 PM on July 12, 2007
Late return; Filemaker 9 has just been released, and connects directly to SQL dBs. YoU may need the 'advanced' version.
Oh, and fmpromigrator sucks.
posted by spitbull at 6:18 AM on July 21, 2007
Oh, and fmpromigrator sucks.
posted by spitbull at 6:18 AM on July 21, 2007
« Older What is the origin of Veggie Tales' Pizza Angel... | What's wrong with the colour picker? Newer »
This thread is closed to new comments.
Here is a quick link about ODBC support.
posted by jkaczor at 4:10 PM on June 21, 2007