MartyConnelly
martyconnelly at shaw.ca
Tue Jun 20 12:57:19 CDT 2006
Here is a simple sample of using ASP pages on an MS IIS web server with Access. http://www.databasejournal.com/features/msaccess/article.php/3613386 It covers the setup and some simple security but doesn't cover SQL Injection attacks which you will have to pay attention too. Also ASP.NET 2.0 and SQL Express 2005 work very well together. or you can use older ASP and SQL 2000 MSDE. It also depends on your shopping cart product. What is it written in? Most will hook to ASP but some older ones may have problems with ASP.Net 2.0 The license for freebie SQL Express now allows use on a web server. The original EULA for SQL 2005 Express had this clause includes the following line in section 4 (you may not): * use the software for commercial software hosting services. "That clause is being removed from the SP1 license so you can safely ignore it. SQL Server Express can be used in software hosting services As long as your needs don't exceed the limitations on Express" Mike Wachal, SQL Express team Kath Pelletti wrote: >Hi everyone - > >Can I pick your brains? I have a client who needs to put some data on the web which will connect to a 3rd party shopping cart product, ie. they want to display their goods on the web and allow them to be sold on to retail clients. They already have the shopping cart side organised, but they have a statically typed website - no database to feed it. > >They also need an internal system which will meet administration, management and reporting requirements - but fairly simple stuff. They are very strapped for cash (smirk) and want a fairly inexpensive solution. Lately I have been working on .net with SQL Server 2005 systems which would be a great solution - but way too expensive in development costs. > >So what about SQL Server BE with Access front end? I know it's very common but can someone tell me: > >- any gotchas >- cost for client in terms of licences they would need for SQL? I can't seem to find a clear answer by googling. > > >Thanks. > >______________________________________ >Kath Pelletti >Software Design and Solutions Pty Ltd. >Ph: 9505-6714 >Fax: 9505-6430 >Email: KP at SDSOnline.net > > -- Marty Connelly Victoria, B.C. Canada