MS Remote - Access (Jet)
 
oConn.Open “Provider=MS Remote;” & _
           “Remote Server=http://myServerName;” & _
           “Remote Provider=MSDASQL;” & _
           “DSN=AdvWorks;” & _
           “Uid=myUsername;” & _
           “Pwd=myPassword”
 
oConn.Open “Provider=MS Remote;” & _
           “Remote Server=http://myServerName;” & _
           “Remote Provider=Microsoft.Jet.OLEDB.4.0;” & _
           “Data Source=c:somepathmydb.mdb”, _
            “admin”, “”
 
 
oConn.Open “Provider=MS Remote;” & _
           “Remote Server=http://myServerName;” & _
           “Handler=MSDFMAP.Handler;” & _
           “Data Source=MyAdvworksConn”
 
MS Remote - SQL Server
 
oConn.Open “Provider=MS Remote;” & _
           “Remote Server=http://myServerName;” & _
           “Remote Provider=SQLOLEDB;” & _
           “Data Source=myServerName;” & _
           “Initial Catalog=myDatabaseName;” & _
           “User ID=myUsername;” & _
           “Password=myPassword”
 
oConn.Open “Provider=MS Remote;” & _
           “Remote Server=http://myServerName;” & _
           “Handler=MSDFMAP.Handler;” & _
           “Data Source=MyPubsConn”