hi Mike,
[quoted text, click to view] Mike wrote:
> Hi All,
>
> How do I make use of SQL Express on a website?
>
> I am trying to make some first steps with SQL express and need some
> hand-holding. I have supported a plain-vanilla html website for some
> time and I am trying encourage the owners of the website to move to at
> least some database-related functionality that will relieve me of a
> lot of the day-to-day updates.
>
> The website is currently on Apache but can and must be moved to IIS if
> we want to use asp (or any db/scripting) (they do not support php and
> won't allow me to use their Oracle db). They suggested that if we
> move to the IIS server I would have to use an Access db as that can be
> deployed in isolation with the app.
>
> Is there any reason I cannot use SQL Express instead?
>
> I apologize for my ignorance as I typically just deal with application
> development and don't manage much on the database side other than
> connecting.
>
actually there's no reason you can not move to SQLExpress... obviously do
protect the database server.. do not directly expose it to the Internet as
IIS should be the only connection point...
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply