-
akukula added damoxc to the Simple MS SQL Python extension module project.
2009-09-17 09:41:50 UTC in Simple MS SQL Python extension module
-
Read the whole thread, there are answers.
2009-07-20 19:30:46 UTC in Simple MS SQL Python extension module
-
I don't know if I understood you correctly.
If you're connecting to local SQL server, just use '.' instead of hostname or IP address.
If you intend to use Windows authentication, don't use user and password arguments; instead use trusted=True, as specified in documentation.
If it hangs, the hostname is probably not what you expect. Add some print statements before pymssql.connect to see...
2009-07-20 05:27:11 UTC in Simple MS SQL Python extension module
-
This way you can obtain only numeric indexes
[tuple([row[r] for r in sorted(row.keys()) if type(r) == int]) for row in conn]
this way the rest
[tuple([row[r] for r in sorted(row.keys()) if type(r) != int]) for row in conn]
adapt to your needs.
2009-06-27 23:21:53 UTC in Simple MS SQL Python extension module
-
Double quotes is certainly the problem.
About query length, try below code:
import pymssql
con=pymssql.connect(host='.',user='sa',password='P@ssw0rd')
cur=con.cursor()
query = 'SELECT '
for i in xrange(4095):
query += "'this is column data %d' AS col%d, " % (i,i)
query += "'final column' AS col4095"
cur.execute(query)
res = cur.fetchone()
print...
2009-06-10 20:46:18 UTC in Simple MS SQL Python extension module
-
akukula committed patchset 176 of module pymssql to the Simple MS SQL Python extension module CVS repository, changing 1 files.
2009-06-06 14:41:31 UTC in Simple MS SQL Python extension module
-
akukula committed patchset 176 of module pymssql to the Simple MS SQL Python extension module CVS repository, changing 1 files.
2009-06-06 14:41:31 UTC in Simple MS SQL Python extension module
-
akukula committed patchset 175 of module pymssql to the Simple MS SQL Python extension module CVS repository, changing 1 files.
2009-06-06 14:40:56 UTC in Simple MS SQL Python extension module
-
akukula committed patchset 175 of module pymssql to the Simple MS SQL Python extension module CVS repository, changing 1 files.
2009-06-06 14:40:56 UTC in Simple MS SQL Python extension module
-
akukula committed patchset 174 of module pymssql to the Simple MS SQL Python extension module CVS repository, changing 1 files.
2009-06-06 14:40:13 UTC in Simple MS SQL Python extension module
