Tuesday, November 20, 2007

How to Access SQL Server from browser (it can be done through "Configure XML Support for SQL Server")

How to Access SQL Server from browser (it can be done through "Configure XML Support for SQL Server")

T Access SQL Server from browser (it can be done through "Configure XML Support for SQL Server")

Step 1

To start XML Support for MSSQL Server, first you need to go to Program Files after that, click on the MS SQL Server. Next, you need to choose Configure XML Support for SQL Server.

Step 2

After that, you need to enter the Northwind as the virtual directory name. It can be any other name and provide the path where the virtual directory will be placed.

Step 3

Please note that the name Northwind must be the same as the one that you will be using to pass the query to. Next, you need to click on Security Tab.

Step 4

We will use SQL server SA to login to SQL Server. After that, you need to click on Data Source tab.

Step 5

Under the Database section, you need to choose Northwind as the database. Next, you ought to click on Setting tab and check Allow URL queries. Then, Allow template queries, Allow Xpath, Allow Post.

Step 6

Under define virtual name, you have to click the New option.

Step 7

Then setup the 2 objects here, which is the schema and dboject. First select Schema and then provide the path to it. We will use a schema folder under Nwind folder.

Step 8

Now, you need to click Save and we will setup DBOBJECT.

Step 9

You need to click Save and Apply when you have done. The newly created virtual directory will look something like this.

Step 10

To test it, open your IE browser and then pass the following string over to it.

http://compact/northwind?sql=SELECT+*+FROM+Employees+FOR+XML+AUTO&root=root

Edited By: Norasyikin Mahmud

© 2001 ISC/Inner Esteem

All rights reserved. All other product names and trademarks are registered properties of their respective owners.

301001


How to use compression in IIS 5.0

How to use compression in IIS 5.0

To use compression in IIS 5.0

Step 1

To use compression for IIS 5.0, first you need to go to Start and click Programs and after that select Administrative Tools and IIS. Later, you need to click on Edit.

Step 2

Now, you ought to choose Service tab and click on compress static file.

Step 3

Now, you have to click on Apply and then OK.

How to set CGI time out period

How to set CGI time out period

To set CGI time out period

Step 1

To increase or reduce a CGI timeout script all you need to do is to go to Start and choose Programs. After that, you need to click on the Administrative Tools and IIS. Under the IIS manager, right click on your computer and choose Properties.

Step 2

Another screen will appear as shown in the diagram below.

Step 3

Now, you need to click on the Configuration.

Step 4

Later, under the CGI configuration, change CGI timeout settings.

How to set Expiration Policy for newsgroup

How to set Expiration Policy for newsgroup

To set Expiration Policy for newsgroup

Step 1

User can set an expiration data for newsgroup. To do this, first you need to go to Start and click Programs. After that, click Administrative Tools and choose IIS. Later, you need to go to Default NNTP server and right click on it. Next, go to New and choose Expiration Policy.

Step 2

Next, another window similar to the one shown below will appear.

Step 3

Then choose Only selected newsgroup on this virtual server and click Next to continue.

Step 4

Next, you need to enter POLEC that we have created earlier.

Step 5

Next, enter the value 720 and click Finish when you have done.

What does a metabase do?

Metabase to IIS 5.0 is what registry is to MS Windows. It is located at %SystemRoot%\system32\inetsrv.