PRB: Upgrading to RDS 2.x from RDS 1.x May Break Applications (231343)

The information in this article applies to:

Remote Data Service for ADO
Remote Data Service for ADO 1.1
Remote Data Service for ADO 1.5
Remote Data Service for ADO 2.0
Remote Data Service for ADO 2.01
Remote Data Service for ADO 2.1
Remote Data Service for ADO 2.1 SP1
Remote Data Service for ADO 2.1 SP2
Remote Data Service for ADO 2.5
Remote Data Service for ADO 2.6
Remote Data Service for ADO 2.7

This article was previously published under Q231343

SYMPTOMS

After upgrading from Remote Data Services (RDS) 1.x to version 2.0 or later, your application may report the following error:

Error: The specified Handler has denied Access.

CAUSE

With the advent of version 2.0, RDS implements a new security feature called Handlers. When Handlers are enabled, any unknown Connection string is rejected (the default behavior of the Handler.) An unknown connection string is defined as any connection string not in the MSDFMAP.INI handler file located in the Operating System Root Directory (C:\WINNT for example.)

RESOLUTION

Handlers can be disabled by running;

"C:\Program Files\Common Files\System\msadc\Handunsf.reg"

After running the Handunsf.reg file, the computer must be rebooted in order for the changes to take effect.

This method is NOT RECOMMENDED. Handlers are not difficult to administer. See the REFERENCES section below for more details.

STATUS

This behavior is by design.

REFERENCES

Using the Customization Handler Feature in RDS 2.0

For more information, please see the following articles in the Microsoft Knowledge base:

230680 INFO: Working with RDS Handlers

251122 Troubleshooting Common Problems with Remote Data Services

Modification Type:	Minor	Last Reviewed:	8/19/2005
Keywords:	kbDatabase kbprb KB231343