Files in Online Diary (Chapter One)

flashmanTom · July 8th, 2009, 11:03 AM

I am studying Online Diary, but can't get the ASPNETDB and DiaryDB to install into sql. What am I doing wrong?

Also, when a run Online Diary, I get the error ' generating a user instance in SQL is disabled'. At this point in time, I'm not as knowledgeable about SQL as I would like to be. Please help!

Imar · July 9th, 2009, 05:03 PM

Hi there,

Can you define " can't get the ASPNETDB and DiaryDB to install into sql" in detail? Hard to say something useful without a lot more information.

The application assumes you have SQL Express installed. If that's the case, it should "just work" out of the box.

Cheers,

Imar

flashmanTom · July 10th, 2009, 09:52 AM

Hi Imar,

Thanks for replying.

I do have SQL Express installed, however, somehow or another the two files have become associated with Word Pad, so SQL won't attach them.

How do I remove the association?

Thanks,

Tom

Imar · July 10th, 2009, 10:29 AM

Hi Tom,

You can remove the association in Windows Explorer under Tools | Extra.

However, for SQL it doesn't matter. You don't have to attach them to SQL. They'll be attached on-the-fly based on the connection string in web.config.

Just open the project in Visual Web Developer, hit Ctrl+F5 and you should be good to go....

Imar

flashmanTom · July 10th, 2009, 12:04 PM

Hi Imar,

Thanks again for the reply.

I tried running the project straight from the cd, but still get the following error:

Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instances

What else can I do?

Thanks,

Tom

Imar · July 10th, 2009, 12:42 PM

"straight from the cd" as in opening it from the CD directly or did you copy it local?

In the former case, copy the files to your local drive first as SQL needs to be able to write to the database....

Imar

flashmanTom · July 10th, 2009, 01:51 PM

Hi Imar,

When I first submitted the question, I was referring to a local copy

Imar · July 10th, 2009, 06:36 PM

Yet, but then you said you were trying to attach them instead of simply using them at run-time... ;-)

Anyway, have you Googled for the error message? Maybe something is wrong with your Express setup? On default installations user instances are supported but you can turn them on and off. Searching Google brings up stuff like:

http://forums.asp.net/p/1035148/1429516.aspx

Alternatively, you can indeed attach the databases to SQL Server and then change the connection string. Maybe this provides more information:

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

Personally, I'd go for the first option though. Having a well configured Express edition is always useful....

Hope this helps,

Imar