error 80040e2f

[Alberto Lara]

I am receiving the following error

Microsoft OLE DB
Provider for SQL Server error '80040e2f'

I really don't know how to solve it, i would appreciate
any help in this regard.

Alberto Lara

[Russ Gray [MS]]

Hi Alberto

That error from SQLServer means:

0x80040e2f means DB_E_INTEGRITYVIOLATION. This can be returned
from ICommand::Execute, IMultipleResults::GetResult,
IRowsetChange::InsertRow,
and IRowsetChange::SetData. Usually means that the operation tried to put a
value in a field, and that value violated a constraint for the column.

You may want to look at the tables involved and see if they have any
constraints, then look at your code and see if you might be violating the
constraints when you add or update a record.

I hope this helps,

Russ Gray
Microsoft Developer Support

This posting is provided “AS IS” with no warranties, and confers no rights.

Are you secure? For information about the Microsoft Strategic Technology
Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.