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

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

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

Hi Paul,

Thanks for spending time to reply me for the post.
Even i tried with python-sybase, it is getting me compilation errors with
the downloaded tar ball. I have tried compilation on Ubuntu 10.04 OS.

If you could provide me debian package for python-sybase module, that would
be helpful for me.


Thank You,
Ram Murthy



On Tue, Oct 1, 2013 at 9:49 PM, 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
>
>