Saving to Azure database challenge with SQL Database Connector

Need help Plugins
1

Hello

I am using the SQL Database connector, got my connection string working, and got my query initialied (parameters and all). I put it into a workflow and it fires (I see it go thru in the debugger).

The statement is an insert (and I have verified I can insert into the table with no challenges, BUT not through this query/component.

I don’t get any sort of error and am unsure how to troubleshoot.

I have moved all fields to varchar(255) and put single quotes around all $1 params just to ensure that is not an issue.

It seems to “fire” fine, but no record saved.

Does anyone have suggestions on how to troubleshoot the challenge?

2

any thoughts on debugging this challenge? It seems like it should be so straightforward and that others have implemented saving to Azure. Nothing special here and I see all the values in the debugger.

3

Solved! My database connection was not “connected” because I did not put the following on the end of the connection string: ?encrypt=true