Howto install firebird odbc driver for unixodbc (from source )

Here is an small guide on installing firebird odbc driver from source (alternate you can install it from binary repository )

A good reference to unixodbc is located here
First step is to  have installed unixodbc on fedora:

yum install unixODBC unixODBC-develop

and on ubuntu (debian):

sudo apt-get install unixodbc unixodbc-dev

then checkout the odbc driver :

cvs -d:pserver:anonymous@firebird.cvs.sourceforge.net:/cvsroot/firebird login
cvs -z3 -d:pserver:anonymous@firebird.cvs.sourceforge.net:/cvsroot/firebird co OdbcJdbc

cd OdbcJdbc/Builds/Gcc.lin
make -f makefile.linux

Next read the readme.linux

driver seems to be in directory OdbcJdbc/Builds/Gcc.lin/Release

cd OdbcJdbc/Builds/Gcc.lin/Release
sudo cp *.so /usr/lib
sudo ln -s /usr/lib/libIscDbc.so /usr/lib/IscDbc

create content in the folowing files
cat /etc/odbcinst.ini
[Firebird]
Description = Firebird ODBC Driver
Driver = /usr/lib/libOdbcJdbc.so
Setup = /usr/lib/libOdbcJdbcS.so
Threading = 1
FileUsage = 1
CPTimeout =
CPReuse =

cat /etc/odbc.ini
[help]
Description = Firebird
Driver = Firebird
Dbname = localhost:/var/lib/firebird/2.0/system/help.fdb
User = SYSDBA
Password = masterkey
Role =
CharacterSet =
ReadOnly = No
NoWait = No

isql -v help
+—————————————+
| Connected!                 |
+—————————————+
SQL> select * from topics;

ps: i assume that firebird and g++ are already installed on the system

1 Star2 Stars3 Stars4 Stars5 Stars (8 votes, average: 3.63 out of 5)
Loading...

Leave a Reply