How to install pymssql on Win7 (Python 2.6)?

Question

Python

Faced a problem.

C:\Python26\python.exe C:/Users/AVDudin/PycharmProjects/logP/logP.py
Traceback (most recent call last):
  File "C:/Users/AVDudin/PycharmProjects/logP/logP.py", line 11, in <module>
    engine = create_engine('mssql+pymssql://USER:[email protected]/DB')
  File "C:\Python26\Lib\site-packages\sqlalchemy\engine\__init__.py", line 346, in create_engine
    return strategy.create(*args, **kwargs)
  File "C:\Python26\Lib\site-packages\sqlalchemy\engine\strategies.py", line 74, in create
    dbapi = dialect_cls.dbapi(**dbapi_args)
  File "C:\Python26\Lib\site-packages\sqlalchemy\dialects\mssql\pymssql.py", line 48, in dbapi
    module = __import__('pymssql')
  File "_mssql.pxd", line 10, in init pymssql (pymssql.c:10798)
ImportError: DLL load failed: �� ������� ��������� ���������.

Somewhere on the Internet I read that I need to add import _mssql
After adding, I get this:

C:\Python26\python.exe C:/Users/AVDudin/PycharmProjects/logP/logP.py
Traceback (most recent call last):
  File "C:/Users/AVDudin/PycharmProjects/logP/logP.py", line 8, in <module>
    import _mssql
ImportError: DLL load failed: �� ������� ��������� ���������.

Answer 1

www.lfd.uci.edu/~gohlke/pythonlibs/#pymssql