Access 2007 connection string

Discussion in 'Classic ASP' started by Judy, Sep 22, 2010.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. I am connecting to my database with this string:
    strconnWOI = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & Server.MapPath("/_database/nameofmydatabase.accdb")
    which, then I response.write out shows the correct database location.

    However, when I use these commands to open:
    set rs = Server.CreateObject("ADODB.recordset")
    set rs = strconnWOI.execute("Select * FROM Participants WHERE Login = '" & Login & "'")

    I get an error:
    Microsoft VBScript runtime error '800a01a8'
    Object required: 'Provider=Microsoft.A'

    I have converted this database from an Access 2003 database that was working with the old Access2003 connection string.

    What am I doing wrong?

    Judy
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page