I have the following code trying to connect to an access DB.

     set conn=server.CreateObject("ADODB.Connection")


     conn.Open " Provider=MS Remote;Remote Server=hps-amgsolp08;Remote Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Z:\Nirvana\Nirvana.mdb;"

     set rs=server.CreateObject("ADODB.recordset")
     rs.CursorLocation=3

I am getting an error on the following line.

     rs.Open "select received_dt from ordermgr_srvc_notification_item_fact",conn


The error is " ADO/RDS (0x800A1004)Business object cannot be created."



Please let me know how I can proceed on this.Thanks

Try this...

conn = "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;"

sql = "select received_dt from ordermgr_srvc_notification_item_fact"
rs.Open sql, conn
if not rs.eof then
    do while not rs.eof
        response.write rs("received_dt") & "<br>"
    rs.movenext
    loop
end if
rs.close
set rs = nothing

I thought that in order to use the CreateObject method within an ASP page, you would have to specify a second argument with the server URL string where the Business Object resides. In the case above, the CreateObject call would be as follows:
 set rs=server.CreateObject("ADODB.recordset", strServer)

strServer is a literal or variable with the URL to the IIS WebSite where the MSADC virtual directory exists.

I am experience difficulty with ASP.NET 2.0 compiled DLLs working via RDS with IIS 6.0 (Win2K3 server)