Question Re: Unable to connect to ASE 16 with python 3.8 on RHEL8 in Technology Q&A

Unable to connect to ASE 16 with python 3.8 on RHEL8

herve_bauchon — Thu, 17 Feb 2022 08:32:49 GMT

Hi,

I've a ASE 16 installed on RHEL 8 with python3.8 and I'm unable to connect to the server with python.

If I do not specify the password with the default test.py, I have a Login Failed (normal behaviour) :

python test.py

Cannot raise error, context is NULL

Traceback (most recent call last):

File "test.py", line 55, in <module>

conn = sybpydb.connect(user='sa', password='')

sybpydb.ProgrammingError: ('Login failed.\n', 4002)

If I put the good password , it seems that the connection is done but I have the following error message :

python test.py

Traceback (most recent call last):

File "test_HBC.py", line 55, in <module>

conn = sybpydb.connect(dsn="user=sa;password=XXXXXXX")

sybpydb.ProgrammingError: ('ct_con_props(): user api layer: external error: An illegal value of 9234 given for parameter property.', 5)

MyASE version is Adaptive Server Enterprise/16.0 SP03 PL10/EBF 29808 SMP/P/x86_64/SLES 11.1/ase160sp03pl10x/3880/64-bit/FBO/Wed May 12 20:32:12 2021

I tried to use all sybpydb.py installed on my server, the latest I have is in $SYBASE /OCS-16_0/python/python34_64r/lib

My PYTHONPATH is (I also tried with other python3x_64r versions)

setenv PYTHONPATH ${SYBASE}/${SYBASE_OCS}/python/python37_64r/lib:${SYBASE}/${SYBASE_OCS}/lib

My PYthon version is :

Python 3.8.8 (default, Aug 11 2021, 06:52:42)

[GCC 8.5.0 20210514 (Red Hat 8.5.0-3)] on linux

Python 3.8 is not supported ? I should install python 3.7 instead ?thank you for your helpRegardsHervé

Re: Unable to connect to ASE 16 with python 3.8 on RHEL8

Vitaliy-R — Thu, 17 Feb 2022 13:52:09 GMT

Hi Bauchon. I added the ASE tag to make your question visible in the relevant community. Regards. -Witalij

Re: Unable to connect to ASE 16 with python 3.8 on RHEL8

ryan_hansen — Wed, 09 Mar 2022 16:43:39 GMT

Currently Python 3.8 is not supported.

Current version of python we have built modules for:
~/ase1641$ cd OCS-16_0/python

~/ase1641/OCS-16_0/python$ ls

python26_64r python26ucs4_64r python31_64r python34_64r python37_64r

python26_64r = Python 2.6

python26ucs4_64r = Python 2.6

python31_64r = Python 3.1

python34_64r = Python 3.4

python37_64r = Python 3.7

We are currently trying to release a new python module for newer versions of python.

Re: Unable to connect to ASE 16 with python 3.8 on RHEL8

herve_bauchon — Thu, 10 Mar 2022 09:55:37 GMT

Thank you for the confirmation.

however, we managed to make this connection work by removing the libraries used by our client application (Kondor) from the LD_LIBRARY_PATH used by our python program.

Re: Unable to connect to ASE 16 with python 3.8 on RHEL8

ryan_hansen — Fri, 24 Jun 2022 18:53:20 GMT

Hi,

Please note that Python 3.9 is now supported in ASE/SDK 16.0 SP04 PL02.

Hope this helps,
Ryan

Re: Unable to connect to ASE 16 with python 3.8 on RHEL8

HarshPatel1 — Wed, 22 May 2024 10:19:08 GMT

Hey, @ryan_hansen, can you please confirm that do other python version like 3.9 and above are supported or not?