search

microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
https://learn.microsoft.com/sql/azure-data-studio
MIT License
7.58k stars 906 forks source link

Notebook doesn't support dependencies with higher versions #25891

Open jerrysoft-x opened 2 months ago

jerrysoft-x commented 2 months ago

Type: Bug

When creating a notebook in Azure Data Studio, and switch to Python kernel. It prompts to install dependencies jupyter, notebook, and ipykernel. However, I already have installed these dependencies with higher versions. The tool has no other option but still go to installing them, and ended up with an error

AttributeError: module 'setuptools.msvc' has no attribute 'msvc14_get_vc_env'

image

Azure Data Studio version: azuredatastudio 1.49.1 (2f696aa95a13ccabd7e0a4431d1d759e3a7b8cfd, 2024-08-13T18:12:38.831Z) OS version: Windows_NT x64 10.0.19045 Restricted Mode: No Preview Features: Enabled Modes:

System Info |Item|Value| |---|---| |CPUs|12th Gen Intel(R) Core(TM) i5-1245U (12 x 2496)| |GPU Status|2d_canvas: enabled
canvas_oop_rasterization: enabled_on
direct_rendering_display_compositor: disabled_off_ok
gpu_compositing: enabled
multiple_raster_threads: enabled_on
opengl: enabled_on
rasterization: enabled
raw_draw: disabled_off_ok
video_decode: enabled
video_encode: enabled
vulkan: disabled_off
webgl: enabled
webgl2: enabled
webgpu: enabled| |Load (avg)|undefined| |Memory (System)|31.69GB (9.04GB free)| |Process Argv|| |Screen Reader|no| |VM|0%|
Extensions (1) Extension|Author (truncated)|Version ---|---|--- copilot|Git|1.199.0
torero619 commented 1 month ago

I had this error code and this is how I solved it. Based on some info from this link explaining how to install Python in an offline environment

Step 0? I previously uninstalled all my previous versions of Python

Step 1: Go to the link and click on the a hyperlink titled "Azure Data Studio Python package" which will prompt you to download a zip file

Step 2: Unzip the zip file and place all internal contents into a new directory. I placed mine in C:\Users\MyUserName\AppData\Local\azuredatastudio-python

Step 3: Go back to Azure Data Studio and click the dropdown to switch to the Python Kernel again. When it prompts you to Browse for the directory, point to the directory created previously. (This is where the python.exe file lives)

This solution allowed the ADS manager to complete the rest of the pip installations. Best of luck!