If you have a named instance that you are referencing in the connection string then it will need to look like this:

DataLayer.DataSources.Add(new SqlDataSourceItem("Security", "Data Source=Server\\Instance;Initial Catalog=MySecurityDB;User ID=user;Password=pwd;Asynchronous Processing=True"));

Notice the "\\" which will allows the code to recognize the "\" character.

Hope that helps,
Bill

That is what I was saying, unless you setup the IUSER_ account for the OS as an allowed user for the SQL Server, then you will not be able to authenticate with Integrated Security.  You will want to use an explicit user name, not integrated security.

I've changed it to this:

DataLayer.DataSources.Add(new SqlDataSourceItem("", "server=SQLLR01;Integrated Security=SSPI;database=PTPlusData"));

and get the error saying a connection could not be established.

So...I created a WinForms app - added the BO - added a textbox.  When the app started - got the connection manager.  Filled in all the appropriate items and was able to connect and save data.  I went to the program.cs in that app and tried to manually insert the connection string as above - got the same error as the above caused.

Is there a way to see what the Connection Manager used? I figure I can copy that...

Thanks again - HB

Since this a web application, you will really want to use a user versus integrated security.  That would be one problem, but in either case, an example of each is below.

or

Not only am I new to StrataFrame AND Web Dev AND VS - but also to SQL ...needing a little help on the connection string.  I've copied the connection string from one of the wizards - but getting this error upon adding it to my global.asax - "Unrecognized escape sequence."

Here's what's in the Global.asax:

DataLayer.DataSources.Add(new SqlDataSourceItem("", "Data Source=SQLLR01\SQLLR01;Initial Catalog=PTPlusData;Integrated Security=True"));

Thanks again for helping the new guy out!

HB