on 09-06-2010 6:27 PM
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
Whole problem was related to SELinux
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
95 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.