Hi Friends


Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] error
/Shopping1/shop$db.asp, line 312

I am getting this particular error in my asp file.

Sub UpdateContact()
Dim dbc
' on error resume next
     ShopOpenDatabase dbc
     Set objRS = Server.CreateObject("ADODB.Recordset")
      objRS.open "Customers", dbc, adOpenKeyset, adLockOptimistic
' CheckError
    objRS.AddNew
    objRS("Firstname") = strFirstname
    objRS("Lastname") = strLastname
    objRS("Address") = strAddress
    objRS("City") = strCity
    objRS("State") = strState
    objRS("PostCode") = strPostCode
    objRS("Country") = strCountry
    objRS("Company") = strCompany
    objRS("Phone") = strPhone
    objRS("Workphone") = strWorkphone
    objRS("Mobilephone") = strMobilephone
    objRS("Fax") = strFax
    objRS("Email") = strEmail
        If strwebsite <>"" then
            objRS("website") = strwebsite
        end if
312: objRS.Update :(:(
        ShopCloseDatabase dbc
' ShopOpenDatabase
        LocateCustomer strLastName, strEmail
        Session("customerid") = strCustomerID

 ' CheckError
end sub

Can anybody solve my problem...

This is NOT an ASP.NET question. This is classic ASP, so you are posting in the wrong forum.

Having said that: The first thing to try, I think, is to replace your use of the Access Driver with the JET OLE DB driver.

Look here:
http://www.carlprothman.net/Default....orMicrosoftJet

If you can't figure it out from that, then post your code that makes the connection...but in the "Classic ASP" forum this time.

p.s.: Unfortunately, that error message can happen for many many different reasons. It's about the least informative of all the many bad MS error messages.

p.p.s.: And this is an inefficient way to add a new record. But let's work on that after you try changing the connection code. That will be in your ShopOpenDatabase SUB, by the by.