Subject Problem installing ODBC driver on CentOS 7 linux
Author Nagy Szilveszter
Hello all!

Please somebody help me with installing ODBC driver on CcentOS linux. I need it to make Sphinx work.

First i installed firebird-superserver, gcc-c++ and unixodbc problem here.

But when compiling the ODBC driver i get this error:

[root@pali2 Gcc.lin]# make -f makefile.linux
../makefile.environ:6: ARCH is x86_64
../makefile.environ:21: ODBCMANAGER is unixODBC in /usr/lib64
../makefile.environ:50: FBINCDIR is /usr/lib64/firebird/include
../makefile.environ:56: FBLIBDIR is /usr/lib64/firebird/lib
mkdir: cannot create directory ‘Release_x86_64’: File exists
make: [createdirs] Error 1 (ignored)
mkdir: cannot create directory ‘Release_x86_64/obj’: File exists
make: [createdirs] Error 1 (ignored)
g++ -w -D_REENTRANT -D_PTHREADS -DEXTERNAL -DunixODBC -I/usr/include -I/usr/lib64/firebird/include -I/include -I/usr/lib64/firebird/include -fPIC -m64 -DNDEBUG -c ../../IscDbc/Attachment.cpp -o Release_x86_64/obj/Attachment.o
In file included from ../../IscDbc/Attachment.cpp:35:0:
../../IscDbc/IscDbc.h:33:19: fatal error: ibase.h: No such file or directory
 #include <ibase.h>
compilation terminated.
make: *** [Release_x86_64/obj/Attachment.o] Error 1

Then i tried another way:

I downloaded the ready-to-run version ODBC driver, from FB main site:
November 26, 2014OdbcFb-LIB-
1.0 MB
Linux x86 Library

I unzipped and copied it to /usr/lib/firebird/

I also made 2 another copies because the provided odbc config referred to and files, and i had none of them. I guess the compiler should create them.

(Note: First i tried with symlinks, but not working i created real copies. But also not working.)

Here are odbc configs:

[root@pali2 Gcc.lin]# cat /etc/odbcinst.ini

Description = Firebird ODBC Driver
Driver = /usr/lib/firebird/
Setup = /usr/lib/firebird/
Threading = 1
FileUsage = 1
CPTimeout =
CPReuse =

[root@pali2 Gcc.lin]# cat /etc/odbc.ini
Description = Firebird
Driver = Firebird
Dbname = localhost:/data/sample.fdb
Password = masterkey
Role =
CharacterSet = UTF8
ReadOnly = No
NoWait = No

When trying to connect i get this error:

[root@pali2 Gcc.lin]# isql -v sample
[01000][unixODBC][Driver Manager]Can't open lib '/usr/lib/firebird/' : file not found
[ISQL]ERROR: Could not SQLConnect

The /usr/lib/firebird/ file DOES EXIST.
On a forum i read that someone had the same issue and installing libstdc++ solved the problem.
But i had it installed before:

[root@pali2 Gcc.lin]# rpm -qa | grep libstdc++

Here is my system's architecture:

[root@pali2 Gcc.lin]# uname -a
Linux pali2 3.10.0-327.el7.x86_64 #1 SMP Thu Nov 19 22:10:57 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux

Please help me!

Thank you,