How access Firebird employee db via JDBC?
I'm trying to simplify things: Firebird
But I need help connecting to the default employee database.
First time here? Check out the FAQ!
I'm trying to simplify things: Firebird
But I need help connecting to the default employee database.
Extract the jaybird-jdk18-4.0.0-beta-1.zip, then add the folder to the Class Path in LibreOffice and restart >LibreOffice: https://help.libreoffice.org/6.3/en-U...
...
JDBC driver class: org.firebirdsql.jdbc.FBDriver does not work!
In Class Path: Add Archive - /path/to/jaybird-full.X.X.X.jar
Connection String: 127.0.0.1:d:\databases\mydatabase.fdb
I copied employee.fdb and it was messed up. How can I edit this to handle the space in the path?
firebirdsql://localhost:3050/c:/Program Files/Firebird/Firebird_3_0/examples/empbuild/employee.fdb
Thanks Ratslinger, I'll have to try that. I did get LO to display the tables by using the firebirdsql:oo: protocol. I need to rest. Hard to make an example of the easiest employee db!
How do I use alias: firebirdsql:oo://localhost:employee ?
firebirdsql:oo:localhost/3050:employee seems to work even though still indicates an error.
Not certain what error you are getting. On Linux have used this:
firebirdsql:oo://localhost//var/lib/firebird/3.0/data/employee.fdb?charSet=UTF-8
Note that this does not use a port (default), has the full path to the database and includes the Character set used.
Also, I did not use the Jaybird 4.x beta connector but rather the 3.x connector from Firebird. No problems with it.
Thanks again! The ?charSet=UTF-8 got rid of the error message.
Asked: 2019-08-13 23:16:23 +0100
Seen: 194 times
Last updated: Aug 14 '19
arabic language support [closed]
Any way to speed up database search? [closed]
Installation on Fedora 14 system fails. [closed]
converting perfect works data files [closed]
Where can I find sample databases for Base?
compatibility with microsoft access97 [closed]
How do you set up input for many-to-many intersections in Base? [closed]
More information needed. How do you connect to the database? Eror message?