help PLEASE...Object required: 'Driver={Micros

Results 1 to 2 of 2

Thread: help PLEASE...Object required: 'Driver={Micros

  1. #1
    Join Date
    Dec 1969

    Default help PLEASE...Object required: 'Driver={Micros

    Microsoft VBScript runtime error &#039 800a01a8&#039 <BR><BR>Object required: &#039Driver={Microsoft Ac&#039 <BR><BR>CentralAModifierForm.asp, line 15 <BR>i have this error when i do:<BR><BR>dim rsCentraux, sql, strNXXR<BR> strNXXR = Request.QueryString("Action")<BR> set rsCentraux = Server.CreateObject("ADODB.Recordset")<BR> sql = "SELECT * FROM CENTRAUX_418_450_514_819_theoriques _<BR> WHERE NOM_CENTRAL = &#039" & Request("CENTRAUX") & "&#039 AND FRAME_NXXR = &#039" & Request("Action") & "&#039;"<BR> Response.Write "SQL is " & SQL & "<BR>" & vbNewLine<BR> strConnect.Execute( SQL )<BR> Response.Write "SQL is " & SQL & "<BR>" & vbNewLine<BR> strConnect.Execute( SQL )<BR><BR><BR> rsCentraux.Open sql, strConnect, adOpenForwardOnly, adLockOptimistic, adCmdTable<BR> %&#062;<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: help PLEASE...Object required: 'Driver={Mi

    You&#039re trying to use a connection STRING as a connection OBJECT. The connection string simply describes how to connect, it&#039s the connection object that actually knows how to talk to the database. You might want to review your ADO basics.<BR><BR>BTW, your SQL isn&#039t going to change no matter how many times you execute it.<BR><BR>Dunc

Posting Permissions

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