topic Data - SQL Server Error in Product Forum

Data - SQL Server Error

JuliaK_ — Fri, 04 Sep 2020 07:04:00 GMT

Dear all,

I am trying to build a connection to a SQL database using the Data - SQL Server VBO. My process looks the following:

1. Set Connection
My connection string: Provider=SQLOLEDB;Data Source=IP-address/hostname that was used to create the connection; Initial Catalog=Name of my connection; User ID=username;Password=password;
2. Open
3. Get Collection

However, I get the following error message:
Network related or instance specific error when connecting to SQL Server. The server was not found or cannot be accessed. Check that the instance name is correct and that SQL Server allows remote connections. (provider: Named Pipes Provider, error: 40 - connection with SQL Server could not be opened)

I think my connection string is wrong but I tried several ones and none of them worked. Can anyone help me with this?

Many thanks in advance.

------------------------------
Julia K.
Student
Universität Regensburg
Europe/Amsterdam
------------------------------

RE: Data - SQL Server Error

JerinJose — Fri, 04 Sep 2020 07:20:00 GMT

Hi Julia,

please try with Data-OLEDB VBO if you are using oledb connection string

------------------------------
Jerin Jose
RPA Product SME
EY
Asia/Kolkata
------------------------------

RE: Data - SQL Server Error

EVIPUTI — Tue, 08 Sep 2020 17:13:00 GMT

Hi ,

The below link should help :
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-connect-query-dotnet-core

------------------------------
[Vipul] [Tiwari] [Senior Process Simplification and Optimization Developer]
[Fidelity]
------------------------------