Answered

SQL connection is uninitialized

(0) Share

Report

Posted on by lion

100

when run "Execute SQL statement", it pop-up "SQL connection is uninitialized. Please double-check that the correct SQL connection has been specified and that it's used after 'Open SQL connection' and not after it's been closed".

how do I judge "sql connection" was closed? then I can open again, I don't want to open sql conection every time while "Execute SQL statement".

Categories:

Power Automate Desktop

All responses (3)

Answers (1)

Sort by

Verified answer

Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

You do not need to use the Open SQL connection action at all. You can also use a SQL connection string instead. You will not need to open a connection this way at all. Simply change the "Get connection by" value in the Execute SQL statement action to "Connection string" and pass the string. You can also have the string in a variable. This way you will never have the "SQL connection is uninitialized" error.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.
lion 100 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, thanks for the info, I loop an excel file (many records) to derive the data for "execute sql statement", per my understand, if use 'connect string' it will reopen connection every time, I think it will downgrade the performance.
Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

There is no need to 'open' a connection at all. There's no such thing as a connection to a SQL server that is kept alive. I suggest you test it and see if you have any effect on performance. We never use the Open SQL connection action in our projects at all, regardless of how many items need to be iterated, and have never had any issues with performance.