ADO Datatype problem

Results 1 to 2 of 2

Thread: ADO Datatype problem

  1. #1
    Join Date
    Dec 1969

    Default ADO Datatype problem

    Hi,<BR><BR>I am trying to insert some data into a table in MS SQL 2000 server. The column is of type &#039;text&#039; and I am using an ADODB.Command object and the Parameters collection.<BR><BR>The longest/largest datatype available appears to be adLongVarChar 8000. Is this correct or is there a &#039;text&#039; type?<BR><BR>So I currently use:<BR>.CreateParameter("@history", adLongVarChar, adParamInput, 8000, varTemp)<BR><BR>Is there anything available larger than adLongVarChar 8000?<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: ADO Datatype problem

    .CreateParameter("@history", adVarChar, adParamInput, 2147483647)<BR><BR>works for me!

Posting Permissions

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