asked on

building E-commerce web site

I am an oracle developer, i am going to build e-commerce web site. I want to know a lot about the asp, can asp create e-commerce web site. is it easy to learn.
what is the best database can i use with the asp.

MsShadow

I suggest you start with giving a lot more points for such a question.

nigelrivett

You can use asp to build the presentation layer but it is interpreted, hence take a lot of processing power, hence the amount of work it does should be kept to a minimum. If you are expecting a lot of users and want to keep the number of machines down then use a middle layer written in something like VB under MTS. The ASP layer receives the input - passes it directly to the com layer which carries out all the processing and database access and may pass the output back to ASP for presentation.

ASKER CERTIFIED SOLUTION

Michel Sakr

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Michel Sakr

also check microsoft's MSDN for great asp info & tutorials (who can give more info than the creator?):

http://msdn.microsoft.com/workshop/server/asp/asptutorial.asp

ErikKvK

ASP as a technology can be used for any type of web function you need. ASP doesnot restrict you to anything, except platform (Yes, it can be done on Unix).

Since you being an Oracle developer try Oracle for more info on web integration and such.

Oracle has some good products for making Web applications with an Oracle DB behind it.

fadiwilliam

ASKER

hi ErikKvK,
I wish to use oracle products but the price of the application server is very expensive.
what is your opinion?

MsShadow

Fadiwilliam is Oracle supports odbc, you can use asp to access it. I am not an Oracle expert, to be honest I only know that it is a database :), but if it supports odbc, you can use asp to access it, without needing an expensive application server.

ErikKvK

fadiwilliam,

Couldn't say, No experience with the products.

With our company we developed a simple website for extracting and presenting information out of a Oracle Database as a client front end. Large oracle application on the backend. Its for our helpdesk.

Did this al in Perl and Oracle.

For real E-Commerce applications I won't recommend this way, maybe better trying MS-stuff.

jekl2000

There is an ODBC Driver for Oracle and you may connect to it using asp. There are some off the shelf shopping carts to use of you can build your own fairly easily with asp/vbscript. It really depends on the complexity you want and the number of users you expect. There are some exceptional asp sites with some great articles to help you learn. One place for good tutorials is w3scripts.com....they are free and give great examples.

harnal

Use this to connect to an Oracle db. with ASP. Also
>>ASP is interpreted, yes and no, you can easily compile most ASP tiers into an ActiveX dll. that will execute much faster than traditional intrepreted code.

Current Oracle database connection:

dbObject.open "Drive={Microsoft ODBC for Oracle};" & _
"Server=ServerName.databasename;" & _
"Uid=Userid;" & _
"Pwd=Password;"

Older Oracle database connection:

dbObject.open "Driver={Microsoft ODBC Driver for Oracle};" & _
"ConnectString=OracleServer.DatabaseName;" & _
"Uid=Userid;" & _
"Pwd=Password;"

~ch

amp072397

fadi, thanks for cleaning up all of your open questions. You have just this one more question to address. I would normally not mind, but this one's getting a bit old. I'm sure the Experts will appreciate it too.

Thanks.
amp
Community Support Moderator @ Experts Exchange

amp072397

ComTech

fadiwilliam,

My standard email to Members that abuse the rules of the site and the question and answer process usually results in a demand to take care of business or a good chance of suspension. Because I always like to give Members and Experts the benefit of the doubt, and because our Members are important to us. I always double-check prior to sending it.

I see that you've cleaned up your questions and am sending this to show you my appreciation instead."

With Thanks,
ComTech
CS Admin @ EE

amp072397

Way to go, fadi!
amp
community support moderator