Installing Python pymssql Module - Revision history

PeterHarding: /* 2019 Problems */

2019-10-20T23:21:23Z

2019 Problems

← Older revision		Revision as of 09:21, 21 October 2019
Line 62:		Line 62:

	<pre>		<pre>

	~~plh@BRANE /usr/bin~~
	$ pip3 --version		$ pip3 --version
	pip 19.2.3 from /usr/lib/python3.8/site-packages/pip (python 3.8)		pip 19.2.3 from /usr/lib/python3.8/site-packages/pip (python 3.8)

	~~plh@BRANE /usr/bin~~
	$ pip3 install pip --upgrade		$ pip3 install pip --upgrade
	Collecting pip		Collecting pip
Line 77:		Line 75:
	Successfully installed pip-19.3.1		Successfully installed pip-19.3.1

	~~plh@BRANE /usr/bin~~
	$ pip3 --version		$ pip3 --version
	pip 19.3.1 from /usr/lib/python3.8/site-packages/pip (python 3.8)		pip 19.3.1 from /usr/lib/python3.8/site-packages/pip (python 3.8)

	~~plh@BRANE /usr/bin~~
	$ pip3 install pymssql		$ pip3 install pymssql
	Collecting pymssql		Collecting pymssql
Line 99:		Line 97:
	ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command output.		ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command output.

	~~plh@BRANE /usr/bin~~
	$ pip3 install Cython		$ pip3 install Cython
	Collecting Cython		Collecting Cython
Line 113:		Line 111:



			$ pip3 install pymssql
			Collecting pymssql
			Using cached https://files.pythonhosted.org/packages/2e/81/99562b93d75f3fc5956fa65decfb35b38a4ee97cf93c1d0d3cb799fffb99/pymssql-2.1.4.tar.gz
			Building wheels for collected packages: pymssql
			Building wheel for pymssql (setup.py) ... done
			Created wheel for pymssql: filename=pymssql-2.1.4-cp38-cp38-cygwin_3_0_7_x86_64.whl size=1188638 sha256=fa29a41bd62ba1b3e8ba464dec9783e6ed44362c651fcab345d5d9e9e03a8ede
			Stored in directory: /home/plh/.cache/pip/wheels/21/35/92/911576b44bbe7c19ff65d0f90a4af9a9571db4af36ffd3ede1
			Successfully built pymssql
			Installing collected packages: pymssql
			Successfully installed pymssql-2.1.4
	</pre>		</pre>

			That worked.

	[[Category:Python]]		[[Category:Python]]

PeterHarding: /* 2019 Problems */

2019-10-20T23:18:46Z

2019 Problems

← Older revision		Revision as of 09:18, 21 October 2019
Line 104:		Line 104:
	Downloading https://files.pythonhosted.org/packages/a5/1f/c7c5450c60a90ce058b47ecf60bb5be2bfe46f952ed1d3b95d1d677588be/Cython-0.29.13.tar.gz (2.1MB)		Downloading https://files.pythonhosted.org/packages/a5/1f/c7c5450c60a90ce058b47ecf60bb5be2bfe46f952ed1d3b95d1d677588be/Cython-0.29.13.tar.gz (2.1MB)
	\|████████████████████████████████\| 2.1MB 2.9MB/s		\|████████████████████████████████\| 2.1MB 2.9MB/s
			Building wheels for collected packages: Cython
			Building wheel for Cython (setup.py) ... done
			Created wheel for Cython: filename=Cython-0.29.13-cp38-cp38-cygwin_3_0_7_x86_64.whl size=5158306 sha256=7c4b2d4827797c543c7a97942ce1ed6bd74916ef207860b9c905ee87cf781553
			Stored in directory: /home/plh/.cache/pip/wheels/5b/1e/17/15dd6d435ec0644967eb8e1493af09ae28cd94184c6f416d02
			Successfully built Cython
			Installing collected packages: Cython
			Successfully installed Cython-0.29.13

PeterHarding at 23:17, 20 October 2019

2019-10-20T23:17:41Z

← Older revision		Revision as of 09:17, 21 October 2019
Line 53:		Line 53:
	https://pypi.python.org/pypi/pymssql/2.1.3#downloads		https://pypi.python.org/pypi/pymssql/2.1.3#downloads

			=2019 Problems=

			Upgraded cygwin to use Python 3.8

			Upgraded pip to 19.3.1

			Attempted an install of pymssql on Windows Server 2019

			<pre>

			plh@BRANE /usr/bin
			$ pip3 --version
			pip 19.2.3 from /usr/lib/python3.8/site-packages/pip (python 3.8)

			plh@BRANE /usr/bin
			$ pip3 install pip --upgrade
			Collecting pip
			Using cached https://files.pythonhosted.org/packages/00/b6/9cfa56b4081ad13874b0c6f96af8ce16cfbc1cb06bedf8e9164ce5551ec1/pip-19.3.1-py2.py3-none-any.whl
			Installing collected packages: pip
			Found existing installation: pip 19.2.3
			Uninstalling pip-19.2.3:
			Successfully uninstalled pip-19.2.3
			Successfully installed pip-19.3.1

			plh@BRANE /usr/bin
			$ pip3 --version
			pip 19.3.1 from /usr/lib/python3.8/site-packages/pip (python 3.8)

			plh@BRANE /usr/bin
			$ pip3 install pymssql
			Collecting pymssql
			Using cached https://files.pythonhosted.org/packages/2e/81/99562b93d75f3fc5956fa65decfb35b38a4ee97cf93c1d0d3cb799fffb99/pymssql-2.1.4.tar.gz
			ERROR: Command errored out with exit status 1:
			command: /usr/bin/python3.8.exe -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'/tmp/pip-install-oq72usqd/pymssql/setup.py'"'"'; __file__='"'"'/tmp/pip-install-oq72usqd/pymssql/setup.py'"'"';f=getattr(tokenize, '"'"'open'"'"', open)(__file__);code=f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' egg_info --egg-base /tmp/pip-install-oq72usqd/pymssql/pip-egg-info
			cwd: /tmp/pip-install-oq72usqd/pymssql/
			Complete output (7 lines):
			/usr/lib/python3.8/site-packages/setuptools/dist.py:45: DistDeprecationWarning: Do not call this function
			warnings.warn("Do not call this function", DistDeprecationWarning)
			Traceback (most recent call last):
			File "<string>", line 1, in <module>
			File "/tmp/pip-install-oq72usqd/pymssql/setup.py", line 88, in <module>
			from Cython.Distutils import build_ext as _build_ext
			ModuleNotFoundError: No module named 'Cython'
			----------------------------------------
			ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command output.

			plh@BRANE /usr/bin
			$ pip3 install Cython
			Collecting Cython
			Downloading https://files.pythonhosted.org/packages/a5/1f/c7c5450c60a90ce058b47ecf60bb5be2bfe46f952ed1d3b95d1d677588be/Cython-0.29.13.tar.gz (2.1MB)
			\|████████████████████████████████\| 2.1MB 2.9MB/s


			</pre>


	[[Category:Python]]		[[Category:Python]]

PeterHarding at 09:18, 7 November 2016

2016-11-07T09:18:37Z

← Older revision		Revision as of 19:18, 7 November 2016
Line 38:		Line 38:
	"Tried to install pymssql into cygwin python install using pip. There isn't currently any cygwin specific install instructions at http://pymssql.org but with a quick read it was obvious that pymssql has a dependency on FreeTDS that could be satisfied by installing FreeTDS package from the cygwin setup utility, however cygwin doesn't currently have any "freetds-dev" or "freetds-devel" package and it took quite a bit of head scratching to figure out the header files required by the pip build could be found in the the cygwin "libsybdb-devel" package"		"Tried to install pymssql into cygwin python install using pip. There isn't currently any cygwin specific install instructions at http://pymssql.org but with a quick read it was obvious that pymssql has a dependency on FreeTDS that could be satisfied by installing FreeTDS package from the cygwin setup utility, however cygwin doesn't currently have any "freetds-dev" or "freetds-devel" package and it took quite a bit of head scratching to figure out the header files required by the pip build could be found in the the cygwin "libsybdb-devel" package"

			After installing the cygwin "freetds" and "libsybdb-devel" packages I ran the pip install again and it worked!

			<pre>
			$ pip install pymssql
			Collecting pymssql
			Using cached pymssql-2.1.3.tar.gz
			Installing collected packages: pymssql
			Running setup.py install for pymssql ... done
			Successfully installed pymssql-2.1.3
			</pre>

	==Also==		==Also==

PeterHarding: /* Problems */

2016-11-07T09:11:18Z

Problems

@@ Line 31: / Line 31: @@
 >>>
 </pre>
 [[Category:Python]]

PeterHarding: Created page with "=Problems= ==Cygwin== Looked like it installed OK.

 $ pip install pymssql Collecting pymssql   Downloading pymssql-2.1.2.tar.gz (898kB)     100% |███████..."

2016-02-23T07:24:21Z

Created page with "=Problems= ==Cygwin== Looked like it installed OK. <pre> $ pip install pymssql Collecting pymssql Downloading pymssql-2.1.2.tar.gz (898kB) 100% |███████..."

New page

=Problems=

==Cygwin==

Looked like it installed OK.

<pre>
$ pip install pymssql
Collecting pymssql
Downloading pymssql-2.1.2.tar.gz (898kB)
100% |████████████████████████████████| 901kB 134kB/s
Building wheels for collected packages: pymssql
Running setup.py bdist_wheel for pymssql ... done
Stored in directory: /home/aasdev/.cache/pip/wheels/08/df/03/0c92949cb5ecc9002cb965d135f1dec326cb7881f3e0bb80be
Successfully built pymssql
Installing collected packages: pymssql
Successfully installed pymssql-2.1.2
</pre>

==Windows==

When I attempt to run a windows script which imports pymssql it fails:

<pre>
Python 2.7.11 (v2.7.11:6d1b6a68f775, Dec 5 2015, 20:40:30) [MSC v.1500 64 bit (AMD64)] on win32
Type "help", "copyright", "credits" or "license" for more information.
>>> import pymssql
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
ImportError: DLL load failed: The specified module could not be found.
>>>
</pre>

[[Category:Python]]