import sqlanydb
myuid = 'user'
mypwd = 'user_psw'
mydsn = "ASA17_test"

# Create a connection object, then use it to create a cursor

con = sqlanydb.connect( dsn=mydsn, userid=myuid, password=mypwd )

cursor = con.cursor()

sql = "SELECT * FROM any_table"
cursor.execute(sql)

  File "C:\projects\Python\asa17\venv\lib\site-packages\sqlanydb.py", line 456, 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)

import pyodbc

cn_host = 'host'
cn_port = '2638'
cn_dbn = 'database'
cn_eng = 'srv_database'
cn_usr = 'user'
cn_psw = 'password'
cn_drv = '{SQL Anywhere 17}'
cn_lnk = 'TCPIP{HOST='+cn_host+':'+cn_port+'}'

# cnxn = pyodbc.connect('DRIVER={SQL Anywhere 17};SERVER='+server+';DATABASE='+database+';UID='+username+';PWD='+ password)

conn_string = 'Driver='+cn_drv+';LINKS='+cn_lnk+';ENG='+cn_eng+';DBN='+cn_dbn+';UID='+cn_usr+';PWD='+ cn_psw

cnxn = pyodbc.connect(conn_string)

sql = "SELECT top 10 * FROM sample_table"

cursor = cnxn.cursor()
cursor.execute(sql)

row = cursor.fetchone()
while row:
    print(row[0])
    row = cursor.fetchone()