Problem in updating an SQL table

Results 1 to 2 of 2

Thread: Problem in updating an SQL table

  1. #1
    Zia Guest

    Default Problem in updating an SQL table

    Hi,<BR>I am doing my univeristy assignment and having problems in updating an SQL database using ASP.<BR>Following is the code and the error message i am getting, and i have absolutely no idea why its treating adOpenDynamic and adLockPessimistic as variables.<BR>I need help ASAP. Thanx<BR><BR>CODE:<BR><BR>Set objConn = Server.CreateObject("ADODB.Connection")<BR> strConnection = "driver={SQL Server}; server=ISESERVICES; uid=EC5457; pwd=u5457; database=TastyDelights"<BR> objConn.Open strConnection<BR> <BR> Set cusRS = Server.CreateObject("ADODB.Recordset")<BR> <BR> strQ = "select * FROM [ISEu981157].customerFBI "<BR> cusRS.Open strQ, objConn, adOpenDynamic, adLockPessimistic<BR><BR><BR>ERROR MESSAGE :<BR><BR>Microsoft VBScript runtime error &#039 800a01f4&#039 <BR>Variable is undefined: &#039adOpenDynamic&#039 <BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Problem in updating an SQL table

    adOpenDynamic and adLockPessimistic ARE variables<BR><BR>search your computer for a file<BR><BR>these are actually numbers, so it should say something like , , 1, 3 [ those aren&#039t the real ones, I don&#039t remember the numbers]<BR><BR>once you find, do a line:<BR><BR>&#060;!-- #INCLUDE file="" --&#062; <BR><BR>before the code<BR><BR>once you include this file, your above code should work<BR>

Posting Permissions

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