Can't find stored proc 'CONTACT' when

Results 1 to 2 of 2

Thread: Can't find stored proc 'CONTACT' when

  1. #1
    Weaver Guest

    Default Can't find stored proc 'CONTACT' when

    HELP! <BR><BR>I get the error<BR><BR>[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure &#039CONTACT&#039. <BR><BR>However, I&#039m trying to hit the TABLE &#039CONTACT&#039 (MSQL 2000) and NOT a stored proc!!<BR><BR>Portion of code causing prob.. <BR><BR>set objRS = Server.CreateObject("ADODB.Recordset")<BR>objRS.Op en "CONTACT", "DSN=Unisys;UID=sa;Password=;",_<BR> adOpenForwardOnly<BR> <BR>objRS.AddNew<BR>objRS("sFirstNm")=sFirstNm <BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Can't find stored proc 'CONTACT' w

    two things<BR><BR>include the argument adCmdText (or i think in this case, adCmdTable) at the end of the open call (it&#039s the fifth argument, if you&#039re wondering)<BR><BR>and as far as i know, without checking, you can&#039t addnew on a recordset unless it&#039s adLockOptimistic (or one of the other updatable arguments.<BR><BR>jason

Posting Permissions

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