Hello, I am having trouble installing the driver for Firebird. Unfortunately, I know NOTHING about Java and am hoping SQLeo will give me the WYSIWYG tools I need.
But when I highlight Firebird and I click "install" in the lower right, it wants files of type .jar or .zip. However, there is no file named fbdriver.jar or fbdriver.zip anywhere in my system. Only fbdriver.html.
I don't know what to try next...
Thanks!
Cathy
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
jdbc:firebirdsql://host[:port]/<database></database>
This will connect to the database using the Type 4 JDBC driver using the Java implementation of the Firebird wire-protocol. This is best suited for client-server applications with dedicated database server. Port can be omitted (default value is 3050), host name must be present.
The <database> part should be replaced with the database alias or the path to the database. In general it is advisable to use database aliases instead of the path of the database file as it hides implementation details like file locations and OS type.</database>
On Linux the root / should be included in the path. A database located on /opt/firebird/db.fdb should use (note the double slash after port!):
jdbc:firebirdsql://host:port//opt/firebird/db.fdb
On my side I use an old version 2.1.6, that also need the fbclient.dll to be copied in the same directory or SQLeo ...
would be pleased if this is enough to make it work for you (and others).
Regards
PAscal
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Thank you Pascal. I have Jaybird (the Firebird jdbc driver) installed also...the driver it is requesting is not there either. However, I will try using the url that you specified above, as I have not tried that before. Will keep you posted.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Ah! I think my problem is different than what you have explained above. In SQLeo, my database shows up in the Firebird tree and the url is as you described. But the status is disconnected. Also at the bottom of my screen it says java.lang.ClassNotFoundException: org.firebirdsql.jdbc.FBDriver. When I select my database and enter my credentials, there is a popup that says "No driver found, please install one by selecting driver from Install button provided on the bottom of parent node". But when I click "install" this is where I am not sure how to find the driver it's looking for... I don't know what path to put there. I can't find FBDriver.jar anywhere...
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
Anonymous
-
2014-09-01
I have the same problem. Downloaded Jaybird drivers,
installed the file "jaybird-full-2.2.5.jar" in SQLeo and I still get the message
A DB Connection is not possible. I guess the driver is not recognized in SQLeo.
Do we have to make any settings out side SQLeo?
As like CathyB I do not have Java experience.
Thanks in advance
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
what is your java version ?
which driver did you download ?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
Anonymous
-
2014-09-01
(1) Firebird Server 2.5.2.26540 running as service on Windows XP
(2) Java Version 7 Update 51 (build 1.7.0_51-b13)
(3) Jaybird Driver jaybird-full-2.2.5 (newest)
(4) SQLeo version 2014.08.rc1 (newest)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello, I am having trouble installing the driver for Firebird. Unfortunately, I know NOTHING about Java and am hoping SQLeo will give me the WYSIWYG tools I need.
But when I highlight Firebird and I click "install" in the lower right, it wants files of type .jar or .zip. However, there is no file named fbdriver.jar or fbdriver.zip anywhere in my system. Only fbdriver.html.
I don't know what to try next...
Thanks!
Cathy
I'm not anonymous anymore - I registered so I can be notified when there's an answer. :-)
Cathy B
Hello Cathy,
to make it work, you have to download the jdbc driver for Firebird (not provided with SQLeo)
see http://www.firebirdsql.org/file/documentation/drivers_documentation/java/faq.html#pure-java-default for more informations.
Download are here:
http://www.firebirdsql.org/en/jdbc-driver/
Url to be defined in SQLeo:
jdbc:firebirdsql://host[:port]/<database></database>
This will connect to the database using the Type 4 JDBC driver using the Java implementation of the Firebird wire-protocol. This is best suited for client-server applications with dedicated database server. Port can be omitted (default value is 3050), host name must be present.
The <database> part should be replaced with the database alias or the path to the database. In general it is advisable to use database aliases instead of the path of the database file as it hides implementation details like file locations and OS type.</database>
On Linux the root / should be included in the path. A database located on /opt/firebird/db.fdb should use (note the double slash after port!):
jdbc:firebirdsql://host:port//opt/firebird/db.fdb
On my side I use an old version 2.1.6, that also need the fbclient.dll to be copied in the same directory or SQLeo ...
would be pleased if this is enough to make it work for you (and others).
Regards
PAscal
Thank you Pascal - see my latest comment for more explanation. :-)
Got it! I was using the incorrect version of Jaybird. It is working now, thanks!
Thank you Pascal. I have Jaybird (the Firebird jdbc driver) installed also...the driver it is requesting is not there either. However, I will try using the url that you specified above, as I have not tried that before. Will keep you posted.
Ah! I think my problem is different than what you have explained above. In SQLeo, my database shows up in the Firebird tree and the url is as you described. But the status is disconnected. Also at the bottom of my screen it says java.lang.ClassNotFoundException: org.firebirdsql.jdbc.FBDriver. When I select my database and enter my credentials, there is a popup that says "No driver found, please install one by selecting driver from Install button provided on the bottom of parent node". But when I click "install" this is where I am not sure how to find the driver it's looking for... I don't know what path to put there. I can't find FBDriver.jar anywhere...
I have the same problem. Downloaded Jaybird drivers,
installed the file "jaybird-full-2.2.5.jar" in SQLeo and I still get the message
ClassNotFoundException: org.firebirdsql.jdbc.FBDriver
A DB Connection is not possible. I guess the driver is not recognized in SQLeo.
Do we have to make any settings out side SQLeo?
As like CathyB I do not have Java experience.
Thanks in advance
what is your java version ?
which driver did you download ?
(1) Firebird Server 2.5.2.26540 running as service on Windows XP
(2) Java Version 7 Update 51 (build 1.7.0_51-b13)
(3) Jaybird Driver jaybird-full-2.2.5 (newest)
(4) SQLeo version 2014.08.rc1 (newest)
Cathy was java 1.7 but was trying jdbc 2.2.5 JDK_1.8 (latest version) and failed.
Problem was solved by taking jdbc 2.2.5 JDK_1.7
which jdbc version are you trying ?
Problem solved!
I was using jdbc 1.8, now it works with jdbc 1.7.
Upgrading my java version could have solved the problem to, I think.
Thanks a lot PAscal.
(Why is it always such an issue with versions?)