Question on your NLayer Application

vectortonto · June 25th, 2009, 12:20 AM

Chatted with you via email on this topic. I was having issues converting an mdf to a sql server database. I figured that part out and now have the database in Sql Server 2005 instead of Express:

My connection string changed from:<add name="NLayer" connectionString="Data Source=(local)\SqlExpress;AttachDbFilename=|DataDi rectory|\NLayer.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>

To:

<addname="NLayer"connectionString="Data Source=(local);Initial Catalog=ContactManagement;User ID=sa;Pwd=p4yt0ng;
"providerName="System.Data.SqlClient"/>

I'm having issues with the provider now specifically line 221 in default.aspx.cs

btnNew.Visible = Membership.GetUser() != null;

{"The user instance login flag is not supported on this version of SQL Server. The connection will be closed."}

Any ideas on how to get the provider to work?

Imar · June 25th, 2009, 03:26 AM

Hi there,

First of all, this forum is specific for my book "Beginning ASP.NET 3.5 in C# and VB.NET". Can you please post messages like this one that are not related to my book in a mpre generic ASP.NET category here at p2p.wrox.com? Makes it easier for readers of the book to find relevant messages.

That said, I don't think the problem is related to the N-Layer connection string, but to the one used by Membership (called LocalSqlSevrer by default).

Check out these articles for more help:

http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=395
http://weblogs.asp.net/scottgu/archi...25/423703.aspx

Cheers,

Imar

vectortonto · June 25th, 2009, 10:11 AM

Scott G is da man. Thanks for the support Imar, Much appreciated

Imar · June 25th, 2009, 12:00 PM

Does it work now?

Imar