Is there a module available for connection of MSSQL and python 2.7? I downloaded pymssql but it is for python 2.6. Is there any equivalent module for python 2.7?
I\'m new to python.I\'m trying to query a MSSQL database. import pymssql conn = pymssql.connect(host=\'hostname\', user=\'username\', password=\'password\', database=\'dbname\')
I have python application that shoud be launched as windows executable. I\'m using py2exe and pymssql 1.9.908.
I have two 2 databases. One with MSSQL and another with Postgresql. I want that my python script is running (for this I use a cron-job on linux), every day.
I just upgraded to a Windows 7 box and installed MS SQL Server 2005 and am trying 开发者_StackOverflowto open and connect to my local machine using Windows Authentication.
As instructed in the README and here http://code.google.com/p/pymssql/wiki/Compilation, I\'ve installed Cython (v0.14.1), FreeTDS (v0.82 using MacPorts), and I already have XCode installed with gcc.
I\'m running a cherrypy webservice and wondering what the best option is to recover from \"connection reset by peer\" for a pymssql connection via sqlalchemy. Right now I have to resta开发者_运维问答r
I\'ve used pymssql-1.0.2 and freetds-0.82.7 on ubuntu-10.10. Also, I have a mssql2008 server on windows-7.
I\'m execute a simple mssql query from python. I can see in the profiler that the query reach the DB. The query has 1 row of answer.
I\'m trying to build a simple search engine for a small website. My initial thought is to avoid using larger packages such as Solr, Haystack, etc. because of the simplistic nature of my search needs.