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!
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 |
1 – ok |
1 – ok |
1 - |
'07.05.0001 |
1 – ok |
1 – ok |
1 – ok |
1 – ok |
'08.00.0001 |
1 – ok |
1 – ok |
1 – ok |
1 – ok |
'08.00.0002 |
1 – ok |
1 – ok |
1 – ok |
1 – ok |
'08.00.0004 |
|
|
1 – ok |
|
Summar/Solution:
Build tar-ball 08.00.0004 from sources. Then it works.