Was FB's JDBC Driver jar in
I haven't played with FB and CFMX on the released version (just the port). It has been a while, but I remember having some problems with FB.
It could be, that you have done something to your particular database, that is causing the errors -- FB could have detected an error in the db and is restricting your access. (I have seen this happen on several different RDBMSs, if they are not shut down properly).
Can you start with a clean copy of the FB database?
Can you run the query through ViennaSQL or the SQL GUI that comes with FB?
Can you approximate the db on another RDBMS (the built-in PointBase allows uo to 500 records in a db)?
You didn't include the contents of the query in the error message -- Is CF choking on the query or FB?
If it is CF, could you create the query string as a variable, display it, then include it between the cfquery tags? It would be nice to see the query.
Whenyou do resololve it, please post the solution.