SapDB 7.4 ODBC connection from a MAXDB driver

[Former Member]

Hi all,

on a linux machine I have to connect to a Sapdb 7_4_3_35 database via unixODBC and python.

On the machine is the a database instance running with MaxDB 7_7_07_16.

The related ODBC driver is also installed. When trying to connect to the 7.4 instance I get an error like

[unixODBC][SAP AG][LIBSDBOD SO][MaxDB] Communication link failure;

-10709 Connection failed (RTE:database not running: no request pipe) (-10709) (SQLDriverConnectW)'

I thought now why not install the sapdb ODBC driver.

On different machines this is no problem but not on this one.

The installation breaks after executing ./SDBINST with a message that the downgrade is not possible:

2: ODBC

3: Server

4: Runtime For SAP AS

5: all

6: none

please enter profile id: 2

starting preparing phase of package Base 7.4.03.35 32 bit

-

---

cannot downgrade package

skipping package

starting preparing phase of package ODBC 7.4.03.35 32 bit

-

---

cannot downgrade package

skipping package

Is there a solution available to connect to both database versions?

I would be thankful for help.

Regards

Georg

[Former Member]

Whole problem was related to SELinux

[former_member229109]

Hello Georg Thome,

Are you SAP customer?

1. u201Con a linux machine I have to connect to a Sapdb 7_4_3_35 database via unixODBC and python.

On the machine is the a database instance running with MaxDB 7_7_07_16.u201D

Please update with output of the command:

sdbregview -l

2. u201COn different machines this is no problem but not on this one.u201D

What version of the database software installed on another machine?

Please update with output of the command running on another machine:

sdbregview -l

3. How did you run ODBC driver update?

Itu2019s looking that you have already ODBC database software version 7.4.03.35 installed on the server.

Could you update the database to the version 7.4.03.37 or higher as build 37 ?

If you are SAP customer, review the SAP note 698915, for example.

Thank you and best regards, Natalia Khlopina

[Former Member]

Hi Natalia,

I was able to download the version 40 "only"

Yes, we are SAP customer.

The database which I want to connect to below is a 7.4.0.3.35 verion with connection server running like

x_server -X -Y -F start

I deinstalled meanwhile the MaxDB version. Nevertheless it doesn't seem to work.

However the installation with SDBINST (only the ODBC client) was this time successful.

Below you can see the output of some commands.

[sapdb@client ~]$ /opt/sapdb/indep_prog/bin/sdbregview -l

Base /opt/sapdb/indep_prog 7.4.03.40 32 bit valid

ODBC /opt/sapdb/indep_prog 7.4.03.40 32 bit valid

[sapdb@client ~]$ rpm -qa |grep unixODBC

unixODBC-2.2.14-11.fc13.i686

[sapdb@client ~]$ isql db1 user password

[ISQL]ERROR: Could not SQLConnect

[sapdb@client ~]$ cat /etc/issue

Fedora release 13 (Goddard)

Kernel \r on an \m (\l)

[sapdb@client ~]$ uname -a

Linux client 2.6.33.3-85.fc13.i686.PAE #1 SMP Thu May 6 18:27:11 UTC 2010 i686 i686 i386 GNU/Linux

[sapdb@client ~]$ cat .odbc.ini

[db1]

Description = SAPDB

Driver = /opt/sapdb/indep_prog/lib/libsqlod.so

Setup = /usr/lib/libsapdbS.so.2.0.0

ServerDB=db1

ServerNode = server1.intern

SQLMode=INTERNAL

IsolationLevel=Committed

[sapdb@client ~]$ ls -la /opt/sapdb/indep_prog/lib/libsqlod.so

-r-xr-xr-x. 1 sapdb sapsys 1664343 May 17 2005 /opt/sapdb/indep_prog/lib/libsqlod.so

[Former Member]

Hi Natalia,

problem is solved. In fact it was not really a problem it was a feature

Always if you have such not identifyable problems .... it is related to..... SELINUX

Yeaph ... that cost me 2 days.

Nevertheless I got now aware of the new "40" version with which I was able to update

one of our servers already w/o problems

Thanx

Georg