SQL PowerSHell Modules - Githubissues

Garthjag commented 1 year ago

Type: Bug

Install VS Code 1.77.0 (user Setup)
Using Posh ISE install SQL Module Install-Module -Name SQLServer -Scope AllUsers
Launch VC Code as Admin
Execute any Invoke-sqlcmd
Notice Error. e.g. The term 'Invoke-Sqlcmd' is not recognized as a name of a cmdlet
Now execute the same script in Posh ISE.
Notice that it runs without issues.

VS Code version: Code 1.77.0 (7f329fe6c66b0f86ae1574c2911b681ad5a45d63, 2023-03-29T10:02:16.981Z) OS version: Windows_NT x64 10.0.17763 Modes: Sandboxed: Yes

System Info

|Item|Value| |---|---| |CPUs|AMD EPYC 7402P 24-Core Processor (2 x 2795)| |GPU Status|2d_canvas: unavailable_software
canvas_oop_rasterization: disabled_off
direct_rendering_display_compositor: disabled_off_ok
gpu_compositing: disabled_software
multiple_raster_threads: disabled_off
opengl: disabled_off
rasterization: disabled_software
raw_draw: disabled_off_ok
skia_renderer: enabled_on
video_decode: disabled_software
video_encode: disabled_software
vulkan: disabled_off
webgl: unavailable_software
webgl2: unavailable_software
webgpu: disabled_off| |Load (avg)|undefined| |Memory (System)|9.01GB (2.34GB free)| |Process Argv|--crash-reporter-id 55fce088-8165-41d5-bb07-22e8ad07bdda| |Screen Reader|no| |VM|0%|

Extensions (5)

Extension|Author (truncated)|Version ---|---|--- data-workspace-vscode|ms-|0.4.0 mssql|ms-|1.18.0 sql-bindings-vscode|ms-|0.3.0 sql-database-projects-vscode|ms-|0.21.0 powershell|ms-|2023.3.3

A/B Experiments

``` vsliv368:30146709 vsreu685:30147344 python383:30185418 vspor879:30202332 vspor708:30202333 vspor363:30204092 vslsvsres303:30308271 vserr242:30382549 pythontb:30283811 vsjup518:30340749 pythonptprofiler:30281270 vshan820:30294714 vstes263:30335439 pythondataviewer:30285071 vscod805:30301674 binariesv615:30325510 bridge0708:30335490 bridge0723:30353136 cmake_vspar411:30581797 vsaa593cf:30376535 pythonvs932:30410667 cppdebug:30492333 vsclangdc:30486549 c4g48928:30535728 dsvsc012:30540252 pynewext54:30695312 azure-dev_surveyone:30548225 nodejswelcome1cf:30587006 3biah626:30602489 pyind779:30671433 89544117:30613380 pythonsymbol12:30671437 a9j8j154:30646983 vsctsb:30677850 pythonb192cf:30669361 defaultazurewalk:30687958 pythonms35:30701012 ```

Garthjag commented 1 year ago

I have determined that between VS code and Posh ISE that $env:PSModulePath is different for no apparent reason. In particular VS code is missing the C:\Program Files\WindowsPowerShell\Modules\ path. Why IDK. IMO it should not have different Paths, or at least it should be the same as Posh ISE with maybe a few more extra paths.

Garthjag commented 1 year ago

BTW I also determine that is does NOT matter if you use System install or user install, they BOTH have the same issue.

vscodenpa commented 1 year ago

This issue is caused by an extension, please file it with the repository (or contact) the extension has linked in its overview in VS Code or the marketplace for VS Code. See also our issue reporting guidelines. If you don't know which extension is causing the problem, you can run Help: Start extension bisect from the command palette (F1) to help identify the problem extension.

Happy Coding!

microsoft / vscode

SQL PowerSHell Modules #179135