0 Replies Latest reply on Aug 26, 2008 5:09 AM by Newsgroup_User

    Remote access to DB using ADOXtra.

    Level 7
      Hi everybody.

      I'm looking for an example of connection to a DB ".mdb" using Adoxtra.
      My program works perfectly on a CD but I have problems in my web server.
      Neither using direct connection no ODBC.

      If we call de DB: "mydb.mdb" , the DSN: "mydsn" and de domain name:
      www.mydomainname.com, this are de Connection strings I've tried:

      ---------
      connectionString="Provider=MS Remote; Data Source=mydsn; Remote
      Server=http://www.mydomainname.com; Remote Provider=MSDASQL.1; Internet
      Timeout=300000"
      ---------
      connectionString="DRIVER={Microsoft Access Driver(*.mdb)}; DBQ=mydb.mdb"
      ---------
      connectionString="Provider=MS Remote; Data Source=mydb.mdb; Mode=Read;
      Remote Server=http://www.mydomainname.com; Remote
      Provider=Microsoft.Jet.OLEDB.4.0; Internet Timeout=300000"
      ---------
      connectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=mydb.mdb"
      ---------


      Thank you from Spain.