================================================== ========
Vijay wrote:
> *Hi all,
> I am Inserting a new record in SQL Server 2000 I am getting thi
> error.
> ====Following is the code generated via ASP Page for store
> Proc.====
> Add_Accounts 'demo', 'CD ', '02140791200000001494904025', 30
> 'nbvcbcb', '0', 'stephanie saggio', 'ecashadmin'
> ====Error========
> Microsoft OLE DB Provider for SQL Server error '80040e21'
>
> Multiple-step OLE DB operation generated errors. Check each OLE D
> status value, if available. No work was done.
> *
================================================== =========

Hi Vijay

You probably have found the answer by now... What was it?

If you haven't, you didn't show the table structure and the colum
types (nvarchar, text, etc) because there is a Microsoft Bug called:

*Cannot Insert Empty String into Memo, Text, nText, or Blob Columns*

http://tinyurl.com/4myfe

for the error:
Multiple-Step OLE DB operation generated errors. Check each OLE D
status value, if available. No work was done.

I'm not using .NET yet and my problem (and I'm still working on it) i
in DTS, trying to convert FoxPro 2.6 Memo field to SQL Server 2000 Tex
column. I get:

> Cannot instantiate Storage Object for source column ## ('column_name'
> Blob data.

> Multiple-step OLE DB operation generated errors. Check each OLE D
> status value, if available. No work was done.

Hope there's a cure

Alai


-
Alain_ADPtoSQ
-----------------------------------------------------------------------
Posted via http://www.mcse.m
-----------------------------------------------------------------------
View this thread: http://www.mcse.ms/message609821.htm