Symptom
All steps mentioned in KBA 2475541 - "How to install and verify "sqlanydb" for IQ connection with python" are implemented but following error occurs during connection test using python
--test_sqlany.py
import sqlanydb
conn = sqlanydb.connect(uid='dba', pwd='sqlsql', eng='LN161SP04PL03', charset='eucksc' , commlinks='tcpip{host=111.111.111.111;port=1111}' )
curs = conn.cursor()
curs.execute("select 'Hello, world!'")
print( "SQL Anywhere says: %s" % curs.fetchone() )
curs.close()
conn.close()
C:\...>python test_sqlany.py
Traceback (most recent call last):
File "C:\...\Python\Python310\Lib\site-packages\test_sqlany.py", line 2, in <module>
conn = sqlanydb.connect(uid='dba', pwd='sqlsql', eng='LN161SP04PL03', charset='eucksc' , commlinks='tcpip{host=111.111.111.111;port=1111}' )
File "C:\...\Python\Python310\Lib\site-packages\sqlanydb.py", line 524, in connect
return Connection(args, kwargs)
File "C:\...\Python\Python310\Lib\site-packages\sqlanydb.py", line 540, in __init__
parent = Connection.cls_parent = Root("PYTHON")
File "C:\...\Python\Python310\Lib\site-packages\sqlanydb.py", line 465, in __init__
self.api = load_library(os.getenv( 'SQLANY_API_DLL', None ), 'dbcapi.dll', 'libdbcapi_r.so',
File "C:\...\Python\Python310\Lib\site-packages\sqlanydb.py", line 458, in load_library
raise InterfaceError("Could not load dbcapi. Tried: " + ','.join(map(str, names)))
sqlanydb.InterfaceError: ('Could not load dbcapi. Tried: None,dbcapi.dll,libdbcapi_r.so,libdbcapi_r.dylib', 0)
Read more...
Environment
- Windows 10 64bit
- python 3.10.6(64bit)
- IQNC 16.1 SP04.13 Windows x86_64
Product
Keywords
KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview