MaxDB/SAPDB compatibility

Hi,

I'm using SAPDB 7.4.0.35 (32bit linux) on one of our linux servers, all 
clients from Windows and Linux (both 32bit) can access the server w/o 
any problem. Now I need to access the server from a 64bit linux client.

I tried to find a 64bit SAPDB client (7.4.x) for 64bit Linux, but there 
is only a iA64 version and no x86_64 version of the SAPDB software at 
http://www.sapdb.org/7.4/rpm_linux.htm, so I've installed the 
maxdb-callif packages from mysql.com on RHEL4 and Fedora Core 4, ie.
maxdb-callif-7.5.0.34-1.x86_64.rpm/maxdb-callif-7.6.0.34-1.x86_64.rpm

Using the max-db callif package and /etc/odbc.ini

[mytestdb]
Driver = /opt/sdb/interfaces/odbc/lib/libsqlod.so
Setup = /usr/lib64/libsapdbS.so.1
ServerDB=mytestdb
ServerNode=10.16.32.203
SQLMode=INTERNAL
IsolationLevel=Committed

and unixODBC (2.2.11 - or 2.2.12/2.2.8/2.2.7) a connection to the 
database can be established via PHP or isql (unixODBC tool), but when 
querying the database with a SQL statement the result is always broken.

Here and example:

# isql mytestdb testerro tester
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+

---------> The connect works fine

SQL> select firstname, surname from tester.ieeuser \
      where firstname='Timo'

+------------------------------+----------------------+
| FIRSTNAME                    | SURNAME              |
+------------------------------+----------------------+
| Timo                         |                      |
+------------------------------+----------------------+
SQLRowCount returns 1
1 rows fetched

SQL> select surname, firstname from tester.ieeuser \
      where firstname='Timo'

+------------------------------+----------------------+
| FIRSTNAME                    | SURNAME              |
+------------------------------+----------------------+
|                              | Denis                |
+------------------------------+----------------------+
SQLRowCount returns 1
1 rows fetched

---------> This shows that only the first specified column
            is displayed in the result, next example shows
            that 'select (*)' returns only the first column

SQL> select * from tester.ieeuser where firstname='Timo'
+---------+-----------+---------+-------+-----------+--------+
| USER_ID | FIRSTNAME | SURNAME | MNAME | SHORTNAME | IEE_ID |
+---------+-----------+---------+-------+-----------+--------+
| 984     |           |         |       |           |        |
+---------+-----------+---------+-------+-----------+--------+

---------> In comparison to the example a SQL statement like
            select * from <schema>.<table> returns only total
            number of rows fetched, but no data of the result
            is displayed

All examples have been tested both on isql and php.

Any idea to solved this problem?

Cheers, Timo

-- 
IEE S.A. International Electronics & Engineering
Zone Industrielle, L-6468 Echternach, Luxembourg
Phone +(352)72 89 89-801, Fax +(352)72 89 89-109

This e-mail may contain trade secrets or privileged, undisclosed
or otherwise confidential information. If you are not the intended
recipient and have received this e-mail in error, you are hereby
notified that any review, copying or distribution of it is strictly
prohibited. Please inform us immediately and destroy the original
transmittal from your system. Thank you for your co-operation.

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[email protected]