Re: [Python-sybase-misc] sybase db connection issue

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 454-5900

On Oct 1, 2013, at 18:19, Ram Murthy <mal...@gm...> 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
> Pyt...@li...
> 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