Need tips on using IIS/SQL Server to create ecommerce site 1

[Terpsfan]

I'm a newbie to creating ecommerce sites. I have a SQL Server database on Windows 2000 Server. I've created .asp pages to insert and view records, display items etc. How do I publish this to the internet and make it viewable to users? If I have IIS, can I publish it from there or do I need a web host. And do I keep the database on my computer or ftp to the host? Sorry about the seeming stupidity of these questions. Thanks

 

[lck092580]

Nah.. ur question is hardly stupid.

First off.. with the stuff u have right now u have options..

1. Host it all from ur hardware.

Using IIS.. get a ISP to provide u a tranmission medium.. host the site.. be done with it.

2. Split the load with u and ur ISP (ISP must have web hosting option).

Put ur .asp pages on ur host.. have it directly grab the info off ur server using ODBC..

Ur choice should depend on ur budget. If u had the cash then u might as well do everything urself with ur hardware.

If u're tight on money then see if u can get a deal with a web hosting company and have them do it (but that defeats the whole purpose of having all that software right? heh).

Good luck.

T

 

[lck092580]

BTW: We (@ work) have a commerce server too.. it uses IIS.. we also have a SQL Server 2k on another box.. our own adsl line.. and a proxy server where our firewall resides.

T

*HighSchooL Graduate*

 

[Terpsfan]

So basically IIS works as the middle man between the .asp page and the database? It seems that way. And I'd create a virtual directory and put everything to do with the site in that directory? You mentioned creating an ODBC connection to the database, how about using an ADODB.Connection, because I'm using ADO recordsets? If you could suggest a good book, I think that would probably help me the most. I understand how to create the .asp pages and create the backend database, but I'm not experienced in dealing with IIS to host the site.

 

[lck092580]

Hey Omega,

The truth is this: "You already know all the hard stuff.. IIS is the easy part."

I'm serious too. If you know how to write .asp pages and create backend dbs then IIS should be nothing more than a piece of cake for you.

U're kinda right.. IIS is like the middle man. IIS is basically a web server app. which serves web page requests (like a waiter in a resturant). The .asp is like the dish being served and your sql server is like the "COOK" in the backend dishing out platters.

I must admit that I can't say I'm an expert of IIS because I've never read a book on it. All i did was play around with it and read webpages. Yep.. the internet is a powerful tool.. god knows how much money i saved.

I don't have the bookmarks @ work but here's one that I remember:

http://www.iisanswers.com

The site doesn't look all too appealing but i started from there and searched around. Have a look.. i gotta run off to school now.. let me know if u need more help.

T

*Highschool Graduate*
BA -> MBA