Data - SQL Server Error
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-09-20 08:04 AM
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
------------------------------
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
------------------------------
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-09-20 08:20 AM
Hi Julia,
please try with Data-OLEDB VBO if you are using oledb connection string
------------------------------
Jerin Jose
RPA Product SME
EY
Asia/Kolkata
------------------------------
please try with Data-OLEDB VBO if you are using oledb connection string
------------------------------
Jerin Jose
RPA Product SME
EY
Asia/Kolkata
------------------------------
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-09-20 06:13 PM
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]
------------------------------
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]
------------------------------
------------------------------
Vipul Tiwari
Senior Process Simplification Developer
Amazon
------------------------------