Club Web Site Starter Kit

Re: VS2005 RC, has anyone got the Club starter kit working

erinevance — Fri, 20 Jan 2006 15:16:49 GMT

Did you ever figure out why it didn't work on your first computer? I have the same error: Invalid command 'load'.

Re: VS2005 RC, has anyone got the Club starter kit working

BillGriffin — Sun, 01 Jan 2006 00:53:14 GMT

Just now used your instructions, and as expected, they worked for me. For steps 3 thru 8, I followed your intent, but instead of using the command line method, used the SQL Server Management Studio Express CTP, downloadable now from msdn at...

http://www.microsoft.com/downloads/details.aspx?FamilyID=82afbd59-57a4-455e-a2d6-1d4c98d40f6e&DisplayLang=en

The only two things I can add:

1. The Mgmt Studio adds an extention of ".mdf" automatically - no need for you to enter it when creating a new database.

2. The detached .mdf file is instead located at C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data

Re: VS2005 RC, has anyone got the Club starter kit working

clint1028 — Mon, 28 Nov 2005 22:43:14 GMT

I have the Club starter kit downloaded and installed...I can open a new project using this template...I however can not save the project. I get an error saying interface is not supported.

Re: VS2005 RC, has anyone got the Club starter kit working

Mykre — Tue, 22 Nov 2005 22:41:10 GMT

I have just downloaded and installed the starter kit from,

Direct Link to the Visual Studio Starter Kits on MSDN
http://msdn.microsoft.com/vstudio/downloads/starterkits/

Afetr installing, it all works fine. In the directory for the templates the starter kit is actually labeled as rtm.

Directory and starter kit location.
My Documents\Visual Studio 2005\Templates\ProjectTemplates\Visual Web Developer\CSharp

Re: VS2005 RC, has anyone got the Club starter kit working

Kane — Tue, 22 Nov 2005 22:26:03 GMT

I downloaded both the starter kit and Web Dev at 19:25 GMT today, no previous version of SQL, Web Dev, Visual Basic etc have been on this system. It still doesn't work for me.

The build number on the file ClubSite.vscontnet is not available as someone forgot to fill out the extended details when creating it, the file is dated 07/03/2005 18:38.

The VWD 2005 Expresss details are:
Microsoft Visual Studio 2005
Version 8.0.50727.42 (RTM.050727-4200)
Microsoft .NET Framework
Version 2.0.50727

Installed Edition: WD Express

Microsoft Visual Web Developer 2005 76872-000-0000011-00123
Microsoft Visual Web Developer 2005

I didn't download the library as I expect they will be in the next Technet DVD, could this be causing some or all of the problem?

I would really like to learn asp and .net web site creation but this is putting me off big time

Re: VS2005 RC, has anyone got the Club starter kit working

Mykre — Tue, 22 Nov 2005 21:50:43 GMT

All you need to do now that the Express Products have been released is to download the latest version of both the IDE and the starter kits and they work fine. The above problem was just when you had the Starter Kits from pre release and one of the CTP or RTM Builds of the IDE.

Re: VS2005 RC, has anyone got the Club starter kit working

Kane — Tue, 22 Nov 2005 20:46:44 GMT

I get the same error, when you ask ess for help the !load command is not listed as an extended command.

I tried !run club-add.sql and that just throws up loads of errors.

Can anyone tell me if .asp is always this much trouble, I'm OK with Frontpage but wanted to learn to make better sites. This is my first look at .asp, i have no idea what I'm doing and this isn't a good start :(

Re: VS2005 RC, has anyone got the Club starter kit working

n8nt — Tue, 08 Nov 2005 22:02:19 GMT

Not a dumb question, but I did type in !load as specified.

I just tried this out on another computer and it works. I'll have to see why it didn't work on my other computer. Thanks for the solution. I'll try it later today on my other computer - this one is the work computer...

Regards

Re: VS2005 RC, has anyone got the Club starter kit working

aweber1 — Tue, 08 Nov 2005 03:26:54 GMT

nope, that's the command prompt i was talking about.

I know it's a dumb question, but are you sure you typed in !load, instead of just load?

Re: VS2005 RC, has anyone got the Club starter kit working

n8nt — Mon, 07 Nov 2005 03:19:45 GMT

I downloaded your suggested files and tried this, but when I tried to load the sql, I got an error that said:
Error processing extended command.
Invalid command 'load'.

Is there a different command prompt than just using the one at Start->run->cmd??

Thanks,

Re: VS2005 RC, has anyone got the Club starter kit working

aweber1 — Tue, 01 Nov 2005 08:56:17 GMT

As the previous posts allude, you essentially need to update the 'clubsite.mdf' file that is packaged in the starter kit. And while the posts make mention of the ability to execute commands against the .mdf file via SSEUtil, I couldn't find any straightforward way of doing so. Therefore, I came up with my own method. Basically, we're completely scrapping the database that is packaged with the starter kit. Here are the steps I took to get this project working:

Download SSEUtil - http://www.microsoft.com/downloads/details.aspx?familyid=FA87E828-173F-472E-A85C-27ED01CF6B02&displaylang=en
Download the Generic SQL Server Scripts for the Club Site Starter Kit - http://www.microsoft.com/downloads/details.aspx?FamilyID=0dd83a11-6980-4951-a192-da6eacc6a19e&DisplayLang=en
After extracting both downloads, copy 'sseutil.exe' and 'club-add.sql' to the 'App_Data' directory of the Club Site starter kit. This is not a necessary step, but I found it useful so that I didn't have to always type full file paths into the utility.
Open a Command Prompt and navigate to the directory containing SSEUtil.
Type the following commands:
          sseutil -c
        1. CREATE DATABASE clubsite
        2. go
        --the command should execute successfully
        2. use clubsite
        3. !load club-add.sql
        4. go
        --the command should execute successfully, you should see the contents of the sql file after having been processed, type 'quit' to exit
Still at the command prompt, type: sseutil -d clubsite
The database should successfully detach and you have yourself a brand new clubsite.mdf to use in your project!
Close your command prompt, and in Windows Explorer, browse to C:\Documents and Settings\<your username>\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS
There you will find your newly detached 'clubsite.mdf', just copy/cut it to the 'App_Data' folder of the starter kit and either overwrite or backup the old file
Now load up your Visual Studio project and you should be able to connect to the clubsite.mdf database and be good to go.

I'm sure once the final releases of Visual Studio 2005 and SQL Server 2005 Express are available for general purchase, the Starter Kits will probably be updated and this will be a moot point and an exercise in futility, but until then good luck and I hope you find this helpful.

Re: VS2005 RC, has anyone got the Club starter kit working

herensuge — Mon, 31 Oct 2005 21:21:03 GMT

I'm trying to do Club starter kit work, but I'm working with VS2005 and Sql Server 2005 RC2 and the install kit did not create the data base.

I can't attach the data base Clubsite.MDF to my DB server, and I executed the database script by hand , but when I launch the app, I get a error: Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

This stored procedure is not created with the DB script and it is used by the SqlRoleProvider.

Where can I get the DB scripts for all ASP.NET 2.0 providers or what must I to do to install OK the BD items that providers use?

Thanks

Re: VS2005 RC, has anyone got the Club starter kit working

TheOnlyOne — Fri, 21 Oct 2005 22:50:40 GMT

thanks for the info !!!

I have used this SSEUtil command you suggested (which is the same as the SqlCmd in the binn directory of SQL Server), but now he complaints that he cannot find the tables. If i look at the mdf file it is not increased in size, so the tables are not created in that file.

Any suggestions on how I could make that happen?

Many thanks.

Re: VS2005 RC, has anyone got the Club starter kit working

Mykre — Tue, 11 Oct 2005 03:07:29 GMT

After some playing around, I finaly got it working.

What I had to do was get the SQL Script, see above post, then download the SSEUtil tool from the MSDN Site. http://www.microsoft.com/downloads/details.aspx?familyid=FA87E828-173F-472E-A85C-27ED01CF6B02&displaylang=en

This is a command line tool that will allow you to connect to Express files and run SQL Commands against it.

Re: VS2005 RC, has anyone got the Club starter kit working

pir2 — Mon, 03 Oct 2005 12:50:22 GMT

http://www.microsoft.com/downloads/details.aspx?FamilyID=0dd83a11-6980-4951-a192-da6eacc6a19e&DisplayLang=en