ADO and Client/Server

From: Powell Benedict (powell_at_nospam.sentient-software.com)
Date: 08/29/04

  • Next message: miyomo: "Re: How retrieve a field size?" 
    Date: Sat, 28 Aug 2004 23:08:54 -0400

    All,

    I have an ADO application the runs on a local machine with an Access
    database. Time to make it a little more robust and put my data in a SQL
    Server on the network.

    I have played around with DCOMConnection and can get a COM object running on
    the server feeding my client app data, etc., but how will this work with
    ADO? What's the ADO equivalent of DCOMConnection? Is that a valid question?

    Also, I have used the HTTPSVR.DLL (I think that's what it's called) to pass
    DCOM traffic through port 80 as HTTP traffic. This works well for WANs that
    have firewalls, what about something like that using ADO?

    Even some general 'read about xxxx' type responses would be great, code
    samples even better :)

    Thanks!!

    Powell

  • Next message: miyomo: "Re: How retrieve a field size?"