Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004

    Thumbs up Unanswered: Data type of parameter passing to a stored procedure

    I pass a paramter of text data type in sql server (which crosspnds Memo data type n Access) to a stored procedure but the problem is that I do not know the crossponding DataTypeEnum to Text data type in SQL Server.

    The exact error message that occurs is:

    ADODB.Parameters (0x800A0E7C)
    Parameter object is improperly defined. Inconsistent or incomplete information was provided.

    The error occurs in the following code line:
    .parameters.Append cmd.CreateParameter ("@EMedical", advarwchar, adParamInput)

    I need to know what to write instead of advarwchar?
    Thanks in advance

  2. #2
    Join Date
    Feb 2004
    1) memo and varchar isn't the same!
    2) you should specify a size for varchar type!
    .parameters.Append cmd.CreateParameter ("@EMedical", advarwchar, adParamInput, 1000)
    or other size instead of 1000
    MDB, ADP <-> MS SQL + VBA, ADO & RDO, .NET, Oracle, Java/Jsp.

Posting Permissions

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