Ô¶³ÌÁ¬½ÓMS AccessÊý¾Ý¿â

»·¾³£º

XPSP2 + IIS + .Net 3.5 + VS2008


´úÂ룺

        Dim connectionString As String = _
              "Provider=MS Remote;" & _
              "Remote Server=http://127.0.0.1;" & _
              "Remote Provider=Microsoft.Jet.OLEDB.4.0;" & _
              "Data Source=F:\tmp\1.mdb;Persist Security Info=False"

        Me.dataAdapter = New OleDbDataAdapter("select * from t1", connectionString)

        Me.dataAdapter.Fill(ds, "my_table")  <- Exception


´íÎóÐÅÏ¢£º

System.Data.OleDb.OleDbException was unhandled
  ErrorCode=-2146819841
  Message="Internet ·þÎñÆ÷´íÎó¡£"
  Source="Microsoft ADO/RDS"

---

Õâôд¶ÔÂð

        Dim sDatabaseFile As String = "http://127.0.0.1\tmp\1.mdb"
        Dim connectionString As String = _
            "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & sDatabaseFile & ";User Id=admin;Password=;"