here are two databases in the personal starter kit, aspnetdb.mdf and personal.mdf. I think aspnetdb takes cares of user information and personal takes control of albums and photos. Do I have to combine these two or leave it as is. And how do I set up web.config to get it running. Thank you.
See : http://community.discountasp.net/default.aspx?f=25&m=8785 Use personal-add.sql(Incldued w/ Starter Kit) instead of club-add.sql Post Edited By Moderator (Joel Thoms) : 11/16/2006 10:37:30 PM GMT
Thank you Vikram, for your response. You answered part of my question. Another part I am going to ask is that on discountasp.com, I need to set up 2 database or just 1 database. They charge $10 for every single database. Do I need personal.mdf or aspnetdb.mdf or both? Thank you. Sweet.
Thank you Vikram foryour clear explaination. It seems clear to me now. I runosql -S SQL_SERVER_NAME -U USERNAME -P PASSWORD -d DATABASE_NAME -i personal-add.sql command. I got the following: 1> 2> 3> 4> 5> 6> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 6> 7> 1> 2> 3> 4> 1> 2> 1> 2> 3> 4> 5> 6> 7> 8> 9> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 1 1> 12> 13> 14> 15> 16> 17> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16 > 17> 18> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 1> 2> 3> 4> 5> 6> 7> 1> 2> 3> 4 > 5> 6> 7> 8> 1> 2> 3> 4> 1> 2> 1> I guess it creates the personal DB schema. But when I opened my website, everything is OK except I can't see all the albums and pictures. Sweet
Yes the personal Starter Kit has two DB's,i.e personal.mdf or aspnetdb.mdf and you need both. If you see in the link I provided , 1>aspnet_regsql.exe -S [DB Server Name] -U [DB login] -P [Password] -A all -d [Database name] will install the schema for ASPNETDB.mdf and 2>for the personal.mdf you could either </font> attach it using the MS SQL tools(Control Panel) or run this command in your command prompt:sqlcmd -S SQL_SERVER_NAME -U USERNAME -P PASSWORD -d DATABASE_NAME -i personal-add.sql,which will create the db schema for personal.mdf instead. So having one DB is fine . Vikram DiscountASP.NET www.DiscountASP.NET
Thank you for the response. I just need to add some albums and photos because I just created the database schema andit is still empty. Now it is working well. Thank you again. Sweet
