Sql Data type text/ntext

Results 1 to 3 of 3

Thread: Sql Data type text/ntext

  1. #1
    Join Date
    Dec 1969

    Default Sql Data type text/ntext

    Anybody have an idea why I can&#039;t read data types text of ntext from a sql database using an ASP page. I keep getting an error:<BR>Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)<BR>Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.<BR><BR>Error goes as soon as i change to varchar or nvarchar, but i need a field that can handle a bit more that 8000 characters. I will be very greatful for any help

  2. #2
    Join Date
    Dec 1969

    Default RE: Sql Data type text/ntext

    I believe the text/ntext field has to be either <BR>a. the only field in your select list<BR>b. the last field selected in your select list.<BR><BR>Do some response.writing of <BR><BR>Err.number<BR>Err.location<BR>Err.source <BR><BR>to see if you can uncover some other information<BR><BR>mj

  3. #3
    Join Date
    Dec 1969

    Default Uh Oh..

    Try reading the fields in the same order as they are in the database, failing that try reading only the text field without reading the other fields.<BR><BR>This is a known bug.

Posting Permissions

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