Last post Nov 22, 2006 09:33 PM by Peachesnjuice
Nov 19, 2006 03:52 AM|Peachesnjuice|LINK
I have been observing and reading posts. I am confused as to why people in the posts are asking about creating databases ... when the databases are already created in the starter kit.
Did I miss something?
1. My question: I noticed that the Classified string is already in the web.config file with the starter kit. Can anyone explain to me about the Local dbf connection string - and should I hard code this?
2. I noticed the classified starter kit didn't come with a detailed help file ... Was this on purpose?
Thanks ~ Peaches
PS I am new to ASP programming
Nov 19, 2006 05:20 PM|Annddrew|LINK
The database that comes with the kit is for sql server express edition. If you want to use any other database like sql server 2000 you need to create this database. Hope this helps...
Nov 19, 2006 06:19 PM|Peachesnjuice|LINK
Thank you Andrew
I'm familar with databases ( over 26 years - I started from the Cobol/Mainframe era.... Foxpro .... Visual Foxpro...and a little of sql programming but I am new to this technology) . .
So when I was reading the post ..... I didn't understand why people were saying that they had to create the classified kit database ... when the files are already included with the starter kit.
I use Visual web developer 2005 - When I download the kit .... executed the scripts.....and I was able to access the two files without creating a file.
The problem that I'm having are the connection strings for when uploading to our server. I have the classified connection string ...but the local connection string isn't working.
Nov 20, 2006 11:13 AM|Annddrew|LINK
Nov 20, 2006 04:01 PM|Peachesnjuice|LINK
If I could bother you a second......
This driving me nuts. I am using Visual Studio 2005 using the VS Studio Express tool - SQL Server 2005
Our web hosting company isn't no help.....
I reviewed the thread link you provided.... Could you please look at the parial web.config
= = = = = = =
So when we say the local string .... this is the aspnet.db right?
So which means... I have to hard code .... the <add
Lastly, Do I need to hard code the user name and passwords for both strings ... ( classified and aspnet )
Nov 20, 2006 05:15 PM|Annddrew|LINK
You should have in your web.config file the following two connection strings:
<add name="classifiedsConnection" connectionString="Data Source=localhost;Database=classifieds;User ID=sa;Password=;Trusted_Connection=False" providerName="System.Data.SqlClient="/>
<add name="LocalSqlServer" connectionString="Server=localhost;Database=aspnet;User ID=sa;Password=;Trusted_Connection=False" providerName="System.Data.SqlClient"/>
You should provide the password for the 'sa' account or any other account that you might use. Or maybe you can remove the User ID and Password from your connection strings and provide something like:
Nov 20, 2006 05:58 PM|Peachesnjuice|LINK
(sorry with the triple spacing ) the last message .. yikes
I am going to plug in the changes.
Nov 22, 2006 10:09 AM|gladxml|LINK
When you run the Classified starter kit in order to see the documenttion try to type in the browser "welcome.html" instead of defult.aspx. This will give you the instruction on how to use it the first time and how to change the the role assignment of every
user that you have added using the classified registration page and other explanation on the starter kit.
Hope this helps.
Nov 22, 2006 06:34 PM|Peachesnjuice|LINK
" When you run the Classified starter kit in order to see the documenttion try to type in the browser "welcome.html" instead of defult.aspx "
I personally think you are getting *smart*.... instead of assisting... you are mocking..
Nov 22, 2006 09:33 PM|Peachesnjuice|LINK
Ok... I seee now what you meant.
I guess you were trying to assist... thanks
I was thinking you were being smart
I'll review the steps again.... because apparently I am missing something...