adErrIllegalOperation 
Author Message
 adErrIllegalOperation

I am receiving this error when I try to close an ADO
Recordset from a SQL Server database table.  The error
message is: "Operation is not allowed in this context."  I
receive this message on this recordset only after I try to
use the "AddNew" command.  I have verified that the types
in the C++ code match the types the SQL Server is
expecting for the tables and that the call to AddNew is
not encountering any errors.  The other 50ish recordsets I
have out of this same database work fine.

I have looked everywhere for some hint as to what causes
this on a call to Close, but all I find is error code
lists.  Any help would be greatly appreciated.

Thanks,
Jim



Sat, 02 Jul 2005 01:31:13 GMT
 adErrIllegalOperation

Jim,

If you call
--
Val Mazur
Microsoft MVP


Quote:
> I am receiving this error when I try to close an ADO
> Recordset from a SQL Server database table.  The error
> message is: "Operation is not allowed in this context."  I
> receive this message on this recordset only after I try to
> use the "AddNew" command.  I have verified that the types
> in the C++ code match the types the SQL Server is
> expecting for the tables and that the call to AddNew is
> not encountering any errors.  The other 50ish recordsets I
> have out of this same database work fine.

> I have looked everywhere for some hint as to what causes
> this on a call to Close, but all I find is error code
> lists.  Any help would be greatly appreciated.

> Thanks,
> Jim



Sat, 02 Jul 2005 02:29:41 GMT
 adErrIllegalOperation
Val,

It appears you got cut off?

-Jim

Quote:
>-----Original Message-----
>Jim,

>If you call
>--
>Val Mazur
>Microsoft MVP



>> I am receiving this error when I try to close an ADO
>> Recordset from a SQL Server database table.  The error
>> message is: "Operation is not allowed in this
context."  I
>> receive this message on this recordset only after I try
to
>> use the "AddNew" command.  I have verified that the
types
>> in the C++ code match the types the SQL Server is
>> expecting for the tables and that the call to AddNew is
>> not encountering any errors.  The other 50ish
recordsets I
>> have out of this same database work fine.

>> I have looked everywhere for some hint as to what causes
>> this on a call to Close, but all I find is error code
>> lists.  Any help would be greatly appreciated.

>> Thanks,
>> Jim

>.



Sat, 02 Jul 2005 05:01:43 GMT
 adErrIllegalOperation
Sorry,

Probably when I click Send, I deleted text somehow. Try to call Update
method after AddNew. Sometimes you could get error if you did not call
Update to commit changes

--
Val Mazur
Microsoft MVP


Quote:
> Val,

> It appears you got cut off?

> -Jim

> >-----Original Message-----
> >Jim,

> >If you call
> >--
> >Val Mazur
> >Microsoft MVP



> >> I am receiving this error when I try to close an ADO
> >> Recordset from a SQL Server database table.  The error
> >> message is: "Operation is not allowed in this
> context."  I
> >> receive this message on this recordset only after I try
> to
> >> use the "AddNew" command.  I have verified that the
> types
> >> in the C++ code match the types the SQL Server is
> >> expecting for the tables and that the call to AddNew is
> >> not encountering any errors.  The other 50ish
> recordsets I
> >> have out of this same database work fine.

> >> I have looked everywhere for some hint as to what causes
> >> this on a call to Close, but all I find is error code
> >> lists.  Any help would be greatly appreciated.

> >> Thanks,
> >> Jim

> >.



Sat, 02 Jul 2005 05:23:59 GMT
 
 [ 4 post ] 

 Relevant Pages 

 
Powered by phpBB® Forum Software