This error message is about as useless as a boar hog on ice skates as I can't find anything that explains what this means.

Has anyone run into this before? How did you figure it out?


Here's what happened.
Modified a stored proc, saved it and executed it - executed with no errors.

Try to call it from VFP and I get this error.

AError returns
1) 1526
2) "Connectivity error.[Microsoft][ODBC SQL Server Driver]Associated statement is not prepared"
3) [Microsoft][ODBC SQL Server Driver]Associated statement is not prepared"
4) "S1007"
5) 0
6) 1
7) .NULL.

SP is as follows

USE [TestingExpECL]
GO
/****** Object:  StoredProcedure [dbo].[UpdateMaster]    Script Date: 12/07/2012 10:55:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Dorrie Beaird
-- Create date: November 2012
-- Description:	Updates Experimental Master Record
-- =============================================
ALTER PROCEDURE [dbo].[UpdateMaster]
  @MasterID int,
  @Cat		nchar(2),
  @DL		nchar(1),
  @ALC		nchar(3),
  @Key1		nvarchar(max),
  @key2		nvarchar(max),
  @CR		nchar(1),
  @Script	                nvarchar(max),
  @Stem		nvarchar(max),
  @RA		nvarchar(max),
  @RB		nvarchar(max),
  @RC		nvarchar(max),
  @RD		nvarchar(max),
  @ST		int,
  @EN		nvarchar(max),
  @IS		bit,
  @RevB		nchar(3),
  @RevD		date,
  @CO		bit
  	
AS
BEGIN
  declare @iError int, @iRowCnt int
  SET NOCOUNT ON;
  begin transaction
  update [TestingExpECL].[dbo].[ExpMaster] set
    [Category] = @Cat,[DiffLet] = @DL,[alc] = @ALC,[Keyword] = @Key1,
    [Keyword2] = @Key2,[CorrectResp] = @CR,[Script] = @Script,[stem] = @Stem,
    [RespA] = @RA,[RespB] = @RB,[RespC] = @RC,[RespD] = @RD,[ScriptTime] = @ST,
    [EnterNotes] = @EN,[IncSave] = @IS,[ReviewedBy] = @RevB,[ReviewDate] = @RevD,[Completd] = @CO
    where XPID = @MasterID
  if @iError > 0
    begin
      raiserror('Error on Master Update -  %d',16,1, @iError) 
      rollback transaction
    end
  commit transaction
END

My parameter statements are as follows:

  m.param1 = "?EditRec.XpID,?EditRec.Category, ?EditRec.DiffLet, ?EditRec.ALC, ?EditRec.Keyword, ?EditRec.Keyword2, " + ;
       "?EditRec.CorrectResp, " 
  m.param2 = "?STRTRAN(EditRec.Script, CHR(13), '/n'), ?STRTRAN(EditRec.Stem, CHR(13), '/n'), ?EditRec.RespA, " + 
       "?EditRec.RespB, ?EditRec.RespC, ?EditRec.RespD," 
  m.param3 = "?EditRec.ScriptTime, ?STRTRAN(EditRec.EnterNotes, CHR(13), '/n'),  ?IIF(EditRec.IncSave, 'True','False'), ?null," 
  m.param4 = " ?null,  ?'False'"