Logo
Shinguz Home
Google
 
/ch/open

ODBC on Linux

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

Environment

Error

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.