querying FileMaker data

[cfoster]

I'm having a horrible time trying to figure out how to query data from a
FileMaker database using ColdFusion. I've managed to set up a datasource
linking to the FileMaker Pro database with "ODBC Socket" as the driver, but
when I try to run a simple SELECT query, I get this error:

[Macromedia][SequeLink JDBC Driver][ODBC Socket][DataDirect][ODBC SequeLink
driver][ODBC Socket][DataDirect][ODBC FileMaker driver][FileMaker]Parse Error
in SQL

My select query is simply:

SELECT *
FROM testODBC

I'm using ColdFusion MX and FileMaker Pro 7, although ideally I'd like this to
run with FileMaker Pro 6. It's not within my power to abandon FileMaker, we're
simply trying to use data from someone else's FileMaker database to populate a
select input, and all of our data will be stored in SQL Server. Any
suggestions? Thanks!

[philh]

cfoster,

Is the FM db running on the server? I don't think you can query a dormant FM file; it has to be running in the application on the data server.

Good luck.

[cfoster]

I'm trying to get it working locally first, just to see if I can do it. I have the database open in FileMaker 7 on the same machine where I'm running ColdFusion Server and my test code.

[ChristopherW]

Hi,

The guys I'm working with want to publish stuff to the intranet via filemaker.
I'm looking into whether Filemaker 7.0 will connect to ColdfusionMX. Any
progress you make that you could share to me will be welcome.

Chris Welsh

[cfoster]

I have not had any success, and since posting my original request for help,
I've decided to go a different route. For my purposes, it should be sufficient
to periodically export a text file from the FileMaker database and connect to
that file as a datasource from ColdFusion. Ideally I would connect directly to
the FileMaker database and get up-to-the-minute data to populate my select
input, but I haven't been able to make that work.

[da cheat]

hello Cfoster,

I'm trying to even get my ColdFusion to recognize the FileMaker db. How did
you set up the datasource? If you can get me this far, I might be able to help
getting you the rest of the way. I would really appreciate your help.

Thanks,

[cfoster]

Sorry, it was so far back I don't specifically remember how I set up the datasource. I do recall downloading an instructional document from FileMaker's site, maybe that'll help.

[da cheat]

Thanks, I'll try that.

[keyman]

I am in the process of setting up a CFserver at a client's site, and will end
up dialoguing a lot with FMpro db's on other network servers, or else doing
text-file imports.

Any updates on the efforts above would be appreciated. (Is it easy for FM to
export field-delimited text-files? I have never worked with FM before).

-keyman

[advancemal]

I have this configuration going no problem. I have FM server 7 7 CFMX7. No
problems.
Its really a filemaker issue you are having.
With the sequelink drivers you need to create a system data source on the fm
server/CF server machine. If you can get this source testing ok within its own
self test facility then everything will work ok.
Most of the problems i had were that the fm server xdbc driver (plugin) was
not enabled and that the FM server server was not set up to allow ODBC
connections. BAsically you copy the xdbc.fmx file off the cd into the fmserver
program folder under plugins, stop the service first then restart it. Go into
the fm server properties and make sure the odbc connections is enabled and note
that this actual plugin doesnt doesnt appear in the fm server plugins window
with other ones and this make s you think it aint there but it is. Its a bit
long winded but if you need any help just email me on
m.de...@advancesystems.co.uk
I am in Ireland so you will know to allow for time differences.