Mac User - ?compatable database software

[Jay_Tea]

I'm just starting to look at this myself, I've used FM for some years now but
am new to CF. It occurs to me tha tthe latest releases (i think 7, certainly 8)
of FM include a Datadirect SequeLink JDBC driver on the CD, so In Theory all
thats required here is to setup the JDBC driver within CF.

However, the docs for the datadirect driver are in depth and assume a
knowledge of java i dont have. If others more familiar with java/CF are
interested in exploring this further, I'll happily share the docs and play
guinea pig so it can be boiled down into more simple set of 'how to' steps -
I'm sure there's many others who would like to see FM and CF talking.

All the Best

John

[ksmith]

Hi John,
ColdFusion's Sequelink is a JDBC to ODBC bridge that works on windows only.
So it is not in the OSX version of CFMX7. CFMX does not include any driver for
FileMaker. You would need to find a 3rd party JDBC driver for FileMaker.

[Jay_Tea]

Hi there Ken

thanks for a swift response to my forum post, but I can't help wonder if one
of us has misunderstood (hopefully me ;) ) - the Datadirect SequeLink JDBC
driver I have is from Filemaker shipped with their product - not from
Macromedia or included with Coldfusion. I wasn't referring to any drivers
supplied by Macromedia.

I am referring to a JDBC driver supplied by filemaker with their product for
use in utilising Filemaker as a JDBC data source for java apps, which should
mean CF?

Apologies if I'm being outrageously stupid ;)

[mpwoodward *TMM*]

Jay_Tea wrote:

> Hi there Ken
>
> thanks for a swift response to my forum post, but I can't help wonder if one
> of us has misunderstood (hopefully me ;) ) - the Datadirect SequeLink JDBC
> driver I have is from Filemaker shipped with their product - not from
> Macromedia or included with Coldfusion. I wasn't referring to any drivers
> supplied by Macromedia.
>
> I am referring to a JDBC driver supplied by filemaker with their product for
> use in utilising Filemaker as a JDBC data source for java apps, which should
> mean CF?
>
> Apologies if I'm being outrageously stupid ;)
>

If they have a JDBC driver all you really need is their JDBC URL format
and the name of the driver class file. Then you can set up a datasource
of type "other" in the CF administrator and in theory it will work.

Matt

--
Matt Woodward
[email]mpwoodward@gmail.com[/email]
Team Macromedia - ColdFusion

[Jay_Tea]

Hi Matt

After speaking with ken and browsing forums I got the driver loaded into the
CF7/lib/ folder. In CF& admin i chose other driver, and specified class
'com.ddtek.jdbc.sequelink.SequeLinkDriver' and URL
'jdbc:sequelink://192.168.0.200:2399;databaseName=test'

CF7 seems to pick up the driver fine, but i do get an error when i verify the
data source.

Connection verification failed for data source: fm_test
java.sql.SQLException: [DataDirect][SequeLink JDBC Driver][SequeLink
Server]Authorisation failure.
The root cause was that: java.sql.SQLException: [DataDirect][SequeLink JDBC
Driver][SequeLink Server]Authorisation failure.

The test database has a username of 'cf7' with password 'cf7' (full access),
and I've specified those criteria with CF's user/password fields and also with
permutations of the URL from the driver's docs, such as...

jdbc:sequelink://192.168.0.200:2399;databaseName=test;DBUser=cf7;DB Password=cf7
jdbc:sequelink://192.168.0.200:2399;databaseName=test;HUser=cf7;HPa ssword=cf7

Seems like this is pretty close to working, with only authentication left to
suss, I'll give folks an update on what i find from the Filemaker sites, any
suggestions based on similar errors much appreciated ;)

All the best

John

[mpwoodward *TMM*]

Jay_Tea wrote:

> CF7 seems to pick up the driver fine, but i do get an error when i verify the
> data source.
>
> Connection verification failed for data source: fm_test
> java.sql.SQLException: [DataDirect][SequeLink JDBC Driver][SequeLink
> Server]Authorisation failure.
> The root cause was that: java.sql.SQLException: [DataDirect][SequeLink JDBC
> Driver][SequeLink Server]Authorisation failure.
>
> The test database has a username of 'cf7' with password 'cf7' (full access),
> and I've specified those criteria with CF's user/password fields and also with
> permutations of the URL from the driver's docs, such as...
>
> jdbc:sequelink://192.168.0.200:2399;databaseName=test;DBUser=cf7;DB Password=cf7
> jdbc:sequelink://192.168.0.200:2399;databaseName=test;HUser=cf7;HPa ssword=cf7

Unfortunately I have no clue how FileMaker does authentication. Is
there any other means by which you can attempt connecting outside of CF?
For example do the FileMaker folks give you any examples of how to
connect remotely in any language? I'd just be wondering if there's
something going on with authentication in general, or maybe you have the
variables in the JDBC URL not quite right, etc. Just throwing out ideas
here.

Matt

--
Matt Woodward
[email]mpwoodward@gmail.com[/email]
Team Macromedia - ColdFusion

[Jay_Tea]

It's done and it works - that's CFMX7 on OS X 10.4 Server talking with
Filemaker pro 8 Advanced. The last problem was CF7 failing to find its own IP,
switching the JDBC URL to 127.0.0.1 worked a treat - thanks Matt ;)

I've seen a few posts asking about this before me to get the answer 'No' or
'Very Difficult', clearly it's 'Yes' and 'Not too difficult really' For the
others who ask, the steps are:

In Filemaker
FMpro database needs to be open!
Enable ODBC/JDBC sharing in FMpro.
Create a Username/password for coldfusion in your database.
Install the JDBC drvier from the FM CD - run the .jar file from the CD, it's a
n installer which will prompt for an install location, create and choose
~/desktop/newfolder/ and when the installer is finished copy the contents of
~/desktop/newfolder/driver/lib/ (sljc.jar and sljcne.rar) to your CF7 /lib/
folder

In Coldfusion:
create a data source using 'other' as the driver type.
JDBC URL= 'jdbc:sequelink://127.0.0.1:2399;serverdatasource=test'
Driver class= com.ddtek.jdbc.sequelink.SequeLinkDriver
Driver name= whatever you want, 'FM Pro' or something
User Name= the user you created earlier in your FM database
Password= the pass for the FM user you made.

Submit, and then verify - you should get a lovely understated little 'OK' in
status ;)

Thanks to Ken and Matt for their help and prompts.

John

[UberEgnaro]

Can't thank you guys enough for this thread. I've been messing around with
this for awhile and haven't been able to make it work... until now.

I don't know for sure what I was missing before, but it works. I just
cfdump'd my first query from a Filemaker table and it is a beautiful thing.

[CMONEY]

This is fantastic, guys. Yes there are a lot of us looking for this
solution.The only difference in mine is that I am using Windows 2003 Server.

Question: Does this assume that FileMaker Pro 8 needs to be running on the
same web server for this to work or can it work off a remote FielMaker box?

[Jay_Tea]

yes this works remotely - if you look at the thread you'll see where the IP
needs to go - put your remote IP where my example places 192.168.0.200 or
127.0.0.1.

The cautionary (and what foxed me) is that if you are running FM locally with
CF you need to use IP 127.0.0.1 and NOT the actual IP, or CF won't find the
local databases.

All the best

John