FMP & Coldfusion 7: soooo close....

[JayTea]

Hi All

I've been trying to setup a FM8 database to supply data dynamically via coldfusion. Why? Well I'm used to CF from the dreamweaver GUI end, so it makes some sense for me to make some DSN connections and design my sites the way i always have, while still benefiting from FMP at the database end rather than learning mySQL from scratch.

Now I've got the JDBC driver installed into CF7, no problem.

I've gotthe class, and the JDBC URL from the driver docs and the guys at macromedia.

I'm so close I can taste it - and if you read the macromedia boards you'd think this was a holy grail.

However, I have one final problem to surmount.

When i verify my DSN in CF7 i ge tthis error...

[color:blue]

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.

[color:black]

The fm_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;DBPassword=cf7

jdbc:sequelink://192.168.0.200:2399;databaseName=test;HUser=cf7;HPassword=cf7

Does anyone with some experince of FM via JDBC have any ideas what I've missed? I'm pretty sure it's obvious to someone

All the best

John

Edited October 3, 2005 by Guest

[Breezer]

Try this:

in FM8,

i) create a new account for your ColdFusion, namely "CFaccount" with whatever access you need it to have.

ii) Create a privilege set for this account and call it say "PrivilegeWeb"

iii) Click on the "Edit" button to edit this extended privilege. On the extended privilege, click on the check box corresponding to "Access via ODBC/JDBC (fmxdbc)"

Remember that the FileMaker file must be running for you to use the ODBC/JDBC driver.