pymssql connection problem

VV W <[email protected]> Thu, 10 Sep 2009 13:21:22 -0700
Newsgroups gmane.comp.python.sybase
Message-ID <[email protected]>
--===============3226147293170343282==
Content-Type: multipart/alternative; boundary=00151748e8c06b504004733ef178

--00151748e8c06b504004733ef178
Content-Type: text/plain; charset=ISO-8859-1

Hello,

I modified my script and tested again with

 con=pymssql.connect(dsn='sybase-sever.mycompany.com', user='sa',
password='',host="12.12.12.12",database='db-name')

and now I got


 File "/var/lib/python-support/python2.5/pymssql.py", line 328, in connect
    con = _mssql.connect(dbhost, dbuser, dbpasswd)
_mssql.error: 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

this is the problem that I got yesterday. It's really frustrating.

Anybody can give me a clue?

Thanks so much.

--00151748e8c06b504004733ef178
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div>Hello, </div>
<div>=A0</div>
<div>I modified my script and tested again with </div>
<div>=A0</div>
<div>=A0con=3Dpymssql.connect(dsn=3D&#39;<a href=3D"http://sybase-sever.myc=
ompany.com">sybase-sever.mycompany.com</a>&#39;, user=3D&#39;sa&#39;, passw=
ord=3D&#39;&#39;,host=3D&quot;12.12.12.12&quot;,database=3D&#39;db-name&#39=
;)</div>
<div>=A0</div>
<div>and now=A0I got</div>
<div>=A0</div>
<div><br>=A0File &quot;/var/lib/python-support/python2.5/pymssql.py&quot;, =
line 328, in connect<br>=A0=A0=A0 con =3D _mssql.connect(dbhost, dbuser, db=
passwd)<br>_mssql.error: 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<br>Error 115 - Operation now=
 in progress<br></div>
<div>=A0</div>
<div>this is the problem that I got yesterday. It&#39;s really frustrating.=
 </div>
<div>=A0</div>
<div>Anybody can give me a clue? </div>
<div>=A0</div>
<div>Thanks so much. </div>

--00151748e8c06b504004733ef178--


--===============3226147293170343282==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
--===============3226147293170343282==
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

--===============3226147293170343282==--