Export to GitHub

pymssql - issue #12

Python 2.7 support


Posted on Jul 14, 2010 by Massive Wombat

Since 2.7 now appears to be Python's "official" version I'm really hoping you guys can get out a version for it soon.

Comment #1

Posted on Sep 21, 2010 by Swift Cat

Do you mean Windows binaries?

Comment #2

Posted on Sep 21, 2010 by Massive Wombat

Yes

Comment #3

Posted on Oct 29, 2010 by Massive Kangaroo

Comment deleted

Comment #4

Posted on Nov 2, 2010 by Grumpy Ox

I've build 2.7 binaries (haven't tested yet), will attach.

Attachments

Comment #5

Posted on Nov 25, 2010 by Swift Giraffe

hi guys, is this stable? anybody tested it?

Comment #6

Posted on Jan 12, 2011 by Happy Panda

people, how do i install pymssql on windows with python 2.7?

Comment #7

Posted on Jan 14, 2011 by Helpful Bear

Hello guys, i need pymssql for python 2.7 too!! i'll try tested your binaries

Comment #8

Posted on Feb 10, 2011 by Helpful Bear

Binaries seem to work, thanks! Is there any chance to 'officially' roll this out?

Comment #9

Posted on Feb 15, 2011 by Happy Dog

Binaries don't work for me. I get an error on loading the dll included. I'm running ActivePython 2.7 x64, wondering if you just compiled the x32?

Comment #10

Posted on Feb 19, 2011 by Helpful Wombat

How do I install this?

Comment #11

Posted on Mar 27, 2011 by Grumpy Hippo

I have been building snapshots here, http://build.damoxc.net/downloads/pymssql/snapshots/ however I can't comment on their stability and also if memory serves I'm fairly sure you need to pass an environment variable specifying where the freetds.conf file is. I need to work out how to avoid requiring that file ideally.

Comment #12

Posted on Jul 29, 2011 by Quick Giraffe

isn't it about time for a official 2.7 release? The snapshots in the last post do not work.

Comment #13

Posted on Jul 30, 2011 by Grumpy Panda

Tony,

Yes, but there is only so much time in the day and there are still a few bugs to be ironed out. The current HG tip works on 2.7, you are welcome to build it.

Comment #14

Posted on Aug 28, 2011 by Happy Hippo

I need a working windows version for python 2.7. Don't know exactly how to build, but i can spend time to learn and do it. If someone could explain me, i could build for all python 2.x version and test them.

thanks.

Comment #15

Posted on Sep 9, 2011 by Grumpy Camel

requiring a version of python before it can install seems silly. most everything i have seen in python 2.x series has been backward compatible. am i wrong? the installation seems to be checking for 2.6 in the registry. sqlalchemy, here i come! pymssql was great when i used it before. i guess momentum for this project has halted ?

Comment #16

Posted on Sep 19, 2011 by Grumpy Panda

SQLAlchemy and pymssql are not the same thing. You need a SQL Server "driver" for SQLAlchemy. The only two I know of that exist is pymssql and pyodbc. Momentum is definitely slow, but not halted.

Comment #17

Posted on Oct 4, 2011 by Helpful Rhino

The HG tip works in 2.7 but it does result in a few warnings...

cythoning _mssql.pyx to _mssql.c warning: _mssql.pyx:1198:51: local variable 'data' referenced before assignment warning: _mssql.pyx:170:11: Unreachable code building '_mssql' extension

cythoning pymssql.pyx to pymssql.c warning: pymssql.pyx:410:8: Unreachable code building 'pymssql' extension

Comment #18

Posted on Oct 5, 2011 by Grumpy Camel

if this is not the place for this , tell me where to give feedback please: tried 2 methods to install:

C:\Python\27\Scripts>easy_install.exe pymssql Searching for pymssql Reading http://pypi.python.org/simple/pymssql/ Reading http://code.google.com/p/pymssql/ Reading http://code.google.com/p/pymssql/downloads/list Reading http://pymssql.sourceforge.net Reading http://sourceforge.net/project/showfiles.php?group_id=40059&package_id=32202 Best match: pymssql 1.9.908.win32 Downloading http://pymssql.googlecode.com/files/pymssql-1.9.908.win32.zip Processing pymssql-1.9.908.win32.zip error: Couldn't find a setup script in c:\docume~1\djacks~1\locals~1\temp\easy_install-gba42y\pymssql-1.9.908.win32.zip

2nd method cythoning _mssql.pyx to _mssql.c building '_mssql' extension C:\Program Files\Microsoft Visual Studio 9.0\VC\BIN\cl.exe /c /nologo /Ox /MD /W3 /GS- /DNDEBUG -Iwin32\freetds\include -Ic:\Python\27\include -Ic:\Python\27\PC /Tc_mssql.c /Fobuild\temp.win32-2.7\Release_mssql.obj -DMSDBLIB _mssql.c _mssql.c(1) : fatal error C1189: #error : Do not use this file, it is the result of a failed Cython compilation.

how to resolve the failed Cython compilation?

Comment #19

Posted on Oct 6, 2011 by Grumpy Panda

If you want a working version, you are going to have to use HG tip. easy_install is not currently going to work.

Comment #20

Posted on Oct 7, 2011 by Grumpy Camel

pyodbc ended up being a good solution - no clue if there was any tradeoff to performance or something else.

what is HG tip? google makes me think it is a development term.

Comment #21

Posted on Nov 3, 2011 by Happy Monkey

Anyone could explain what HG tip is? I'm really confused about this term. Installing pymssql with python 2.7 failed with following error message:

cl:Command line error D8021: invalid numeric argument '-Wl,-allow-multiple-definition' I'm using Visual C++ 2008 Express Edition

Comment #22

Posted on Nov 3, 2011 by Massive Elephant

"hg tip" is Mercurial version control speak

Comment #23

Posted on Mar 8, 2012 by Grumpy Panda

latest HG tip will support 2.7 I believe, although we don't have binaries for it yet, that issues is tracked elsewhere.

Comment #24

Posted on Jun 15, 2012 by Helpful Panda

Does the python 2.7 windows installer at the bottom of this page work?

http://code.google.com/p/pymssql/issues/detail?id=54

Status: Duplicate

Labels:
Type-Defect Priority-Medium