Microsoft KB Archive/250809

= "Unexpected Error" Occurs When You Use RDS Through SSL =

Article ID: 250809

Article Last Modified on 11/4/2002

-

APPLIES TO


 * Microsoft Internet Explorer 5.0

-



This article was previously published under Q250809



SYMPTOMS
When you use Remote Date Services (RDS) with an Internet Explorer 4.01 client to request data from a secure Web site that is using Secure Sockets Layer (SSL), the following error message may appear:

Microsoft ADO/RDS 2.1 error '80004005' Unexpected error (0x80004005)



CAUSE
This problem results when the Web server has Internet Explorer 5.0 installed and the client is using Internet Explorer 4.01.



WORKAROUND
To work around this problem, upgrade the client to Internet Explorer 5.0.



STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.



Steps to Reproduce the Behavior
 Install Internet Explorer 5.0 on a Web server. Configure Internet Information Server (IIS) to support SSL by installing a certificate on the server. For more information on how to do this, consult the IIS documentation or see the link in the "References" section of this article. Set up a Web application to use SSL. Right-click the application in the Internet Services Manager and select Properties. Select the Directory Security tab. In the Secure Communications section, click Edit. Select Require Secure Channel and Do Not Accept Client Certificate.  Insert the following code into a new ASP page, and then save the page to a folder in the Web application that is configured to use SSL. Modify the connection string and query string as necessary. <%@ Language=VBScript %> <%   Dim cn, rs    Set cn = Server.CreateObject("ADODB.Connection") Set rs = Server.CreateObject("ADODB.Recordset") cn.Open "Provider=MSRemote;Remote Server=https://MyWebServer;Server=MyDBServer;Database=pubs;PWD=sa;UID=;" rs.Open "SELECT * FROM Authors", cn   While Not rs.EOF Response.Write rs(0) & "" rs.Movenext Wend rs.close cn.Close Set rs = Nothing Set cn = Nothing %>                    Use Internet Explorer 4.01 to browse to the page from a client.</li></ol>