Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

connect base to firebird - how??

Reading a previous answer, I now understand that from LO 6.1 onwards Base will have Firebird as the embedded server. That is great - I really approve of the ethics behind the group who do the Fire* software :)

So I thought I would get a head start on learning the little quirks that every different SQL engine has (so much for standards, eh wot?). It is not practical for me to install a newer version of LO (I am stuck on 5.2.7 at the mo) so I installed the firebird 3.0 server on the same machine that is running LO.

How do I connect from Base to Firebird? Feel free to point me to a useful howto page if you know of one. Otherwise the following are my specific questions.

Do you recommend ODBC or JDBC? (I am already familiar with JDBC as I use it for both Mariadb and MySQL external databases, but I am happy to start learning ODBC if appropriate)

If JDBC, where do I download the Java connector class? And does the URL start with firebird://localhost ? And what port number?

If ODBC, I know I will need libodbc.so.1 butwhat else, if anything, will I need? How would I register my firebird b with LO?

Anythijng else I should know?

Many thanks for your help already on other threads over the last few days... and thanks for your help on this one

connect base to firebird - how??

Reading a previous answer, I now understand that from LO 6.1 onwards Base will have Firebird as the embedded server. That is great - I really approve of the ethics behind the group who do the Fire* software :)

So I thought I would get a head start on learning the little quirks that every different SQL engine has (so much for standards, eh wot?). It is not practical for me to install a newer version of LO (I am stuck on 5.2.7 at the mo) so I installed the firebird 3.0 server on the same machine that is running LO.

How do I connect from Base to Firebird? Feel free to point me to a useful howto page if you know of one. Otherwise the following are my specific questions.

I have LO 5.2.7 installed on a Debian-based system

Do you recommend ODBC or JDBC? (I am already familiar with JDBC as I use it for both Mariadb and MySQL external databases, but I am happy to start learning ODBC if appropriate)

If JDBC, where do I download the Java connector class? And does the URL start with firebird://localhost ? And what port number?

If ODBC, I know I will need libodbc.so.1 butwhat else, if anything, will I need? How would I register my firebird b with LO?

Anythijng else I should know?

Many thanks for your help already on other threads over the last few days... and thanks for your help on this one

connect base to firebird - how??

Reading a previous answer, I now understand that from LO 6.1 onwards Base will have Firebird as the embedded server. That is great - I really approve of the ethics behind the group who do the Fire* software :)

So I thought I would get a head start on learning the little quirks that every different SQL engine has (so much for standards, eh wot?). It is not practical for me to install a newer version of LO (I am stuck on 5.2.7 at the mo) so I installed the firebird 3.0 server on the same machine that is running LO.

According to ps the server is running and waiting for me.

I also know the first thing I need to do is to connect to the security3 database as the admin user, so I can create other databases. Tools->SQL methinks.

But that is where I am stuck: How do I connect from Base to Firebird?

Feel free to point me to a useful howto page if you know of one. Otherwise the following are my specific questions.

I have LO 5.2.7 installed on a Debian-based system

Do you recommend ODBC or JDBC? (I am already familiar with JDBC as I use it for both Mariadb and MySQL external databases, but I am happy to start learning ODBC if appropriate)

If JDBC, where do I download the Java connector class? And does the URL start with firebird://localhost ? And what port number?

If ODBC, I know I will need libodbc.so.1 butwhat else, if anything, will I need? How would I register my firebird b with LO?

Anythijng else I should know?

Many thanks for your help already on other threads over the last few days... and thanks for your help on this one

click to hide/show revision 4
None

connect base to firebird - how??

Reading a previous answer, I now understand that from LO 6.1 onwards Base will have Firebird as the embedded server. That is great - I really approve of the ethics behind the group who do the Fire* software :)

So I thought I would get a head start on learning the little quirks that every different SQL engine has (so much for standards, eh wot?). It is not practical for me to install a newer version of LO (I am stuck on 5.2.7 at the mo) so I installed the firebird 3.0 server on the same machine that is running LO. According to ps the server is running and waiting for me.

I also know the first thing I need to do is to connect to the security3 database as the admin user, so I can create other databases. Tools->SQL methinks.

But that is where I am stuck: How do I connect from Base to Firebird?

Feel free to point me to a useful howto page if you know of one. Otherwise the following are my specific questions.

I have LO 5.2.7 installed on a Debian-based system

Do you recommend ODBC or JDBC? (I am already familiar with JDBC as I use it for both Mariadb and MySQL external databases, but I am happy to start learning ODBC if appropriate)

If JDBC, where do I download the Java connector class? And does the URL start with firebird://localhost ? And what port number?

If ODBC, I know I will need libodbc.so.1 butwhat else, if anything, will I need? How would I register my firebird b with LO?

Anythijng else I should know?

Many thanks for your help already on other threads over the last few days... and thanks for your help on this one

connect base to firebird firebird(server) - how??

Reading a previous answer, I now understand that from LO 6.1 6.2 onwards Base will have Firebird as the embedded server. That is great - I really approve of the ethics behind the group who do the Fire* software :)

So I thought I would get a head start on learning the little quirks that every different SQL engine has (so much for standards, eh wot?). It is not practical for me to install a newer version of LO (I am stuck on 5.2.7 at the mo) so I installed the firebird 3.0 server on the same machine that is running LO. According to ps the server is running and waiting for me.

I also know the first thing I need to do is to connect to the security3 database as the admin user, so I can create other databases. Tools->SQL methinks.

But that is where I am stuck: How do I connect from Base to Firebird?

Feel free to point me to a useful howto page if you know of one. Otherwise the following I have now realised that my problems have been compounded by running an unusual OS, which has been causing problems that are my specific questions.not directly connected with either LO or FireBird.

I have now moved those issues to

https://ask.libreoffice.org/en/question/162163/running-lo-with-a-local-non-embedded-database-under-qubes-os/

I have LO 5.2.7 installed on a Debian-based systemsystem based on an older Debian version.

Do you recommend ODBC or JDBC? (I am already familiar with JDBC as I use it for both Mariadb and MySQL external databases, but I am happy to start learning ODBC if appropriate)

If JDBC, where do I download the Java connector class? And does the URL start with firebird://localhost ? And what port number?

If ODBC, I know I will need libodbc.so.1 butwhat else, if anything, will I need? How would I register my firebird b with LO?

Anythijng else I should know?

Many thanks for your help already on other threads over the last few days... and thanks for your help on this one