ODBC on Linux

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

Environment:

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!

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

Summar/Solution:

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