sybase db connection issue

Ram Murthy <[email protected]> Tue, 01 Oct 2013 21:49:27 +0530
Newsgroups gmane.comp.python.sybase
Message-ID <[email protected]>
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


------------------------------------------------------------------------------
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60134791&iu=/4140/ostg.clktrk