HOWTO: Use RDS From an IIS 4.0 Virtual Server

• Remote Data Service for ADO versions 1.5, 2.0, 2.01, 2.1, 2.1 SP1, 2.1 SP2

SUMMARY

When adding a second virtual server within Internet Information Server (IIS) version 4.0, you may see the following error:

8447 - Internet Server Error

MORE INFORMATION

In the following scenario the main server is called myserver and is located at this home directory:

   C:\InetPub\wwwroot 

   C:\vserver2 

1. Using Windows Explorer create a MSADC folder under C:\vserver2.



2. Using the IIS Management Console create a virtual directory called MSADC in myserver2. Point the MSADC directory to the C:\vserver2\msadc directory.



3. Copy the Msadcs.dll file into C:\vserver2\msadc.



4. The MSADC virtual directory should be given "Execute Access (Including Script)" permission. To do this, right-click the virtual directory and click properties. Select the virtual directory tab. Under Permissions, you will see the different permissions possible for the directory.

1. Copy the Adctest.asp and Ssdatb32.cab from the C:\Program Files\Common Files\system\msadc\samples folder to the myserver2 virtual directory root, C:\vserver2.



2. Change the IIS 4.0 properties of myserver2 to allow Script execution. To do this, right-click the Virtual Server myserver2 within the IIS Management Console and click Properties. Select the Home Directory Tab, and then set the "Application Settings Permission" to Script.



3. Access the Adctest.asp file from the browser:

   
         http://myserver2/adctest.asp 

REFERENCES

For additional information, please see the following article in the Microsoft Knowledge Base:

Q165180 How to Create a Virtual Server

http://www.microsoft.com/data/

Additional query words: kbdse kbconfig kbrds

Keywords : kbConfig kbRDS kbGrpMDAC
Version : WINDOWS:1.5,2.0,2.01,2.1,2.1 SP1,2.1 SP2
Platform : WINDOWS
Issue type : kbhowto