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/ _______________________________________________ DB-SIG maillist - DB-SIG@python.org http://mail.python.org/mailman/listinfo/db-sig
