Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    4

    Unanswered: Access database connection ...

    Hello all,

    i have difficulties to access data, which is in my desktop, from my laptop
    under is my code:

    'adoCon.Open "Provider=SQLOLEDB; DRIVER={Microsoft Access Driver (*.mdb)}; Data Source=192.168.0.117; DBQ=" & Server.MapPath("Tables.mdb") & ";"

    i got error like this:

    error typeˇG
    Microsoft OLE DB Provider for SQL Server (0x80004005)
    invalid connection string

    can any one give me some suggestion

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Try something like:

    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\iissamples\sdk\asp\database\Auth ors.mdb;Persist Security Info=False"

    Your provider is referencing the sql server oledb provider not access.

  3. #3
    Join Date
    Jan 2004
    Posts
    4
    Thanx rnealejr,

    i just succeed this morning, and here is my example, which can share with u guys as an example...^^

    adoCon.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
    "Data Source=\\IP_address\...file_path\Tables.mdb;" & _
    "Jet OLEDBatabase Password=my_password;"

    the other question is:

    Is it possible to read mdb file while that file is openned...??

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •