Firebird News

Thursday, October 18, 2007

IBPhoenix Open Source ODBC Driver

compiling and installing it on ubuntu
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 OdbcJdbc/Builds/Gcc.lin/Release
sudo cp *.so /usr/lib
sudo ln -s /usr/lib/IscDbc.so /usr/lib/IscDbc

sudo ln -s /usr/lib/libIscDbc.so /usr/lib/IscDbc

cat /etc/odbcinst.ini
[Firebird]
Description = InterBase/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;
IBPhoenix Open Source ODBC Driver

Blogged with Flock

No comments: