maxdb 64bit client to sapdb 32bit server

[Former Member]

Hello,

is the MaxDB ODBC client compatible to the SAPDB though he can connect to a SAPDB 7.4.3 database on Linux and this on 64 bit client to 32 bit server?

if the current version doesn't do that is there probably an older version available which does this?

Thank you very much for any help

Georg

[TTK · Accepted solution]

Hello Georg

The connection of a ODBC driver to the DB does not depend on the operating system and therefore not of the hardware. I.e. you can connect from a 32-bit client to a 64-bit DB.

Regarding the versions: an ODBC 7.6 or 7.7 should connect to a 7.4 DB.

If there are problems, please provide detailed information what does not work.

Regards Thomas

[Former Member · Accepted solution]

Hi Thomas,

thank you very much for your fast answer.

But after installing the runtime environment....

maxdb-as_runtime-linux-64bit-x86_64-7_7_04_21

on a machine with

Kernel 2.6.23.17-88.fc7

unixODBC-2.2.12-5.fc7

and following odbc.ini - entry linked also as symbolic link to ~/.odbc.ini

[db1]

Description = MaxDB driver

Driver = /opt/sdb/programs/lib/libsdbodbc.so

ServerDB=db1

ServerNode=server1

SQLMode=INTERNAL

IsolationLevel=Committed

I do not get a connection established to sapdb 7.4.3.35

isql dc01 testerro tester

[ISQL]ERROR: Could not SQLConnect

Am I missing something?

Thanx in advance

Georg

[TTK · Accepted solution]

Hello Georg

Unfortunately we have a bug when using MaxDB 7.7 ODBC together with unixODBC (iODBC was not tested, but probably will have the same).

The easiest workaround for you is to use the MaxDB 7.6 ODBC driver which does not suffer on above mentioned problem.

HTH & Regards Thomas

[Former Member · Accepted solution]

Thank you very much Thomas,

this solved the connection problem.

Is it now possible to say something about stability with this configuration?

Could we get some not nice suprises respectively are there known issues?

Or even better ... is the performance and / or stability better with the new client?

Greetings

Georg

[TTK · Accepted solution]

Hello Georg

In general, former data base clients are able to connect to newer database releases. E.g. SQLStudio, which uses ODBC, can connect to databases regardless of the release of the single databases. I.e., usually the other way (new ODBC to older kernels) works, too.

Therefore, there should be no compatibility issue for using 7.6 ODBC with a kernel 7.7.

The 7.6 ODBC driver is a very ripe product, while 7.7 was a new development, which is mostly settled. Of course, 7.7 has some advantages compared with 7.6.

The unixODBC problem is under investigation and will be solved in the next weeks. I will inform you as soon as a test version could be made available.

Regards Thomas

[TTK · Accepted solution]

Hello

under

[ODBC 78 preliminary|https://sapmats-de.sap-ag.de/download/download.cgi?id=FD60PPE34JNHXTP9CW0VR64S2IZFRY4EOW9G00DSB1HY7VHTDR]

you can download a hopefully fixed ODBC driver.

Inside are two tar-archives for Linux x64 and x86 resp.

Please note, that this driver is no official release, but stems from my development environment. Therefore do only use it for evaluation purposes.

If there are still problems with unixODBC please let me know.

Regards Thomas