It's good now - sorry for not having anything in the zip file.

MarValUs,

 Thanks for posting the updated DLL. It fixed my issues with getting CSK 3.0b1 up and running on Network Solutions.

Try this from scratch:

1. Select
2. Check DSN (optional?)
3. Enter UserName (this will become the database name NOT your hosting login)
4. Enter Password (again, database password NOT hosting password)
5. Check "Install Schema Features"
6. Click Continue > Create Database (it WILL take some time for the database to create itself, you can refresh by clicking the SQL button in the left menu)
7. Once setup finishes, Click Pencil icon under actions > print this page.
8. Click Computer icon under actions > record the SQL Connection (.NET) strings
9. Click Open Manager
10. Click Connection > Enter the Username and Password from 6 above.
11. Once connected, expand Tools menu > Click Query Analyzer
12. Cut & Paste all text from club-add.sql into the Query Analyzer window
13. Click Submit (you should see many "command(s) completed successfully" below)
14. Go back to VWD and edit default.aspx
15. Go to Edit > Find & Replace > Quick Replace
16. Find dbo. (NOT Dbo. big difference)
17. Replace with <blank> (nothing, nada, zip, zero)
18. Look in: Current Document
19. Click Replace All (should be 12 or more) > Save default.aspx
20. Repeat steps 16 & 17 for:
21. Events_Edit.aspx
22. Events_View.aspx
23. Open web.config
24. Replace original text

    1. <add name="ClubSiteDB" connectionString="Data Source=.\SQLExpress;

             Integrated Security=true;

             AttachDBFileName=|DataDirectory|Club.mdf;

             User Instance=True" providerName="System.Data.SqlClient"/>

25. With new text

    1. <add name="ClubSiteDB" providerName="System.Data.SqlClient"

             connectionString="server=whsql-v04.prod.mesa1.secureserver.net;

             database=DB_12345;

             uid=myusername;

             pwd=mypassword"/>

       <remove name="LocalSqlServer"/>

       <add name="LocalSqlServer" providerName="System.Data.SqlClient"

             connectionString="server=whsql-v04.prod.mesa1.secureserver.net;

             database=DB_12345;

             uid=myusername;

             pwd=mypassword"/>

26. Change <customErrors mode="Off" /> (optional)

27. Save!!!

28. Run CTRL-F5 again.  (it will bring up a window with a server error, what you want is to look in the lower left corner of the VWD window for "Build Successful")

29. Click Website > Copy Web Site > Connect

30. Input your hosting username and password (NOT you database uid and pwd)

31. Highlight all files from the left side and click right arrow to transfer.

32. Go to your public website and create an account for each admin you created on your local database.  (make sure the usernames and passwords are the same!!!)

33. Log back into Query Analyzer

34. Input

    1. SELECT RoleId FROM aspnet_Roles WHERE RoleName="Administrators"

35. Copy bracketed response into a text document and include the brackets

1. Reset QA and Input

2. SELECT UserId FROM aspnet_Users WHERE UserName="username"

3. Copy each bracketed response to your text document.

4. Reset QA again and Input

   1. INSERT INTO aspnet_UsersInRoles (RoleId, UserID) VALUES ('copied text from 29', 'copied text from 31')

5. Repeat 28-32 for each admin account.