FileMaker Pro and Cold Fusion

[SelahFalk]

I think it can be done. But I'm new at this and have only set up Cold Fusion
to work on an Access database.
So can I do with FileMaker Pro? And how would I see the tables to query them
for SQL?
And do you have any good resources for helping me learn to do this?
Thanks!!

[Brian Hogue]

Pretty sure that Filemaker Pro works with ODBC. If correct then you should
be able to create a DSN like your Access solution.

-brian

"SelahFalk" <webforumsuser@macromedia.com> wrote in message
news:drrfdb$2po$1@forums.macromedia.com...

> I think it can be done. But I'm new at this and have only set up Cold

Fusion

> to work on an Access database.
> So can I do with FileMaker Pro? And how would I see the tables to query

them

> for SQL?
> And do you have any good resources for helping me learn to do this?
> Thanks!!
>

[Dan Bracuk]

Good luck.

Filemaker plays with odbc and sql with regards to bringing data in, but not sending data out.

[philh]

Dan, I heard that others had successfully configured their FM database to serve
data through the ODBC connection:


[url]http://groups.google.com/group/macromedia.coldfusion.database_access/browse_thre[/url]
ad/thread/41ed939d0c4cfdd3/048a92e6b117fa38?lnk=st&q=coldfusion+filemaker+odb c&r
num=2&hl=en#048a92e6b117fa38

This may be the explanation that everyone's been looking for.

HTH,

[SelahFalk]

YOU ROCK! THANKS!!!!!
Sarah

[OliverReid]

check out

[url]www.italianvilias.com[/url]

this CF site is backed by a filmaker database in real time, and is really
fast. Virtually evreything you see (all the text, and images) is pulled form
fielaker fields, and booking are palced back in Fm in realtime.

[SelahFalk]

Quite impressive. Thanks for the link.

[OliverReid]

Btw this all ODBC. The search data is looaed into CF arrays every three hours
and tgsu user searches do not hit the database. This does speed things up a
second or so.

The latest version of Filemaker Server is an industrial strength tool with
ODBC speeds for straitfoward queries comparable to SQLserver (50-75% as fast)
although performance under very high volumes may not be as good (no test data
available on that issue afaik.)

However for small business, or a modest sized piece of a big business. FM is
a very productive tool for the in-office management and use of data on the back
end. All of which makes FM/CF a potent combination, imho.