ODBC connection string error on Power Automate Desktop

(0) Share

Report

Posted on by SP8

Hi.

I'm trying to connect to data in SAP Hana via the ODBC connector in Power Automate.

My drivers are ok. I connect to SAP Hana via PBI/Excel Power Query multiple times daily.

From Power Automate Desktop, I try to use the connection builder and the test says that the connection works.

But when I try to run it, it fails, saying that the connection string isn't valid.

How can I fix or troubleshoot this? Why doesn't the string it builds me from the "wizard" work?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (0)

Sort by

VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @SP8

Problem appears to be the syntax in the connection string which PAD is unable to take.

Cannot see the connection string fully in the screenshot.

- Are you able to write some dummy values and share the full string?

- Hope you have taken care of all the things that might interfere with the syntax like all required semi colons, percent signs handled, all parameters given, etc.?

- Are you able to point out which of the connection strings are you using? - https://www.connectionstrings.com/

Was this reply helpful? Yes No
SP8 13 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @VJR . My string wasn't on your list of connection strings. We're trying to connect to SAP Hana via the ODBC driver. I'm not sure what that qualifies as on the list on the link you sent.

The blacked out portion after USER ID= is my user ID (which has no spaces) followed by a semicolon.
After Data Source= is the server that I'm connecting to. It is 3 letters, space, dash, space 4 letters and then semi colon. It is exactly the way I connect via Power Query and is actually a drop-down selection, so I know that it's correct.
That's it.

Was this reply helpful? Yes No
VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @SP8

would you be able to try with the DRIVER={HDBODBC} instead of the Provider and by using any of the below connection strings.

https://help.sap.com/viewer/0eec0d68141541d1b07893a39944924e/2.0.01/en-US/66a4169b84b2466892e1af9781049836.html

Was this reply helpful? Yes No