1) FM Pro comes with a JDBC driver named:
fmpjdbc12.jar
To use this driver from ColdFusion and SQL Clients like ViennaSQL, etc,
it must be placed where "they" can find it -- the easiest way, in OS X,
is to place it in:
/Library/Java/Extensions
You will, likely, need to restart any programs (CF, ViennaSQL, etc) so
that "they" will see the jar file.
Then, You must configure FM to:
Enable the Remote Data Access plugin
Enable The Web Companion Plugin
Configure the Web Companion -- especially the TCP/IP Port (which
defaults to 80) -- I used 8600
Allow Sharing of the above plugins (Menu File--->Sharing...)
This is for FM Pro 6.x -- it will probably be a little different for
the FM Server
Finally, you must configure the datasource in CF, etc. Here is what I
used:
CF Data Source Name: FileMakerTest
JDBC URL: jdbc:fmpro:http://localhost:8600 (note the Port number)
Driver Class: com.fmi.jdbc.JdbcDriver
User Name:
Password:
I tested this against a simple database with CFMX for J2ee/JRun and
ViennaSQL -- they both worked fine!
HTH
Dick
On Feb 18, 2004, at 6:40 PM, Dick Applebaum wrote:
> I was able to connect FileMaker Pro to CFMX (the original port) about a
> year ago (or so).
>
> As I recall there were some esoteric settings you had to make in
> FileMaker to allow the connection.
>
> I was able to use FM databases in a CFMX development environment, but
> don't know if the connection is/was reliable enough for production/
>
> I have a pretty full schedule, so it will take me a couple of days to
> get back up to speed.
>
> But, yes, it can/has been done!
>
> Dick
>
> On Feb 18, 2004, at 1:47 PM, Barney Boisvert wrote:
>
> > A quick Googling indicates that there is a FileMaker JDBC driver,
> but
> > that
> >��it's not quite up to spec, poorly built, and is only available when
> > you buy
> >��FileMaker Server.��Since JDBC is all CF understands, I think you're
> > going to
> >��be stuck for a native connection.��You might be able to bridge it
> > across
> >��ODBC or something, but who knows if that's even possible, let alone
> > stable.
> >
> >��Cheers,
> >��barneyb
> >
> >��> -----Original Message-----
> >��> From: Kevin Graeme [mailto:[EMAIL PROTECTED]
> >��> Sent: Wednesday, February 18, 2004 1:43 PM
> >��> To: CF-Talk
> >��> Subject: Re: Re:Transfer to Mac OS X Server
> >��>
> >��> I don't think you can connect FileMaker to CF directly. IIRC,
> >��> Allaire did
> >��> something with drivers for FM and CFExpress, but I don't
> >��> think it flew.
> >��>
> >��> You could try exporting the FileMaker db to XML and then
> >��> using the XML with
> >��> CF.
> >��>
> >��> -Kevin
> >��>
> >��> ----- Original Message -----
> >��> From: "Sangeeta Karmokar" <[EMAIL PROTECTED]>
> >��> To: "CF-Talk" <[EMAIL PROTECTED]>
> >��> Sent: Wednesday, February 18, 2004 2:35 PM
> >��> Subject: Re:Transfer to Mac OS X Server
> >��>
> >��>
> >��> > Urgent help....
> >��> >
> >��> > I am using Filemaker Pro server on mac and trying to
> >��> connect database to
> >��> the coldfusion server and make websites work. how should i go
> >��> around that. I
> >��> have installed JRun/CFMX in /Applications/jrun4 directory.
> >��> >
> >��> > I really need serious help..
> >��> >
> >��> > Regards
> >��> > Sangeeta
> >��> >
> >��>
> >
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
