Has anyone run across how to set up an ADO connection to a DSN (or OLE DB Provider) living on a LAN server? I have been able to get ADO working on an ODBC or OLE DB on my local machine, but not on the LAN server.

Thanks