-
Notifications
You must be signed in to change notification settings - Fork 62
Open
Description
When using the method of DBInterface.execute with an initial function argument, ODBC.jl throws an error due to an undefined close! function.
Error:
ERROR: MethodError: no method matching close!(::ODBC.Cursor{false, false})
Closest candidates are:
close!(::ODBC.Statement) at C:\Users\ka031\.julia\packages\ODBC\mjMrW\src\dbinterface.jl:128
close!(::ODBC.Connection) at C:\Users\ka031\.julia\packages\ODBC\mjMrW\src\dbinterface.jl:105
Stacktrace:
[1] execute(f::typeof(identity), stmt::ODBC.Statement, params::NamedTuple{(), Tuple{}})
@ DBInterface C:\Users\ka031\.julia\packages\DBInterface\1Gmxx\src\DBInterface.jl:137
[2] execute(f::Function, conn::ODBC.Connection, sql::String, params::NamedTuple{(), Tuple{}})
@ DBInterface C:\Users\ka031\.julia\packages\DBInterface\1Gmxx\src\DBInterface.jl:144
[3] execute(f::Function, conn::ODBC.Connection, sql::String; kwargs::Base.Iterators.Pairs{Union{}, Union{}, Tuple{}, NamedTuple{(), Tuple{}}})
@ DBInterface C:\Users\ka031\.julia\packages\DBInterface\1Gmxx\src\DBInterface.jl:153
[4] execute(f::Function, conn::ODBC.Connection, sql::String)
@ DBInterface C:\Users\ka031\.julia\packages\DBInterface\1Gmxx\src\DBInterface.jl:153
[5] top-level scope
@ REPL[5]:1
MWE:
using ODBC
db= ODBC.Connection(...) # connect to a MSSQL db, for example via a Docker image
query = "SELECT @@VERSION"
DBInterface.execute(db, query) # works
DBInterface.execute(identity, db, query) # throws errorMetadata
Metadata
Assignees
Labels
No labels