>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

You can hard-code the connection string to your code or if using an OLEDB provider you can have a .udl file on the server that clients can read connection information from.