Hi, I am in the process of setting up open bd. I am running version 2.0.2 on linux.
I have setup open bd to connect to a firebird database like so: Database type: Other JDBC Url: jdbc:firebirdsql:<servername>/3050://<database_name>.gdb Driver Class: org.firebirdsql.jdbc.FBDriver User Name: <user name> Password: <password> Verification Query: <select first 1 * from testtable> In the administrator, it says that the db connection is fine. But when I run the query using <cfquery> it fails with this error: failed to verify remote server/socket @ databases:3306 It appears that it is using the MySql port of 3306 instead of the Firebird port of 3050. I have also tried to add the openbdnocheck parameter - as per these instructions: *The engine will attempt to verify the network port before making a connection. This is basically a TCP/IP lookup. If it fails it will throw a "failed to verify remote server/socket @". You can disable this check if you add in the "openbdnocheck" as a paramter to the connection URL. For example: jdbc:mysql://localhost:3306/myDatabaseName?useUnicode=true&openbdnocheck *but it didn't seem to make a difference Does anyone have any ideas why this may be the case and what I could do differently? Cheers, Kaye. -- online documentation: http://openbd.org/manual/ http://groups.google.com/group/openbd?hl=en
