Re: sybase db connection issue
malisetti rammurthy <[email protected]> Sat, 5 Oct 2013 16:25:33 +0530
| Newsgroups | gmane.comp.python.sybase |
|---|---|
| Message-ID | <CACDtChd97X3pCPG3Hc9+DdZ0c4vVMGY=SA_mu9R7TDvZ=RuSBw@mail.gmail.com> |
--===============5361557887034532170== Content-Type: multipart/alternative; boundary=047d7b3a99ee1f177204e7fc4255 --047d7b3a99ee1f177204e7fc4255 Content-Type: text/plain; charset=ISO-8859-1 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 <[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 > > --047d7b3a99ee1f177204e7fc4255 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable <div dir=3D"ltr">Hi Paul,<div><br></div><div>Thanks for spending time to re= ply me for the post.</div><div>Even i tried with python-sybase, it is getti= ng me compilation errors with the downloaded tar ball. I have tried compila= tion on Ubuntu 10.04 OS.</div> <div><br></div><div>If you could provide me debian package for python-sybas= e module, that would be helpful for me.</div><div><br></div><div><br></div>= <div>Thank You,</div><div>Ram Murthy</div><div>=A0</div></div><div class=3D= "gmail_extra"> <br><br><div class=3D"gmail_quote">On Tue, Oct 1, 2013 at 9:49 PM, Ram Murt= hy <span dir=3D"ltr"><<a href=3D"mailto:[email protected]" ta= rget=3D"_blank">[email protected]</a>></span> wrote:<br><bloc= kquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #cc= c solid;padding-left:1ex"> Hello Readers,<br> <br> 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.<br> <br> I am getting the following errors messages :<br> <br> I)<br> >>> con=3Dpymssql.connect(user=3D'<<u></u>host-username>= ', password=3D'<host-password>', host=3D'<host-ip&= gt;:', database=3D'<db-name>')<br> =A0Traceback (most recent call last):<br> =A0 =A0File "<stdin>", line 1, in <module><br> =A0 =A0File "/usr/lib/pymodules/python2.6/<u></u>pymssql.py", lin= e 607, in connect<br> =A0 =A0 =A0raise OperationalError, e[0]<br> pymssql.OperationalError: DB-Lib error message 20009, severity 9:<br> Unable to connect: Adaptive Server is unavailable or does not exist<br> Net-Lib error during Operation now in progress Error 115 - Operation now in= progress<br> --------------------------<br> <br> II)<br> >>> con=3Dpymssql.connect(user=3D'<<u></u>host-username>= ', password=3D'<host-password>', host=3D'<host-ip&= gt;:5150', database=3D'<db-name>')<br> =A0Traceback (most recent call last):<br> =A0 =A0File "<stdin>", line 1, in <module><br> =A0 =A0File "/usr/lib/pymodules/python2.6/<u></u>pymssql.py", lin= e 609, in connect<br> =A0 =A0 =A0raise InterfaceError, e[0] pymssql.InterfaceError: Could not set= connection properties<br> <br> <br> Any suggestions or answers would be helpful.<br> <br> And one thing, is there any another way for connecting to the Sybase DB hos= ted on the remote AIX machine through python / perl script.<br> <br> <br> Thank You,<br> Ram Murthy<br> <br> </blockquote></div><br></div> --047d7b3a99ee1f177204e7fc4255-- --===============5361557887034532170== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline ------------------------------------------------------------------------------ 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 --===============5361557887034532170== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ Python-sybase-misc mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/python-sybase-misc --===============5361557887034532170==--