[Python-sybase-misc] sybase db connection issue

[Ram M. <mal...@gm...>]

Hello Readers,

I have a bit tricky problem with establishing the sybase db connection 
with python-pymssql module. I am not sure what the error messages 
exactly mean. The sybase db is residing on the remote host and i am 
trying to access it with a python script.

I am getting the following errors messages :

I)
 >>> con=pymssql.connect(user='<host-username>', 
password='<host-password>', host='<host-ip>:', database='<db-name>')
  Traceback (most recent call last):
    File "<stdin>", line 1, in <module>
    File "/usr/lib/pymodules/python2.6/pymssql.py", line 607, in connect
      raise OperationalError, e[0]
pymssql.OperationalError: DB-Lib error message 20009, severity 9:
Unable to connect: Adaptive Server is unavailable or does not exist
Net-Lib error during Operation now in progress Error 115 - Operation now 
in progress
--------------------------

II)
 >>> con=pymssql.connect(user='<host-username>', 
password='<host-password>', host='<host-ip>:5150', database='<db-name>')
  Traceback (most recent call last):
    File "<stdin>", line 1, in <module>
    File "/usr/lib/pymodules/python2.6/pymssql.py", line 609, in connect
      raise InterfaceError, e[0] pymssql.InterfaceError: Could not set 
connection properties


Any suggestions or answers would be helpful.

And one thing, is there any another way for connecting to the Sybase DB 
hosted on the remote AIX machine through python / perl script.


Thank You,
Ram Murthy