Using Remote Data Provider with JET provider

From: Strider (Strider_at_invalid_address.com)
Date: 07/21/04

  • Next message: Captain Cabbage: "Determining version of MDB file" 
    Date: Wed, 21 Jul 2004 13:58:20 +0200

    Hello group,

    I am trying to use the JET provider remotely using the Remote data provider,
    here is my VBS code:

    set rs = CreateObject("ADODB.Recordset")
    set cn = CreateObject("ADODB.Connection")

    'Open connection (succeeds)
    cn.Open "Provider=MS Remote;Remote Server=[ip of local
    machine];RemoteProvider=Microsoft.Jet.OLEDB.4.0;Data Source=[path to MDB
    file]"

    ' Open Table
    ' Fails
    rs = cn.execute("[Table Name]", 0, 2)

    The error I am getting is:

    Microsoft ADO/RDS: Business object cannot be created.

    Two questions:
    Can the OLEDB Remove provider be used with JET provider?
    If yes, what I am doing wrong?

    Thanks Guys,

    Strider

  • Next message: Captain Cabbage: "Determining version of MDB file"