I have a Stored Procedure where DBConnection in the Gateway has the name Production_DB
Here is my test script.
dbnameconnect =system.db.beginTransaction(database = “Production_DB”)
call = system.db.createSProcCall(“Production_DB.dbo.usp_iiot_IgnitionDatasetfromSP”,dbnameconnect)
dataset = system.db.execSProcCall(call)
normaldataset = system.dataset.toDataSet(dataset)
The following errors occur
Error executing system.db.execSProcCall()
caused by: com.inductiveautomation.ignition.gateway_interface.Gatewayexception: DataSource “c9c2f1f7-5fe3-4979 etc” does not exist in this gateway.
The Production_DB is configured as a name database connection.
You failed. Look at the quotes in your reposted code block. They’ve been auto-converted to “pretty” quotes. The whole point of asking the OP edit their own comment’s pasted text is because their post still has the original characters and spaces.