VB.net Add a dataset

Hi

I am trying to add a dataset that connects to my database which I interact with programmatically
using the following connection string (password changed)
Server=winsqlr01.cpt.wa.co.za;Database=Demo1;Uid=Demo1;Password=xxxxxxxxxxxxxxxxx
The connection works in code but I get the error below in trying to add a new datasert

1
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
 
it_saigeDeveloperCommented:
Remove Server= from in front of the name of the server.

-saige-
0
 
Éric MoreauSenior .Net ConsultantCommented:
is the server to which you try to connect has the TCP IP protocol enabled?
0
 
Éric MoreauSenior .Net ConsultantCommented:
can you also try this connection string:

Data Source=winsqlr01.cpt.wa.co.za;Network Library=DBMSSOCN;
Initial Catalog=myDataBase;User ID=Demo1;Password=xxxxxxxxxxxxxxxxx;

Open in new window

0
 
it_saigeDeveloperCommented:
For example:Capture.JPG-saige-
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
That worked.  Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.