Re: web and databases

Russ Hensley wrote: > > Franco Scarselli wrote: > > > > Hi, > > > > I am going to restructure the informatic organization of an association. > > A part of the work requires the introduction of a Windows NT server that > > should contain administration and medical data. I think to use a DBMS > > among Microsoft SQL server, Oracle SQL server and Sybase SQL server. > > > > I have to rewrite all the (few) existing applications. I thought about a > > common interface to use. What about writing interfaces by HTML documents > > ? That is, I would use a WEB server to produce interfaces for ALL the > > applications that use the database, that is for ALL the applications > > that are used in the association. > > > > Which are pros and cons of such a solution ? Are there security > > problems ? Are there examples of this approach ? > > > > I thank in advance anybody who can help me. > > > > Franco > > Franco, > > You should look into Microsoft SQL Server 6.5 that is due for release > really soon. It has built in functions to receive SQL query parameters from > the internet via a HTML interface to the SQL Server. The Server builds the > HTML interface for the return data and KAPOW instant internet access. Even > though I have not implemented this software I have been to a Microsoft > seminar where they demonstrated the piece and it seemed to be a good > solution. > > laterBe careful betting your application on web technology. Pay careful attention to user interface details, determine how complex the dialogue should be. Web pages - even with forms and JAVA trinkets - are still very simple interfaces.