Julia seems to crash in VS Code when accessing a SQL Server DB dia ODBC 64Bit -- Same code DOES NOT crash from CMD window

[GuillermoDIrisarri]

The following minimal code fails in Visual Studio Code (see below). The same (or the real version of the code) runs perfectly well from a regular Windows CMD window. It fails when executing DBInterface.prepare. SEEMDB64 is 64-bit ODBC data source. Running with Windows 11, Julia 1.11.1, latest ODBC package.

#=====================================================================================#
#
# BidMatching using Julia implementation
#
#=====================================================================================#

using JuMP
using Clp
using Cbc
using SCIP
using HiGHS
#using GLPK
#using Gurobi
#using CPLEX
using StatsBase
using ArgParse
using ODBC
using DataFrames
#using DataArrays
using PyPlot
using Printf
import Test
import Dates
println("Loaded Packages")

dsn = ODBC.Connection("SEEMDB64")

#----------------------------------------
# Delete old data from log for the case
#----------------------------------------
dbOutputP = true
sqlQuery = @sprintf("DELETE FROM BidMatchingExecutionLog WHERE CaseId = 600008")
if dbOutputP
	dbStmt = DBInterface.prepare(dsn, sqlQuery)
	df = DBInterface.execute(dbStmt)
else
	println("QUERY: ",  sqlQuery)
end


===================================== Error Reports ==========================================

Activating project at `C:\Users\GDI\.julia\environments\v1.11`
Loaded Packages

Please submit a bug report with steps to reproduce this fault, and any error messages that follow (in their entirety). Thanks.
Exception: EXCEPTION_ACCESS_VIOLATION at 0x55dac234 -- unknown function (ip: 0000000055dac234)
in expression starting at c:\Users\GDI\.vscode\extensions\julialang.language-julia-1.127.2\scripts\debugger\run_debugger.jl:12
unknown function (ip: 0000000055dac234)
unknown function (ip: 00007fff1349a230)
unknown function (ip: 00007fff1356b57c)
SQLPrepare at C:\WINDOWS\SYSTEM32\odbc32.DLL (unknown line)
SQLPrepareW at C:\WINDOWS\SYSTEM32\odbc32.DLL (unknown line)
##compiled_ccall#250 at c:\Users\GDI\.vscode\extensions\julialang.language-julia-1.127.2\scripts\packages\JuliaInterpreter\src\optimize.jl:237
unknown function (ip: 000002a35e20662b)
jl_apply at C:/workdir/src\julia.h:2157 [inlined]
jl_f__call_in_world at C:/workdir/src\builtins.c:894
jl_apply at C:/workdir/src\julia.h:2157 [inlined]
do_apply at C:/workdir/src\builtins.c:831
#invoke_in_world#3 at .\essentials.jl:1089
jl_apply at C:/workdir/src\julia.h:2157 [inlined]
do_apply at C:/workdir/src\builtins.c:831
invoke_in_world at .\essentials.jl:1086
jl_apply at C:/workdir/src\julia.h:2157 [inlined]
do_apply at C:/workdir/src\builtins.c:831
bypass_builtins at c:\Users\GDI\.vscode\extensions\julialang.language-julia-1.127.2\scripts\packages\JuliaInterpreter\src\interpret.jl:213
#evaluate_call_recurse!#65 at c:\Users\GDI\.vscode\extensions\julialang.language-julia-1.127.2\scripts\packages\JuliaInterpreter\src\interpret.jl:253
evaluate_call_recurse! at c:\Users\GDI\.vscode\extensions\julialang.language-julia-1.127.2\scripts\packages\JuliaInterpreter\src\interpret.jl:251
eval_rhs at c:\Users\GDI\.vscode\extensions\julialang.language-julia-1.127.2\scripts\packages\JuliaInterpreter\src\interpret.jl:391
step_expr! at c:\Users\GDI\.vscode\extensions\julialang.language-julia-1.127.2\scripts\packages\JuliaInterpreter\src\interpret.jl:477
step_expr! at c:\Users\GDI\.vscode\extensions\julialang.language-julia-1.127.2\scripts\packages\JuliaInterpreter\src\interpret.jl:614
finish! at c:\Users\GDI\.vscode\extensions\julialang.language-julia-1.127.2\scripts\packages\JuliaInterpreter\src\commands.jl:14 [inlined]
finish_and_return! at c:\Users\GDI\.vscode\extensions\julialang.language-julia-1.127.2\scripts\packages\JuliaInterpreter\src\commands.jl:30
#evaluate_call_recurse!#65 at c:\Users\GDI\.vscode\extensions\julialang.language-julia-1.127.2\scripts\packages\JuliaInterpreter\src\interpret.jl:290
evaluate_call_recurse! at c:\Users\GDI\.vscode\extensions\julialang.language-julia-1.127.2\scripts\packages\JuliaInterpreter\src\interpret.jl:251
eval_rhs at c:\Users\GDI\.vscode\extensions\julialang.language-julia-1.127.2\scripts\packages\JuliaInterpreter\src\interpret.jl:391
step_expr! at c:\Users\GDI\.vscode\extensions\julialang.language-julia-1.127.2\scripts\packages\JuliaInterpreter\src\interpret.jl:477
step_expr! at c:\Users\GDI\.vscode\extensions\julialang.language-julia-1.127.2\scripts\packages\JuliaInterpreter\src\interpret.jl:614
finish! at c:\Users\GDI\.vscode\extensions\julialang.language-julia-1.127.2\scripts\packages\JuliaInterpreter\src\commands.jl:14 [inlined]
finish_and_return! at c:\Users\GDI\.vscode\extensions\julialang.language-julia-1.127.2\scripts\packages\JuliaInterpreter\src\commands.jl:30
#evaluate_call_recurse!#65 at c:\Users\GDI\.vscode\extensions\julialang.language-julia-1.127.2\scripts\packages\JuliaInterpreter\src\interpret.jl:290
evaluate_call_recurse! at c:\Users\GDI\.vscode\extensions\julialang.language-julia-1.127.2\scripts\packages\JuliaInterpreter\src\interpret.jl:251
eval_rhs at c:\Users\GDI\.vscode\extensions\julialang.language-julia-1.127.2\scripts\packages\JuliaInterpreter\src\interpret.jl:391
step_expr! at c:\Users\GDI\.vscode\extensions\julialang.language-julia-1.127.2\scripts\packages\JuliaInterpreter\src\interpret.jl:477
step_expr! at c:\Users\GDI\.vscode\extensions\julialang.language-julia-1.127.2\scripts\packages\JuliaInterpreter\src\interpret.jl:614
finish! at c:\Users\GDI\.vscode\extensions\julialang.language-julia-1.127.2\scripts\packages\JuliaInterpreter\src\commands.jl:14 [inlined]
finish_and_return! at c:\Users\GDI\.vscode\extensions\julialang.language-julia-1.127.2\scripts\packages\JuliaInterpreter\src\commands.jl:30
#evaluate_call_recurse!#65 at c:\Users\GDI\.vscode\extensions\julialang.language-julia-1.127.2\scripts\packages\JuliaInterpreter\src\interpret.jl:290
evaluate_call_recurse! at c:\Users\GDI\.vscode\extensions\julialang.language-julia-1.127.2\scripts\packages\JuliaInterpreter\src\interpret.jl:251
eval_rhs at c:\Users\GDI\.vscode\extensions\julialang.language-julia-1.127.2\scripts\packages\JuliaInterpreter\src\interpret.jl:391
step_expr! at c:\Users\GDI\.vscode\extensions\julialang.language-julia-1.127.2\scripts\packages\JuliaInterpreter\src\interpret.jl:554
step_expr! at c:\Users\GDI\.vscode\extensions\julialang.language-julia-1.127.2\scripts\packages\JuliaInterpreter\src\interpret.jl:614 [inlined]
next_until! at c:\Users\GDI\.vscode\extensions\julialang.language-julia-1.127.2\scripts\packages\JuliaInterpreter\src\commands.jl:96
_next_line! at c:\Users\GDI\.vscode\extensions\julialang.language-julia-1.127.2\scripts\packages\JuliaInterpreter\src\commands.jl:181 [inlined]
next_line! at c:\Users\GDI\.vscode\extensions\julialang.language-julia-1.127.2\scripts\packages\JuliaInterpreter\src\commands.jl:176
#debug_command#85 at c:\Users\GDI\.vscode\extensions\julialang.language-julia-1.127.2\scripts\packages\JuliaInterpreter\src\commands.jl:472
debug_command at c:\Users\GDI\.vscode\extensions\julialang.language-julia-1.127.2\scripts\packages\JuliaInterpreter\src\commands.jl:453
jfptr_debug_command_5702 at C:\Users\GDI\.julia\compiled\v1.11\VSCodeDebugger\xYOi8_n4igI.dll (unknown line)
jl_apply at C:/workdir/src\julia.h:2157 [inlined]
jl_f__call_latest at C:/workdir/src\builtins.c:875
jl_apply at C:/workdir/src\julia.h:2157 [inlined]
do_apply at C:/workdir/src\builtins.c:831
#invokelatest#2 at .\essentials.jl:1055
jl_apply at C:/workdir/src\julia.h:2157 [inlined]
do_apply at C:/workdir/src\builtins.c:831
invokelatest at .\essentials.jl:1052
our_debug_command at c:\Users\GDI\.vscode\extensions\julialang.language-julia-1.127.2\scripts\packages\DebugAdapter\src\DebugEngines.jl:244
run at c:\Users\GDI\.vscode\extensions\julialang.language-julia-1.127.2\scripts\packages\DebugAdapter\src\DebugEngines.jl:333
run at c:\Users\GDI\.vscode\extensions\julialang.language-julia-1.127.2\scripts\packages\DebugAdapter\src\packagedef.jl:160
startdebugger at c:\Users\GDI\.vscode\extensions\julialang.language-julia-1.127.2\scripts\packages\VSCodeDebugger\src\VSCodeDebugger.jl:45
unknown function (ip: 000002a35e19acf4)
jl_apply at C:/workdir/src\julia.h:2157 [inlined]
do_call at C:/workdir/src\interpreter.c:126
eval_value at C:/workdir/src\interpreter.c:223
eval_stmt_value at C:/workdir/src\interpreter.c:174 [inlined]
eval_body at C:/workdir/src\interpreter.c:681
jl_interpret_toplevel_thunk at C:/workdir/src\interpreter.c:821
jl_toplevel_eval_flex at C:/workdir/src\toplevel.c:943
jl_toplevel_eval_flex at C:/workdir/src\toplevel.c:886
ijl_toplevel_eval at C:/workdir/src\toplevel.c:952 [inlined]
ijl_toplevel_eval_in at C:/workdir/src\toplevel.c:994
eval at .\boot.jl:430 [inlined]
include_string at .\loading.jl:2643
_include at .\loading.jl:2703
include at .\Base.jl:557
jfptr_include_47870.1 at D:\Julia\Julia-1.11.1\lib\julia\sys.dll (unknown line)
exec_options at .\client.jl:323
_start at .\client.jl:531
jfptr__start_73819.1 at D:\Julia\Julia-1.11.1\lib\julia\sys.dll (unknown line)
jl_apply at C:/workdir/src\julia.h:2157 [inlined]
true_main at C:/workdir/src\jlapi.c:900
jl_repl_entrypoint at C:/workdir/src\jlapi.c:1059
mainCRTStartup at C:/workdir/cli\loader_exe.c:58
BaseThreadInitThunk at C:\WINDOWS\System32\KERNEL32.DLL (unknown line)
RtlUserThreadStart at C:\WINDOWS\SYSTEM32\ntdll.dll (unknown line)
Allocations: 16801418 (Pool: 16800874; Big: 544); GC: 12

 *  The terminal process "D:\Julia\Julia-1.11.1\bin\julia.exe '--color=yes', '--startup-file=no', '--history-file=no', 'c:\Users\GDI\.vscode\extensions\julialang.language-julia-1.127.2\scripts\debugger\run_debugger.jl', '\\.\pipe\vsc-jl-dbg-5c605208-d806-4547-969d-2fd47afe9723', '\\.\pipe\vsc-jl-dbg-2da4091b-3f7d-4c35-91ac-291ec44b9941', '\\.\pipe\vsc-jl-cr-2ad6ba93-27ea-4b63-bbd5-2bcfccd1c0bd'" terminated with exit code: 1. 
 *  Terminal will be reused by tasks, press any key to close it. 

[ViralBShah]

Updated UnixODBC_jll here: JuliaPackaging/Yggdrasil#9748. I doubt that is the real issue, but just a note.