Re: RDS and MSRemote

From: Brian Muth (bmuth_at_mvps.org)
Date: 03/22/04

  • Next message: Holt: "Proxy between VB6 ADO and ADO.Net"
    Date: Mon, 22 Mar 2004 10:36:25 -0800
    
    

    I may have misread your OP. If you are just trying to access the database
    directly, can you not just use ADO or ADO.NET? If you need to traverse
    firewalls, then Web Services would be the way to go...

    Brian

    "Brian Muth" <bmuth@mvps.org> wrote in message
    news:eLCIiTDEEHA.3424@tk2msftngp13.phx.gbl...
    > Do you need to traverse firewalls? This is an important question. Both RDS
    > and Web Services are essentially technologies meant to to be firewall
    > friendly. I assume this is not a requirement since I'm pretty sure you
    would
    > have mentioned it otherwise.
    >
    > If not, then I would strongly suggest using WMI. This is very friendly
    from
    > a scripting point of view, and very powerful. If you visit
    > http://www.microsoft.com/technet/community/scriptcenter/default.mspx you
    > will see lots of examples of how this technology works.
    >
    > HTH
    >
    > Brian
    >
    > "Edward" <ECevallos@aol.com> wrote in message
    > news:2D89B727-C8E4-4E27-8B10-8380BF0287C4@microsoft.com...
    > > 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 tried
    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: Holt: "Proxy between VB6 ADO and ADO.Net"

    Relevant Pages

    • Create SharePoint Portal failed.
      ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
      (microsoft.public.sharepoint.portalserver)
    • Re: ADO Connection Timeout
      ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
      (microsoft.public.data.ado)
    • Web Developers - Happy Hearts And HDTV! - Lockergnome
      ... Certificate on your MSIIS Web server. ... getting data from a database is only half the problem. ... Zend recently started a series about building rock solid code in PHP. ... which provides bulk database conversion. ...
      (freebsd-questions)
    • Config for OLTP system
      ... extrenal disks fo the 60GByte database server. ... IBM Informix Dynamic Server Configuration Parameters ... # BUFFSIZE - OnLine no longer supports this configuration parameter. ...
      (comp.databases.informix)
    • Re: TNS could not resolve the connect identifier
      ... This database resides on Machine A. ... The Web server is running on Machine B. ... Using tnsping is not as good as using a real connection such as via ... client (note that this is terminology that appears in the 10g R2 ...
      (comp.databases.oracle.server)