i'm willing to pay someone to set up an instance of the classifieds starter kit on my site

i'd like to find someone who will set up an instance of the classifieds starter kit onto my site (or debug the one i tried) - i'll pay

 

If you still need help PM me and I'll give it a try for you.
Let me know if you're integrating it with a DASP SQL Server if you do.
Salute,
Mark

 

can ANYONE explain to me how to get this stupid thing working? (and why oh why the instructions are so vague? - don't they WANT people to use their hosting service??)


i have tried and tried and can not get the classifieds to work. works great locally on my machine of course. i am stuck pretty much at the beginning - where you're supposed to execute the sql statement to configure the database schema....


i downloadedosql.exe and uploaded it to my site but all i ever get when i try to use it is "invalid command"


i don't understand the whole database setup to begin with. so...executing the sql script will set up a sql server express database? - i'm guessing that since the instructions tell you to use sql server express locally. so i try to carry out this instruction:


a) Execute the command below to create the schema

osql -S <sql server name> -U <db_user> -P <DB_password> -d <DB_Name> -i <path to the starterKit>\App_datat\classifieds-add.sql



by typing this:


osql -S mysqlserverexpress -U admin -P threeo -d classifieds -i\App_datat\classifieds-add.sql


and get: "invalid command"


what am i doing wrong?

 

I'm currently working on another DASP site for someone but I can help you next.
Do you already have a DASP SQL Server for your account?
If so, will you want me to create a default installation of the Classifieds SK for you?
(Will probably be better than trying to debug the current one.)
Salute,
Mark

 

not sure what you mean by DASP


what confuses me is that in their instructions, it says to use sql server express for local development and then run a sql script from my website to build the database schema - that is the only mention of a database. so.....i'm guessing it defaults to a sql server express database? do you know?

 

If it uses an SQL Server Express database you will need a DASP SQL Server add-on for your account.
DASP = DiscountASP.NET

 

but....


under the add-ons...there IS no sql server express listed


there's sql server 2000, 2005 and mysql (i did purchase mysql but haven't used it yet)

 

I've been watching the ASP.NET forums for this Starter Kit.
You're having the same issue as a lot of the guys there.

So far if anyone has this working with MySQL or Access they're not sharing.

It does however work with SQL 2000 and 2005, Express too but we don't have an Express option.
You can only use Express DB's with your local system, not your remote DASP account.

The best option will be for you to convert it to Access but that will take more than a month, I'm guessing.

 

jeez....


why are people being so guarded about it?

 

Don't know but I can imagine getting it to work with Access is a huge task.

 

is it easy to get it to work with sql 2000? (or sql 2005, since they cost the same)

 

Yes apparently.

 

do you know what i can use to execute the sql script for the database schema? it recommended osql.exe but every time i attempt to use it i get an "invalid command" error

 

I never use that, only the SQL Server management tools. (GUI)
Do you have a copy yet?

 

no...how/where do i get it?


why do you suppose they don't mention that in their instructions?

 

To have classifieds starterkit working,do the following:

1>Upload all your classifieds web files to the DASP webserver.Before doing this,make sure you have your connection string in your web.config modified as follows:
<connectionStrings>
<remove name='LocalSqlServer'/>
<add name='LocalSqlServer' connectionString='Data Source= DBServerName</font>;Integrated Security=false;Initial Catalog= DBName</font>;User ID= DBLogin</font>;Password= DBPassword</font>' providerName='System.Data.SqlClient' />
<add name='classifiedsConnection' connectionString='Data Source= DBServerName</font>;Integrated Security=false;Initial Catalog= DBName</font>;User ID= DBLogin</font>;Password= DBPassword</font>' providerName='System.Data.SqlClient' />
</connectionStrings>

2>Attach the CLASSIFIEDSDB.mdf using the SQL Tools Suite in your Discountasp.net (DASP) Control Panel.[Assuming you have uploaded the 'CLASSIFIEDSDB.mdf' in step one-usually located under App_Data]

3>A. Open the command prompt on your local computer, and navigate to: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727
B. Execute the command: aspnet_regsql.exe -S DBServerName</font> -U DBLogin</font> -P DBPassword</font> -A all -d DBName</font>
[This will create the membership database schema for you on your remote SQL server-This is equivalent to attaching the 'ASPNETDB.MDF' ,but doing so will overwrite the mdf file attached in step 2,hence we use this command line tool to create the schema instead]


Note:[Replace everything in red by appropriate values related to your MS SQL database-See Control Panel for details]

Vikram

DiscountASP.NET
www.DiscountASP.NET

 

i don't see a sql tools suite

 

http://images.google.com/images?q=SQL+Server+2005+Management+studio

 

my bad


i found it

 

...Are you joking bro?
DASP does a great job providing the information we need.
The skills and knowledge are our responsibility.
However even that's simple since there are so many ASP.NET help sites.
Have you watched the Learning Series videos at www.asp.net?


Here's the information you're looking for by the way:
Attach MDF file tool
http://kb.discountasp.net/article.aspx?id=10431

 

i see nothing about how to do an "attach"


man....every step is grueling


what you guys should do is write your instructions and then watch as someone tries to follow them and makenotes. you assume wy too much.


every step i have to go research

 

so how do i "attach the classifiedsdb.mdf using the sql tools suite in your dasp control panel"?


there is no "attach" tab or button

 

this is so typical.....


sql 2000 doesn't have an "attach mdf file" tool


apparently 2005 does but not 2000

 

could anyone script out the classifieds database in sql 2000 and email it to me?

 

I have working classified and all of the tools to set it up on a SQL2005 database. If you would like I will do it for you free of charge and you will have it the same day provided you have SQL server 2005.

Probably will take 15 mins.

You can then change your passwords and the web config to ensure your account security.

I would recommend dumping the mysql immediately and getting SQL Server 2005. I don't even know why Discount ASP even offers mysql as an option. In my opinion one is only downgrading their development and application environment when trying to mingle mysql with .NET or any Microsoft language.
I'm all for open source but trying to use mysql with a Windows based (web or standalone) application is just an invitation for frustration and problems.


Thanks, Dave

Free tool to work with SQL server 2005
Microsoft SQL Server Management Studio Express
http://www.microsoft.com/downloads/...AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

 

wow - that's nice of you


i currently have sql server 2000 database but i'll switch it to a sql server 2005 right now....

 

dave - i sent you a private message about your offer


did you get it?

 

It's done. Check your pms.

Thanks, Dave

Post Edited (DaveCS) : 1/15/2008 2:16:01 AM GMT