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
