 | | | MaxDB/SAPDB compatibility | MaxDB/SAPDB compatibility 2007-03-21 - By Timo Denis
Back
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 (See http://lif-7.ora-code.com).5.0.34-1.x86_64.rpm/maxdb-callif-7 (See http://lif-7.ora-code.com).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/maxdb?unsub=mysql@(protected)
|
|
|