Hi Does any one know how to change the conn string from attach mode to a normal one?
I am using the online diary application which the original code has the attach method on the code in web config and under app-code folder.
i did change the connection string in the web config that is ok now how is the connection string in the app-code folder within the class gonna be, it cant be the same cos i did try and it gives me an sql error :Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instances.:
which i have enabled .
any suggestions ?

thanks

bx

__________________
bx

Hi there,

Take a look here:

http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=395

and here:

http://www.connectionstrings.com/

Hope that helps,

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of Beginning ASP.NET 3.5 : in C# and VB, ASP.NET 2.0 Instant Results and Dreamweaver MX 2004
Want to be my colleague? Then check out this post.

Hi Imar thanks for the replay the connection in the web confiis working the one inside the lasses does not.
This is the conn in the web config:<add name="DiaryDBConnectionString" connectionString="Data Source=SQLEXPRESS;Initial Catalog=DiaryDB.mdf;User ID=xxxxxx; Password=xxxxxxx"
   providerName="System.Data.SqlClient" />
how do i change the conn inside the class? can it be the same

Public Class DiaryEvent
    Const conString As String = "Data Source=SQLEXPRESS;Initial Catalog=DiaryDB.mdf;User ID=xxxxx; Password=xxxxxxxx"


bx

there is some thing else, i dont want to use the attach method so i restored the database in a sql server and delete the app-data folder from the directory, but every time i rebuild the application the app-data folder is created,there is a bit of code that does that and i cant find it,

bx

The code doesn't do it; the ASP.NET run-time does this.

Take a look here to learn how to reconfigure ASP.NET (linked to from the first article I posted in this thread): http://weblogs.asp.net/scottgu/archi...25/423703.aspx

BTW, it should be .\SqlExpress if you're working with the expression version.

HtH,

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of Beginning ASP.NET 3.5 : in C# and VB, ASP.NET 2.0 Instant Results and Dreamweaver MX 2004
Want to be my colleague? Then check out this post.