ODBC on Linux

/ home / computer / linux / .

Problem with psqlodbc unixODBC (and OpenOffice 1.1.4 and DbDesigner 4.0.5.4 beta)

Siehe auch PDF: ODBC on Linux (20 kyByte)

Environment

SuSE Linux 9.0 with a lot of changes and patches.
Kernel: Linux 2.4.21-266-default
Several unixODBC versions 2.2.8 – 2.2.11a
Several PostgreSQL ODBC drivers (07.03.0200 – 08.00.0004)

Error

[dltest] ERROR: /usr/local/lib/psqlodbc.so: undefined symbol: SQLGetPrivateProfileString
or application hangs
[IM002][unixODBC]Missing server name, port, or database name in call to CC_connect.
[ISQL]ERROR: Could not SQLConnect

psqlodbc

$ ./configure –with-unixodbc ; make ; make install

unixODBC

$ ./configure --sysconfdir=/etc ; make ; make install

Comments

psqlODBC-07.03.0200-82.3 from SuSE did not work!

Tests

$ odbcinst --version
$ strings /usr/local/lib/psqlodbc.so | grep "[0-9][0-9]\.[0-9][0-9]\.[0-9][0-9][0-9][0-9]"
$ dltest /usr/local/lib/psqlodbc.so
$ isql -v -m15 ODBCTestDB
$ nm /usr/local/lib/psqlodbc.so | grep SQLGetPrivateProfileString

Test matrix

	2.2.8	2.2.9	2.2.10	2.2.11a
07.03.0200	1 – ok 2 – ok 3 – ok 4– error 5 -	1 – ok 2 – ok 3 – ok 4– error 5 – none	1 – ok 2 – ok 3 – ok 4– error 5 – none	1 - 2 - 3 - 4 - 5 -
07.05.0001	1 – ok 2 – ok 3 – error 4– 5 -	1 – ok 2 – ok 3 – error 4– (-1 = 18) 5 – U	1 – ok 2 – ok 3 – error 4– (-1 = 18) 5 – U	1 – ok 2 – ok 3 – error 4– (-1=18) 5 –U
08.00.0001	1 – ok 2 – ok 3 – error 4– 5 -	1 – ok 2 – ok 3 – error 4– (-1=18) 5 – U	1 – ok 2 – ok 3 – error 4– (-1=18) 5 – U	1 – ok 2 – ok 3 – error 4– (-1=18) 5 – U
08.00.0002	1 – ok 2 – ok 3 – error 4– 5 -	1 – ok 2 – ok 3 – error 4– (-1=68) 5 – U	1 – ok 2 – ok 3 – error 4– (-1=68) 5 – U	1 – ok 2 – ok 3 – error 4– (-1=68) 5 – U
08.00.0004			1 – ok 2 – ok 3 – ok 4– (-1=68) 5 – U

Summary/Solution

Build tar-ball 08.00.0004 from sources. Then it works.