Pingu
Computer MySQL PostgreSQL Books Publications
Spielereien Kanu Business TopoDB POI Klettersteigen History TransPool Thermal Baden Brokenstuben Goldwaschen
Blog Contact
Shinguz
Google
/ch/open

ODBC on Linux

ODBC on Linux

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

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

  1. odbcinst –version
  2. strings /usr/local/lib/psqlodbc.so | grep “[0-9][0-9].[0-9][0-9].[0-9][0-9][0-9][0-9]”
  3. dltest /usr/local/lib/psqlodbc.so
  4. isql -v -m15 ODBCTestDB
  5. 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.