Link to home
Start Free TrialLog in
Avatar of Murray Brown
Murray BrownFlag for United Kingdom of Great Britain and Northern Ireland

asked on

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

User generated image
ASKER CERTIFIED SOLUTION
Avatar of it_saige
it_saige
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
is the server to which you try to connect has the TCP IP protocol enabled?
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

For example:User generated image-saige-
Avatar of Murray Brown

ASKER

That worked.  Thanks