Re: sybase db connection issue

On Oct 1, 2013, at 18:19, Ram Murthy <[email protected]> wrote:

> 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
> _______________________________________________
> Python-sybase-misc mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/python-sybase-misc

Hi Ram!

I'm not sure you posted to the right list.. 
You are using pymssql (http://code.google.com/p/pymssql/), this list is about the python-sybase (http://sourceforge.net/projects/python-sybase/) module.

All the best

Paul


------------------------------------------------------------------------------
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