[DB-SIG] pymssql error (was: PEP 249)

M.-A. Lemburg mal at egenix.com
Thu Jul 18 09:24:22 CEST 2013


On 18.07.2013 06:56, ISRAEL DA-COSTA-HOMEM wrote:
> Good night,
> 
> I installed 2.0 pymssql this link http://www.lfd.uci.edu/ ~ Gohlke /
> pythonlibs / # pymssql, but the following error occurred below. I
> uninstalled and installed version pymssql 1.0.2 which worked perfectly.
> What might have gone wrong?
> 
> My py is 2.7.3. If I install using pip also have the same problem.
> I use Sql Server  2008 R2 and IDLE.
> 
> 
> 
> Traceback (most recent call last):
>   File "C:\Users\Israel\Desktop\local_sql.py", line 4, in <module>
>     con = pymssql.connect(host = 'localhost', user = 'sa', password = 'sa',
> database = 'teste_db')
>   File "pymssql.pyx", line 556, in pymssql.connect (pymssql.c:7990)
>     raise OperationalError(e[0])
> OperationalError: (20009, 'Net-Lib error during Unknown error')

It usually helps searching the net for the error string :-)

http://code.google.com/p/pymssql/issues/detail?id=74
http://pyyou.wordpress.com/2009/02/01/install-pymssql-and-how-to-deal-with-db-lib-error-message-20009-severity-9/
http://stackoverflow.com/questions/15706078/pymssql-python-connection-string

If one of those links don't help, I'd suggest contacting the
package author or filing a bug report.

-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Source  (#1, Jul 18 2013)
>>> Python Projects, Consulting and Support ...   http://www.egenix.com/
>>> mxODBC.Zope/Plone.Database.Adapter ...       http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________

::::: Try our mxODBC.Connect Python Database Interface for free ! ::::::

   eGenix.com Software, Skills and Services GmbH  Pastor-Loeh-Str.48
    D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
           Registered at Amtsgericht Duesseldorf: HRB 46611
               http://www.egenix.com/company/contact/


More information about the DB-SIG mailing list