Using pyodbc to connect to sybase gives Request to start/stop database denied (-75) -

Using pyodbc to connect to sybase gives Request to start/stop database denied (-75) -

below configuration: windows 7 x64 running activestate python 2.7.2.5 (64 bit) pyodbc 2.1.8 sql anywhere 12 driver 12.00.01.3924.

when seek connect sybase database, below error:

cnxn = pyodbc.connect('driver={'+driver+'};host='+host+';database='+database+';uid='+username+';pwd='+password+';port='+port)

programmingerror: ('42000', '[42000] [sybase][odbc driver][sql anywhere]request start/stop database denied (-75) (sqldriverconnect); [42000] [sybase][odbc driver][sql anywhere]request start/stop database denied (-75)')

i have tried different versions of pyodbc. tried 32 bit versions of python , pyodbc, not successful. googling around gave me nil concrete, though problem has been around time.

how connect seamlessly? have seen working time on windows xp, not remember python , pyodbc versions now. tried on windows xp same set of above same error. please help!!!

the connection string attributes don't match see here or here sybase, don't have instance test, take next grain of salt.

try syntax using keywords connect method don't have maintain sybase-specific attributes:

server = "{0}:{1}".format(host, port) cnxn = pyodbc.connect(driver=driver, server=server, database=database, uid=username, pwd=password)

also note i'm combining host , port formatted in example.

sybase pyodbc