Results 1 to 2 of 2

Thread: ITXpert

  1. #1
    Steve Jacobs Guest

    Default ITXpert

    I have been messing about with ASP and MSAccess databases for a while, but I have just beginning to use a MSSQL7 dabase. I "upsized" an access database that was working fine with some asp pages. I made the necessary changes to my pages and everything is working fine except for the fields (columns) that were "memo" fields or datatypes in Access. When converted to MSSql7 they became ntext datatypes. They are now returning this error message:<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80040e21&#039 <BR><BR>Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. <BR><BR>I did try converting these to "text" datatypes, but this didn&#039t work either. Any help greatly appreciatedt<BR><BR><BR>/article.asp, line 144 <BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: ITXpert

    Have you tried Varchar?

Posting Permissions

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