Unanswered

Best way to run VB Script against SQL Server On prem using flow

(0) Share

Report

Posted on by Community Power Pla...

Hi All,

I have a word file that uses VBscript to fetch Data from an on prem sql server db. With an on prem data gateway when I tried to use execute sql query action under SQL server within flow, it threw an error as shown below. I believe this is a limitation at this point. Having said that, can someone please share an alternative to run vbscript from power automate? May be via an azure function approach if its doable that way, thanks in advance.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Paulie78 8,422 Moderator on at

Like (1)

Report

Re: Best way to run VB Script against SQL Server On prem using flow

You cannot use a SQL Query via the on-prem gateway, this option is only valid for Azure based SQL servers. However you may be able to get the data you need by selecting a table and using an odata filter query.

You cannot run VBScript (or VBA) from a cloud flow, but you could do it with a Power Automate Desktop flow. But if all you need is some data from your SQL server, you should be able to do that quite easily within a cloud flow.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Best way to run VB Script against SQL Server On prem using flow

Thanks @Paulie78 , appreciate the answer. Would you please share an example or screenshot about the cloud flow option you mentioned, it would be very helpful to understand. Also, I am trying to get my hands on with Power Automate desktop but have not used so far, any help or direction there would be very helpful too just for knowledge purpose.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Best way to run VB Script against SQL Server On prem using flow

Can someone please share a potential flow solution for this, thanks.

Was this reply helpful? Yes No