MS SQL Server and WWW front-end 1

[TheInsider]

Hello,
Could someone give me some information as to what tools I would need to create a

http://WWW front-end/interface

for an SQL Server 7 database. I need to make a secure intranet that allows a select 20 clients to login to a database from remote locations via Internet Explorer or Netscape and interract with it. Are such tools included with MS SQL Server 2000?

One other question; If I purchase SQL Server 7 or 2000 with a 25 client/CAL license, are all of the tools included to develop a database... tables, queries, forms...etc. If so; Why is there a Developer Edition of SQL Server as well? What version of SQL Server comes with Visual Studio 6?

I have not yet purchased any software. I am currently doing the research, so that I can come up with a system plan and a price. You will have to excuse my inexperience, this is new to me. Any input would be appreciated.
Thanks in advance, Rob Marriott
rob@career-connections.net

 

[palbano]

Could someone give me some information as to what tools I would need to create a

http://WWW front-end/interface

for an SQL Server 7 database. I need to make a secure intranet that allows a select 20 clients to login to a database from remote locations via Internet Explorer or Netscape and interract with it.

Ok, that's a little confusing.
"secure intranet" That doesn't have anything to do with a web server or sql server.

You can create secure pages in IIS using Domain accounts fairly easily and both IE and NS support the login dialog boxes natively.

Interacting with the database can be done using OLE DB / ADO connections from ASP pages. You actually have quite a wide variety of techniques and designs you can use. Even more if you use the new .NET servers and .NET Visual Studio.


Are such tools included with MS SQL Server 2000?
No

One other question; If I purchase SQL Server 7 or 2000 with a 25 client/CAL license, are all of the tools included to develop a database... tables, queries, forms...etc. If so; Why is there a Developer Edition of SQL Server as well?
That is a redistributable engine so you can support SQL Server desktop edition from a commercial application.

What version of SQL Server comes with Visual Studio 6?

The developer edition

Thanks in advance,

Your welcome in advance... is it in advance? I guess not. CCTC1 you've messed up my whole space time continuim B-)

Hope this helps
-pete

 

[TheInsider]

Thanks, that information helps. I am really in a new area here. Rob Marriott
rob@career-connections.net