Creating a Web page with SQL Server in SBS 2003 [Windows Small Business Server 2003 Best Practice]

Howdy y’all – I have been very busy this week and I might have missed a daily “virtual book reading” by missing a day where I was to post up a passage. Oh my! So here is your fix => SQL and the Web page!

Advanced SQL: Publishing a Web Page

Now for some fun to wrap up this chapter on SQL Server 2000. Perhaps you didn’t know-but you certainly will in just a few paragraphs-that your SQL-based data can easily be published as a Web page. This is actually one of the cooler features of SQL Server 2000 and very practical when you might want to publish information, such as real estate listings and product inventory sheets.

Publishing SPRINGERS data to a Web page

1                    Log on to the SBS server machine as Administrator with the pass­word Husky9999!

2                    Click Start, All Programs, Microsoft SQL Server, Enterprise Manager.

3                    Expand the following objects in the left pane: Microsoft SQL Serv­ers, SQL Server Group, SPRINGERS1 (Windows NT).

4                    Select and expand the SSLDOG database.

5                    From the Tools menu, select Wizards. The Select Wizard dialog box appears.

6                    Expand Management under Please select the Wizard you wish to use:.

7                    Select Web Assistant Wizard and click OK.

8                    The Welcome to the Web Assistant Wizard screen of the Web Assistant Wizard appears. After reading the welcome notice, click Next.

 

 Visit http://www.microsoft.com/technet for the latest updates for any Microsoft product.

14-28

Section 4 SBS 2003 Premium Edition

9.         On the Select Database screen, select SSLDOG in the drop-down list of databases in the Database name: field. Click Next. This is shown in Figure 14-12.

Figure 14-12

Selecting the SSLDOG database from the list of databases is an important step.

Notes:

10.       On the Start a New Web Assistant Job screen (see Figure 14-13), accept the default database name of SSLDOG Web Page in the What do you want to name this Web Assistant job? field. Accept the default selection under What data do you want to publish to the table on the Web page? of Data from the tables and columns that I select (this is a radio button). Click Next.

Figure 14-13

Completing the Start a New Web Assistant Job.

Notes:

 Visit http://www.microsoft.com/technet for the latest updates for any Microsoft product.

11.       On the Select a Table and Columns screen, select the Tracking table (which is the default selection) in Available tables:. Click the Add All button so the columns initially listed under Table columns move over to Selected columns. Your screen should look similar to Figure 14-14. Click Next.

Figure 14-14

Selecting the table and columns to use in the Web page.

12.       On the Select Rows screen, accept the default selection of All of the rows under Which rows from the table do you want to publish to the Web page?. Click Next.

Notes:

13.       On the Schedule the Web Assistant Job screen, accept the selection Only one time when I complete this wizard under When should the Web Assistant update the Web page? Note that this screen allows you to select the frequency the Web pages would be updated with data from SQL Server, as detailed in Figure 14-15. Click Next.

Figure 14-15

You can specify how often the Web page is updated with database information.

 

14.       Accept the default file path and name of C:\Program Files\Microsoft SQL Server\80\Tools\HTML\WebPage1.htm in the File name: field of the Publish the Web Page screen. Click Next.

 

15.       On the Format the Web Page screen, accept the default select of Yes, help me format the Web page and click Next.

 

16.       The Specify Titles page appears. Under the What do you want to title the Web page? field, type SPRINGERS Dog Registration Tracking Database. Under the What do you want to title the HTML table that contains the data? field, type AKC Registration

 

 Visit http://www.microsoft.com/technet for the latest updates for any Microsoft product.

Numbers. Accept the default setting of H3 – Large in the What size should the HTML table title font be? field. Click Next.

 

17.       On the Format a Table screen, accept the default settings of Yes and display column names under Do you want column names displayed in the HTML table?. Accept the Fixed selection under What font characteristics do you want to apply to the table data? and keep the Draw border lines around the HTML table check box selected. Click Next.

 

18.       On the Add Hyperlinks to the Web Page screen, accept the default selection of No under Do you want to include hyperlinks on your Web page?. Select Next.

 

19.       The Limit Rows screen appears. Accept the default selection of No, return all rows of data under Do you want to limit the total num­ber of rows returned by SQL Server?. Accept No, put all data in one scrolling page under Do you want to limit the number of rows displayed on each Web page?. Click Next.

 

20.       Click Finish on the Completing the Web Assistant Wizard screen after reviewing the summary information.

 

21.       Click OK when the Web Assistant Wizard – SPRINGERS1 dialog box appears informing you that the Web Assistant successfully com­pleted the task.

 

22.       You will now view the Web page you just created. Launch Internet Explorer by clicking Start, Programs, Internet Explorer.

 

23.       When Internet Explorer appears, select File, Open. Navigate by click­ing the Browse button to the file location specified in Step 14 above. This file in the File Name field of the Microsoft Internet Explorer dialog box (which appears when you click Browse) should be:

 

C:\Program Files\Microsoft SQLServer\80\Tools\HTML\ WebPage1.htm. Click Open.

24. Click OK when you return to the Open dialog box.

Notes:

25.       The Web page showing the AKC Registration Numbers for SPRING­ERS appears, as seen in Figure 14-16. Close Internet Explorer after you’ve observed the Web page. Close the SQL Server Enter­prise Manager.

Figure 14-16

Viewing SPRINGERS data in a Web browser.

 

cheers…harrybbbb

Harry Brelsford, CEO at smb nation www.smbnation.com

Microsoft Small Business Specialist SBSC, MBA, MCSE, MCT, MCP, CNE, CLSE, CNP

PS – did u know I host a technology conference in the New York City area each spring? Save the date for March 6-8, 2009 and watch “voice meet data” in the SMB space!

PPS – my SBS 2008 book will be out in mid-November 2008!

PPPS – my Microsoft Response Point Primer book is here NOW!

Advertisements

Leave a comment

Filed under Book

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s