Contents
What is Firebird odbc?
You may connect to Firebird databases using an ODBC connection defined in Windows. This option allows you to connect 3rd party database utilities (such as MS Access or Crystal Reports) directly to the database.
How do I use ODBC on Firebird?
Configuring the ODBC driver
- Start ODBC Data Source Administrator either from within WinSQL or from the Control Panel.
- Select the Drivers tab and ensure that Firebird/InterBase driver is listed among available driver.
- Select either System DSN or User DSN and click Add button.
- Pick Firebird/InterBase driver and click Finish.
How to access an ODBC DataSource in QGIS?
You can connect to an ODBC datasource in the “add vector layer” dialog, just select “database” as the source type and ODBC as the database type. QGIS uses the ODBC driver for OGR, so the same caveats will apply – that is you will need a table called GEOMETRY_COLUMNS and so on, so your colleague will probably need to modify the database.
How to connect to Firebird 2.5.4 database?
This example illustrates how to connect to a Firebird 2.5.4 database running on a Linux server. •The Firebird database server is configured to accept TCP/IP connections from clients. •The Firebird ODBC driver must be installed on your operating system.
Where can I get the ODBC driver for Firebird?
•The Firebird database server is configured to accept TCP/IP connections from clients. •The Firebird ODBC driver must be installed on your operating system. This example uses the Firebird ODBC driver version 2.0.3.154 downloaded from the Firebird website ( https://www.firebirdsql.org/ ).
Why is my QGIS connection not working at all?
I tried *.accdb but QGIS gets frozen. I can read the same ODBC database from other applications (SQLite, MapInfo), so there is no problem with the ODBC side of it. It looks like something’s not right on the QGIS side. Does anybody know if this connection should work / why is it not working?