Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    10

    Unanswered: update with jet 4 and ado error

    I am trying to do a really simple update and keep getting errors whatever method I use.. (have also tried using the connection.execute to update)

    Set getEventMembers = Server.CreateObject("ADODB.Recordset")
    getEventMembers.ActiveConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\datetastic\Database\date tastic_database.mdb;Persist Security Info=False"
    getEventMembers.Source = "update customers set dt_customer_name = 'sib' where dt_customer_key = 2"
    getEventMembers.CursorType = adopenkeyset
    getEventMembers.CursorLocation = 2
    getEventMembers.LockType = adLockPessimistic
    getEventMembers.Open()

    I get an ASP Script Error window come up with the yellow exclamation mark triangle saying 'No value given for one or more required parameters'

    Please someone help, am at my wits end, I tried an update using the Dreamweaver GUI and its fine and looks no different to my handwritten code.

    Thanks in advance
    Many Thanks
    Siobhan

  2. #2
    Join Date
    Nov 2003
    Location
    Christchurch, New Zealand
    Posts
    1,618
    can you use ActiveConnection in that manner? I thought you had to specific a connection object rather then a string....

    you may have tried this already but... I'd suggest.....
    Code:
    Set myConn = Server.CreateObject("ADODB.Conenction")
    myConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\datetastic\Database\date
    tastic_database.mdb;Persist Security Info=False"
    myConn.Execute "update customers set dt_customer_name = 'sib' where dt_customer_key = 2"
    myConn.Close
    set myConn = nothing

Posting Permissions

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