|
| | | StrataFrame Beginner
 
Group: StrataFrame Users
Last Login: 10/28/2008 3:58:06 PM
Posts: 39, Visits: 437 |
| 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 |
| |
| | | 
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Yesterday @ 7:08:30 PM
Posts: 4,811, Visits: 4,781 |
| 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.  New SqlDataSourceItem("","server=MyServer;user id=sa;password=Mypassword;database=MyDatabase;") or New SqlDataSourceItem("","server=MyServer;Integrated Security=SSPI;database=MyDatabase;") |
| |
| | | StrataFrame Beginner
Group: StrataFrame Users
Last Login: 10/28/2008 3:58:06 PM
Posts: 39, Visits: 437 |
| | 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 |
| |
| | |
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Yesterday @ 7:08:30 PM
Posts: 4,811, Visits: 4,781 |
| | 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. |
| |
| | | 
StrataFrame User
Group: StrataFrame Users
Last Login: 11/25/2008 7:55:39 AM
Posts: 473, Visits: 1,955 |
| | 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 |
| |
| | |
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Yesterday @ 7:08:30 PM
Posts: 4,811, Visits: 4,781 |
| | Just FWI...SF automatically adds the Asynchronous processing tag for you as needed. Since the DataLayer can save on multiple threads, this is a core level functionality of the framework. |
| |
| | |
StrataFrame User
Group: StrataFrame Users
Last Login: 11/25/2008 7:55:39 AM
Posts: 473, Visits: 1,955 |
| Just FWI... New acronym?  I'll knock those off, then. Thanks!
Bill |
| |
| | |
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Yesterday @ 7:08:30 PM
Posts: 4,811, Visits: 4,781 |
| Oops...that is what fast typing get you...speed kills  |
| |
| | | StrataFrame Beginner
Group: StrataFrame Users
Last Login: 10/28/2008 3:58:06 PM
Posts: 39, Visits: 437 |
| | Bill and Trent, Thanks - I've changed it to look like this: DataLayer .DataSources.Add(new SqlDataSourceItem("", "Data Source=SQLLR01\\SQLLR01;Initial Catalog=PTPlusData;Integrated Security=SSPI"));Seems to work now. But...a question on the user name...help me understand how this works. I was thinking the webserver would be the one logging into the SQL Server. As such, I was thinking I could use the Windows security instead of a user name/password scenario. Why is it that I need a user name instead? (I'm not arguing with you here - just wanting to understand - I really appreciate the help!!!) HB |
| |
|
|