安装pymssql报错
网上找了一推方法总结如下：
-
关闭后台
jupyter notebook
- 根据提示安装
python -m pip install --upgrade pip3.重新安装依旧报错
pip install pymssql4.换了一个清华源，完成安装
C:\WINDOWS\system32>pip install pymssql
Collecting pymssql
WARNING: Retrying (Retry(total=4, connect=None, read=None, redirect=None, status=None)) after connection broken by 'ReadTimeoutError("HTTPSConnectionPool(host='files.pythonhosted.org', port=443): Read timed out. (read timeout=15)",)': /packages/e8/fa/6b35afa4b921434074cda783e0c40538f77fe6dadd5f441eeb2e81e38496/pymssql-2.1.5-cp36-cp36m-win_amd64.whl
Downloading https://files.pythonhosted.org/packages/e8/fa/6b35afa4b921434074cda783e0c40538f77fe6dadd5f441eeb2e81e38496/pymssql-2.1.5-cp36-cp36m-win_amd64.whl (411kB)
|███████████████ | 194kB 1.9kB/s eta 0:01:54ERROR: Exception:
Traceback (most recent call last):
File "d:\anaconda3.5.2\lib\site-packages\pip\_vendor\urllib3\response.py", line 425, in _error_catcher
yield
File "d:\anaconda3.5.2\lib\site-packages\pip\_vendor\urllib3\response.py", line 507, in read
data = self._fp.read(amt) if not fp_closed else b""
File "d:\anaconda3.5.2\lib\site-packages\pip\_vendor\cachecontrol\filewrapper.py", line 62, in read
data = self.__fp.read(amt)
File "d:\anaconda3.5.2\lib\http\client.py", line 449, in read
n = self.readinto(b)
File "d:\anaconda3.5.2\lib\http\client.py", line 493, in readinto
n = self.fp.readinto(b)
File "d:\anaconda3.5.2\lib\socket.py", line 586, in readinto
return self._sock.recv_into(b)
File "d:\anaconda3.5.2\lib\ssl.py", line 1009, in recv_into
return self.read(nbytes, buffer)
File "d:\anaconda3.5.2\lib\ssl.py", line 871, in read
return self._sslobj.read(len, buffer)
File "d:\anaconda3.5.2\lib\ssl.py", line 631, in read
v = self._sslobj.read(len, buffer)
socket.timeout: The read operation timed out
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "d:\anaconda3.5.2\lib\site-packages\pip\_internal\cli\base_command.py", line 153, in _main
status = self.run(options, args)
File "d:\anaconda3.5.2\lib\site-packages\pip\_internal\commands\install.py", line 382, in run
resolver.resolve(requirement_set)
File "d:\anaconda3.5.2\lib\site-packages\pip\_internal\legacy_resolve.py", line 201, in resolve
self._resolve_one(requirement_set, req)
File "d:\anaconda3.5.2\lib\site-packages\pip\_internal\legacy_resolve.py", line 365, in _resolve_one
abstract_dist = self._get_abstract_dist_for(req_to_install)
File "d:\anaconda3.5.2\lib\site-packages\pip\_internal\legacy_resolve.py", line 313, in _get_abstract_dist_for
req, self.session, self.finder, self.require_hashes
File "d:\anaconda3.5.2\lib\site-packages\pip\_internal\operations\prepare.py", line 194, in prepare_linked_requirement
progress_bar=self.progress_bar
File "d:\anaconda3.5.2\lib\site-packages\pip\_internal\download.py", line 465, in unpack_url
progress_bar=progress_bar
File "d:\anaconda3.5.2\lib\site-packages\pip\_internal\download.py", line 316, in unpack_http_url
progress_bar)
File "d:\anaconda3.5.2\lib\site-packages\pip\_internal\download.py", line 551, in _download_http_url
_download_url(resp, link, content_file, hashes, progress_bar)
File "d:\anaconda3.5.2\lib\site-packages\pip\_internal\download.py", line 253, in _download_url
hashes.check_against_chunks(downloaded_chunks)
File "d:\anaconda3.5.2\lib\site-packages\pip\_internal\utils\hashes.py", line 80, in check_against_chunks
for chunk in chunks:
File "d:\anaconda3.5.2\lib\site-packages\pip\_internal\download.py", line 223, in written_chunks
for chunk in chunks:
File "d:\anaconda3.5.2\lib\site-packages\pip\_internal\utils\ui.py", line 160, in iter
for x in it:
File "d:\anaconda3.5.2\lib\site-packages\pip\_internal\download.py", line 212, in resp_read
decode_content=False):
File "d:\anaconda3.5.2\lib\site-packages\pip\_vendor\urllib3\response.py", line 564, in stream
data = self.read(amt=amt, decode_content=decode_content)
File "d:\anaconda3.5.2\lib\site-packages\pip\_vendor\urllib3\response.py", line 529, in read
raise IncompleteRead(self._fp_bytes_read, self.length_remaining)
File "d:\anaconda3.5.2\lib\contextlib.py", line 99, in __exit__
self.gen.throw(type, value, traceback)
File "d:\anaconda3.5.2\lib\site-packages\pip\_vendor\urllib3\response.py", line 430, in _error_catcher
raise ReadTimeoutError(self._pool, None, "Read timed out.")
pip._vendor.urllib3.exceptions.ReadTimeoutError: HTTPSConnectionPool(host='files.pythonhosted.org', port=443): Read timed out.
WARNING: You are using pip version 19.3.1; however, version 20.2.4 is available.
You should consider upgrading via the 'python -m pip install --upgrade pip' command.
C:\WINDOWS\system32>python -m pip install --upgrade pip
Collecting pip
Downloading https://files.pythonhosted.org/packages/cb/28/91f26bd088ce8e22169032100d4260614fc3da435025ff389ef1d396a433/pip-20.2.4-py2.py3-none-any.whl (1.5MB)
|███████▌ | 358kB 4.0kB/s eta 0:04:45ERROR: Exception:
Traceback (most recent call last):
File "D:\Anaconda3.5.2\lib\site-packages\pip\_vendor\urllib3\response.py", line 425, in _error_catcher
yield
File "D:\Anaconda3.5.2\lib\site-packages\pip\_vendor\urllib3\response.py", line 507, in read
data = self._fp.read(amt) if not fp_closed else b""
File "D:\Anaconda3.5.2\lib\site-packages\pip\_vendor\cachecontrol\filewrapper.py", line 62, in read
data = self.__fp.read(amt)
File "D:\Anaconda3.5.2\lib\http\client.py", line 449, in read
n = self.readinto(b)
File "D:\Anaconda3.5.2\lib\http\client.py", line 493, in readinto
n = self.fp.readinto(b)
File "D:\Anaconda3.5.2\lib\socket.py", line 586, in readinto
return self._sock.recv_into(b)
File "D:\Anaconda3.5.2\lib\ssl.py", line 1009, in recv_into
return self.read(nbytes, buffer)
File "D:\Anaconda3.5.2\lib\ssl.py", line 871, in read
return self._sslobj.read(len, buffer)
File "D:\Anaconda3.5.2\lib\ssl.py", line 631, in read
v = self._sslobj.read(len, buffer)
socket.timeout: The read operation timed out
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "D:\Anaconda3.5.2\lib\site-packages\pip\_internal\cli\base_command.py", line 153, in _main
status = self.run(options, args)
File "D:\Anaconda3.5.2\lib\site-packages\pip\_internal\commands\install.py", line 382, in run
resolver.resolve(requirement_set)
File "D:\Anaconda3.5.2\lib\site-packages\pip\_internal\legacy_resolve.py", line 201, in resolve
self._resolve_one(requirement_set, req)
File "D:\Anaconda3.5.2\lib\site-packages\pip\_internal\legacy_resolve.py", line 365, in _resolve_one
abstract_dist = self._get_abstract_dist_for(req_to_install)
File "D:\Anaconda3.5.2\lib\site-packages\pip\_internal\legacy_resolve.py", line 313, in _get_abstract_dist_for
req, self.session, self.finder, self.require_hashes
File "D:\Anaconda3.5.2\lib\site-packages\pip\_internal\operations\prepare.py", line 194, in prepare_linked_requirement
progress_bar=self.progress_bar
File "D:\Anaconda3.5.2\lib\site-packages\pip\_internal\download.py", line 465, in unpack_url
progress_bar=progress_bar
File "D:\Anaconda3.5.2\lib\site-packages\pip\_internal\download.py", line 316, in unpack_http_url
progress_bar)
File "D:\Anaconda3.5.2\lib\site-packages\pip\_internal\download.py", line 551, in _download_http_url
_download_url(resp, link, content_file, hashes, progress_bar)
File "D:\Anaconda3.5.2\lib\site-packages\pip\_internal\download.py", line 253, in _download_url
hashes.check_against_chunks(downloaded_chunks)
File "D:\Anaconda3.5.2\lib\site-packages\pip\_internal\utils\hashes.py", line 80, in check_against_chunks
for chunk in chunks:
File "D:\Anaconda3.5.2\lib\site-packages\pip\_internal\download.py", line 223, in written_chunks
for chunk in chunks:
File "D:\Anaconda3.5.2\lib\site-packages\pip\_internal\utils\ui.py", line 160, in iter
for x in it:
File "D:\Anaconda3.5.2\lib\site-packages\pip\_internal\download.py", line 212, in resp_read
decode_content=False):
File "D:\Anaconda3.5.2\lib\site-packages\pip\_vendor\urllib3\response.py", line 564, in stream
data = self.read(amt=amt, decode_content=decode_content)
File "D:\Anaconda3.5.2\lib\site-packages\pip\_vendor\urllib3\response.py", line 529, in read
raise IncompleteRead(self._fp_bytes_read, self.length_remaining)
File "D:\Anaconda3.5.2\lib\contextlib.py", line 99, in __exit__
self.gen.throw(type, value, traceback)
File "D:\Anaconda3.5.2\lib\site-packages\pip\_vendor\urllib3\response.py", line 430, in _error_catcher
raise ReadTimeoutError(self._pool, None, "Read timed out.")
pip._vendor.urllib3.exceptions.ReadTimeoutError: HTTPSConnectionPool(host='files.pythonhosted.org', port=443): Read timed out.
C:\WINDOWS\system32>python -m pip install --upgrade pip
Collecting pip
Downloading https://files.pythonhosted.org/packages/cb/28/91f26bd088ce8e22169032100d4260614fc3da435025ff389ef1d396a433/pip-20.2.4-py2.py3-none-any.whl (1.5MB)
|███████████▌ | 542kB 14kB/s eta 0:01:08ERROR: Exception:
Traceback (most recent call last):
File "D:\Anaconda3.5.2\lib\site-packages\pip\_vendor\urllib3\response.py", line 425, in _error_catcher
yield
File "D:\Anaconda3.5.2\lib\site-packages\pip\_vendor\urllib3\response.py", line 507, in read
data = self._fp.read(amt) if not fp_closed else b""
File "D:\Anaconda3.5.2\lib\site-packages\pip\_vendor\cachecontrol\filewrapper.py", line 62, in read
data = self.__fp.read(amt)
File "D:\Anaconda3.5.2\lib\http\client.py", line 449, in read
n = self.readinto(b)
File "D:\Anaconda3.5.2\lib\http\client.py", line 493, in readinto
n = self.fp.readinto(b)
File "D:\Anaconda3.5.2\lib\socket.py", line 586, in readinto
return self._sock.recv_into(b)
File "D:\Anaconda3.5.2\lib\ssl.py", line 1009, in recv_into
return self.read(nbytes, buffer)
File "D:\Anaconda3.5.2\lib\ssl.py", line 871, in read
return self._sslobj.read(len, buffer)
File "D:\Anaconda3.5.2\lib\ssl.py", line 631, in read
v = self._sslobj.read(len, buffer)
socket.timeout: The read operation timed out
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "D:\Anaconda3.5.2\lib\site-packages\pip\_internal\cli\base_command.py", line 153, in _main
status = self.run(options, args)
File "D:\Anaconda3.5.2\lib\site-packages\pip\_internal\commands\install.py", line 382, in run
resolver.resolve(requirement_set)
File "D:\Anaconda3.5.2\lib\site-packages\pip\_internal\legacy_resolve.py", line 201, in resolve
self._resolve_one(requirement_set, req)
File "D:\Anaconda3.5.2\lib\site-packages\pip\_internal\legacy_resolve.py", line 365, in _resolve_one
abstract_dist = self._get_abstract_dist_for(req_to_install)
File "D:\Anaconda3.5.2\lib\site-packages\pip\_internal\legacy_resolve.py", line 313, in _get_abstract_dist_for
req, self.session, self.finder, self.require_hashes
File "D:\Anaconda3.5.2\lib\site-packages\pip\_internal\operations\prepare.py", line 194, in prepare_linked_requirement
progress_bar=self.progress_bar
File "D:\Anaconda3.5.2\lib\site-packages\pip\_internal\download.py", line 465, in unpack_url
progress_bar=progress_bar
File "D:\Anaconda3.5.2\lib\site-packages\pip\_internal\download.py", line 316, in unpack_http_url
progress_bar)
File "D:\Anaconda3.5.2\lib\site-packages\pip\_internal\download.py", line 551, in _download_http_url
_download_url(resp, link, content_file, hashes, progress_bar)
File "D:\Anaconda3.5.2\lib\site-packages\pip\_internal\download.py", line 253, in _download_url
hashes.check_against_chunks(downloaded_chunks)
File "D:\Anaconda3.5.2\lib\site-packages\pip\_internal\utils\hashes.py", line 80, in check_against_chunks
for chunk in chunks:
File "D:\Anaconda3.5.2\lib\site-packages\pip\_internal\download.py", line 223, in written_chunks
for chunk in chunks:
File "D:\Anaconda3.5.2\lib\site-packages\pip\_internal\utils\ui.py", line 160, in iter
for x in it:
File "D:\Anaconda3.5.2\lib\site-packages\pip\_internal\download.py", line 212, in resp_read
decode_content=False):
File "D:\Anaconda3.5.2\lib\site-packages\pip\_vendor\urllib3\response.py", line 564, in stream
data = self.read(amt=amt, decode_content=decode_content)
File "D:\Anaconda3.5.2\lib\site-packages\pip\_vendor\urllib3\response.py", line 529, in read
raise IncompleteRead(self._fp_bytes_read, self.length_remaining)
File "D:\Anaconda3.5.2\lib\contextlib.py", line 99, in __exit__
self.gen.throw(type, value, traceback)
File "D:\Anaconda3.5.2\lib\site-packages\pip\_vendor\urllib3\response.py", line 430, in _error_catcher
raise ReadTimeoutError(self._pool, None, "Read timed out.")
pip._vendor.urllib3.exceptions.ReadTimeoutError: HTTPSConnectionPool(host='files.pythonhosted.org', port=443): Read timed out.
WARNING: You are using pip version 19.3.1; however, version 20.2.4 is available.
You should consider upgrading via the 'python -m pip install --upgrade pip' command.
微信公众号：数据分析日记
版权声明：本文为qq_41387939原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。