RDS and MSRemote

From: Edward (ECevallos_at_aol.com)
Date: 03/22/04

  • Next message: Picine Karppehd: "Efficiency" 
    Date: Sun, 21 Mar 2004 17:06:06 -0800

    I currently have a few databases which are snapshots of our AD environment, from which we can run reports based on different queries. My problem is that I'm currently developing a page to access all event logs from the domain controllers which are fed to a SQL database. I'm trying to retrieve a disconnected recordset from the server and pass it to the client so if I say sort by eventcode I don't have to hit the server again for the new query. I've seen different posts about using RDS/MSRemote but have also found that they are obsolete. My question is, are there other technologies that I can use for retrieving remote data from an Access/SQL database without having to requery the server for any criteria selections made by the client> No data is being updated here so returning the recordset to the server is of no concern to me. I've looked into SOAP but it seems like it will also become obsolete 7/1/04 to make way for WebServices. Is XML the only way I can do this without opening security holes? Also, I've tr
    ied RDS and MSRemote and I keep getting this "Internet Server Error" everytime it tries to connect to the server. I researched the MSADC directory and registered unsafe handling as well as created the virtual directory. No luck. Could someone please provide some assistance? Thank you in advance!

  • Next message: Picine Karppehd: "Efficiency"