Displaying SQL Server data in HTML pages

[StevenK]

This is probably a simple issue to those in the know - but not something I've had the need to do as yet. I'm looking at displaying data from a SQL Server 7.0 database on a page on our intranet - through HTML. How do I achieve this ?
I'm guessing I'm looking at using an ODBC connection and an ActiveX control or am I missing the ball on this one ?
Thanks in advance
Steve

 

[rodfiuza]

You need to use a script language like asp or php to do it, you cannot do it directly in html. For this you will need to setup the IIS. Look the web for asp tutorials.

 

[AshleyRickards]

Look at using the Web Publishing Wizard. It will export your tables or views to HTML tables and will allow you to select how to update the HTML tables, similar to replication. Ashley L Rickards
SQL DBA

 

[aalmeida]

I think the ease way for you is to use the Web publisher that comes with SQL Server 7, unless you have the time to Learn more technologies, then I would sugest you to look into Macromedia Dreamwever Ultradev where the learn curve is lower since it's drag and drop UI. AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"

 

[StevenK]

As daft a question as it might sound : where is the Web Publisher Wizard found ?
Thanks in advance.
Steve
(There's no such thing as stupid questions - just stupid people)

 

[aalmeida]

Enterprise manager and it is calle Web Wizard AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"