Problem z instalacją pymssql

0

Witam, mam problem z instalacją pymssql, próbowałem przez pip install oto efekt:

C:\Users\j.mrozewski>pip install pymssql
Collecting pymssql
  Using cached pymssql-2.1.3.tar.gz
Building wheels for collected packages: pymssql
  Running setup.py bdist_wheel for pymssql ... error
  Complete output from command c:\python\python.exe -u -c "import setuptools, tokenize;__file__='C:\\Users\\J900C~1.MRO\\AppData\\Local\\Temp\\pip-build-3fyfxuft\\pymssql\\setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" bdist_wheel -d C:\Users\J900C~1.MRO\AppData\Local\Temp\tmpkmgsr7hvpip-wheel- --python-tag
 cp36:
  setup.py: platform.system() => 'Windows'
  setup.py: platform.architecture() => ('64bit', 'WindowsPE')
  running bdist_wheel
  running build
  running build_ext
  building '_mssql' extension
  creating build
  creating build\temp.win-amd64-3.6
  creating build\temp.win-amd64-3.6\Release
  cl.exe /c /nologo /Ox /W3 /GL /DNDEBUG /MT -IC:\Users\J900C~1.MRO\AppData\Local\Temp\pip-build-3fyfxuft\pymssql\freetds\vs2015_64\include -Ic:\python\include-Ic:\python\include "-IC:\Program Files (x86)\Windows Kits\10\include\10.0.10240.0\ucrt" /Tc_mssql.c /Fobuild\temp.win-amd64-3.6\Release\_mssql.obj -DMSDBLIB
  error: command 'cl.exe' failed: No such file or directory

  ----------------------------------------
  Failed building wheel for pymssql
  Running setup.py clean for pymssql
Failed to build pymssql
Installing collected packages: pymssql
  Running setup.py install for pymssql ... error
    Complete output from command c:\python\python.exe -u -c "import setuptools,tokenize;__file__='C:\\Users\\J900C~1.MRO\\AppData\\Local\\Temp\\pip-build-3fyfxuft\\pymssql\\setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" install --record C:\Users\J900C~1.MRO\AppData\Local\Temp\pip-inpeojql-record\install-record.txt --single-version-externally-managed --compile:
    setup.py: platform.system() => 'Windows'
    setup.py: platform.architecture() => ('64bit', 'WindowsPE')
    running install
    running build
    running build_ext
    cythoning _mssql.pyx to _mssql.c
    warning: _mssql.pyx:143:4: Exception already a builtin Cython type
    building '_mssql' extension
    creating build
    creating build\temp.win-amd64-3.6
    creating build\temp.win-amd64-3.6\Release
    cl.exe /c /nologo /Ox /W3 /GL /DNDEBUG /MT -IC:\Users\J900C~1.MRO\AppData\Local\Temp\pip-build-3fyfxuft\pymssql\freetds\vs2015_64\include -Ic:\python\include -Ic:\python\include "-IC:\Program Files (x86)\Windows Kits\10\include\10.0.10240.0\ucrt" /Tc_mssql.c /Fobuild\temp.win-amd64-3.6\Release\_mssql.obj -DMSDBLIB    error: command 'cl.exe' failed: No such file or directory
    ----------------------------------------
Command "c:\python\python.exe -u -c "import setuptools, tokenize;__file__='C:\\Users\\J900C~1.MRO\\AppData\\Local\\Temp\\pip-build-3fyfxuft\\pymssql\\setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" install --record C:\Users\J900C~1.MRO\AppData\Local\Temp\pip-inpeojql-record\install-record.txt --single-version-externally-managed --compile" failed with error code 1 in C:\Users\J900C~1.MRO\AppData\Local\Temp\pip-build-3fyfxuft\pymssql\

pobrałem też wheel ale dostaje komunikat że pakiet.whl is not supported wheel on this platform, a pobieram pymssql-2.2.0.dev0-cp27-cp27m-win_amd64.whl lub nowsze
czy ktoś mógły mnie naprowadzić co robię nie tak?

1

https://docs.microsoft.com/en-us/sql/connect/python/python-driver-for-sql-server
Zawsze możesz spróbować z pyodbc

pip install pymssql

MS podaje nieco inną składnię - https://docs.microsoft.com/en-us/sql/connect/python/pymssql/step-1-configure-development-environment-for-pymssql-python-development

pobieram pymssql-2.2.0.dev0-cp27-cp27m-win_amd64.whl lub nowsze
czy ktoś mógły mnie naprowadzić co robię nie tak?

Pobiera się zgodnie z wersją Pythona i systemu. A nie "lub nowsze".

1 użytkowników online, w tym zalogowanych: 0, gości: 1