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

asked on Add a dataset


I am trying to add a dataset that connects to my database which I interact with programmatically
using the following connection string (password changed);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
Avatar of it_saige
Flag of United States of America image

Link to home
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;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


That worked.  Thanks