Last post Feb 02, 2009 06:43 PM by pkrumrei
Nov 23, 2008 11:56 AM|humayunkhan|LINK
step by step
Nov 24, 2008 10:05 AM|darkknight187|LINK
It's pretty easy.
1. Create your first MSSQL database, (This is going to be the members Database, so name it something that you can tell is for members)
There's two things that you need installed on your databases and that is DSN and ASP Schema.
Make sure you write down your username and password.
And you need the connection string for connecting, it shows you several methods but you want SqlConnection (.NET):
If you already created the database, click on the edit, little pencil icon, to the right of the database in question,
and then click on configuration.
2. Repeat step 1 with your second database. (This is going to be your Classifieds Database)
3. When I did this a year ago it did it automatically, so this part may be wrong.
Click on "Open Manager" in your database section to go into the members database.
You need to verify that it preloaded a bunch of tables views and storedprocedures..
Now go into the classifieds database, and when I did it, it loaded table, views, and stored procedures.
If it preloaded in this database, you need to delete all the tables, views, and stored procedures.
ONLY IN THE CLASSIFIEDS DATABASE.
4. Now you need to load the tables, views, and stored procedures.
If you are loading the basic kit, go into your app_data folder.
You will find .sql files, these are scripts for loading the database.
I like to open in a notepad and copy all.
Inside your classifieds database you wll find link on the left that says something like "query analizer".
Start with your classifieds-add.sql, and then the categories.sql
BEFORE YOU LOAD CLASSIFIEDS-ADD.SQL, go daddy does not like the way part of the script is set.
Open classifieds-add.sql in your visual web developer, go down to line 1057
You should see this, -- @DateCreated smalldatetime = NULL,
Change it to this DateCreated = GetDate(), before loading into query analizer.
Now load the scripts into the query analizer, update your web.config with these connection strings.
If you didn't already, you need to make sure the runtime is set to run off of asp.net 2.0
And it should work.
Let me know if you get stuck.
Nov 25, 2008 01:23 PM|humayunkhan|LINK
Nov 25, 2008 01:52 PM|darkknight187|LINK
To check your runtime go into your godaddy control panel, go into Content and then into IIS Settings.
This is what you should see, ASP.Net Runtime Version: 2.0/3.0/3.5
If it says 1.1 click on the modify to change it.
Your connection strings should be a format simular to this,
note that the second string (LocalSqlServer) is the string for the aspmembers database.
See my last post for how to get the info to put in.
<add name="classifiedsConnection" connectionString="Data Source=whsql-vxxxxxxxxxxsecureserver.net;
<add name="LocalSqlServer" connectionString="Data Source=whsql-xxxxxxxxxxxx.secureserver.net;
Nov 29, 2008 12:32 PM|humayunkhan|LINK
Feb 02, 2009 03:30 PM|pkrumrei|LINK
I need two databases for this?
I thought I only needed one?
Feb 02, 2009 05:32 PM|needmoneyforthekids|LINK
One database is for the members the other is for the ads.
Feb 02, 2009 06:36 PM|pkrumrei|LINK
I did that and still get an error getting into the Admin part.
Feb 02, 2009 06:43 PM|pkrumrei|LINK