Board index » Visual Studio » Error numbers

yluo

Error numbers

Visual Studio208
Could someone point me to a good place to research VB/ADO error numbers.



Example

-2147189544



I did the microsoft and google and found nothing.



Thanks



George


-
 
Jeff

Registered User

Fri Nov 05 12:58:34 CST 2004

Re:Error numbers

This is a multi-part message in MIME format.



------=_NextPart_000_00A9_01C4C33F.8A1B7DF0

Content-Type: text/plain;

charset="Windows-1252"

Content-Transfer-Encoding: quoted-printable





"george collins" <george@nospan.com>wrote in message =

Quote
Could someone point me to a good place to research VB/ADO error =

numbers.

=20

Example

-2147189544



[Profuse apologies to the plain-text zealots, but there was no easy way =

to format this with only plain text.]



For most of your research you need to convert the signed integer to a =

hex value and then search for that. Here's some info I've collected over =

time:



Code Hex Constant Description Sample=20

-2147467259 80004005 E_FAIL Unspecified error =B7 <Have received =

as a generic timeout message>

=B7 Cannot generate SSPI context

=B7 OLE DB provider for Jet cannot find file

=B7 SHUTDOWN is in progress=20

-2147217906 80040E0E DB_E_BADBOOKMARK Invalid bookmark Bookmark is =

invalid.=20

-2147217900 80040E14 DB_E_ERRORSINCOMMAND The command contained =

one or more errors =B7 Incorrect syntax near '<whatever>'.

=B7 [Microsoft][ODBC SQL Server Driver][SQL Server]...

=B7 <"Transaction log full" messages come through under this>=20

-2147217871 80040E31 DB_E_ABORTLIMITREACHED Execution aborted =

because a resource limit has been reached; no results have been returned =

Timeout=20

-2147217911 80040E09 DB_SEC_E_PERMISSIONDENIED Permission denied =

EXECUTE permission denied on object '<obj>', database '<db>', owner =

'<own>'.=20

-2147217913 80040E07 DB_E_CANTCONVERTVALUE A literal value in the =

command could not be converted to the correct type due to a reason other =

than data overflow =B7 Error converting data type numeric to int.

=B7 Error converting data type datetime to smalldatetime.=20

-2147352566 8002000A DISP_E_OVERFLOW Out of present range. Out of =

present range. (Got this when attempting to assign a value to an ADO =

Command parameter which was outside the range of an int.)=20

-2147217873 80040E2F DB_E_INTEGRITYVIOLATION Value violated the =

integrity constraints for a column or table =B7 Cannot insert the value =

<blah>into column '<whatever>' etc.

=B7 Duplicate key was ignored=20

-2147168237 8004D013 XACT_E_XTIONEXISTS An enlistment in a =

transaction already exists. Cannot start more transactions on this =

session.=20



------=_NextPart_000_00A9_01C4C33F.8A1B7DF0

Content-Type: text/html;

charset="Windows-1252"

Content-Transfer-Encoding: quoted-printable



<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<HTML><HEAD>

<META http-equiv=3DContent-Type content=3D"text/html; =

charset=3Dwindows-1252">

<META content=3D"MSHTML 6.00.2900.2523" name=3DGENERATOR>

<STYLE></STYLE>

</HEAD>

<BODY>

<DIV><FONT size=3D2></FONT>&nbsp;</DIV>

<DIV><FONT size=3D2>"george collins" &lt;</FONT><A=20

href=3D"mailto:george@nospan.com"><FONT =

size=3D2>george@nospan.com</FONT></A><FONT=20

size=3D2>&gt; wrote in message </FONT><A=20

href=3D"news:OMwXzb2wEHA.1396@tk2msftngp13.phx.gbl"><FONT=20

size=3D2>news:OMwXzb2wEHA.1396@tk2msftngp13.phx.gbl</FONT></A><FONT=20

size=3D2>...</FONT></DIV>

<DIV><FONT size=3D2>&gt; Could someone point me to a good place to =

research VB/ADO=20

error numbers.<BR>&gt; <BR>&gt; Example<BR>&gt; =

-2147189544<BR></FONT></DIV>

<DIV><FONT size=3D2>[Profuse apologies to the plain-text zealots, but =

there was no=20

easy way to format this with only plain text.]</FONT></DIV>

<DIV><FONT size=3D2>&nbsp;</DIV></FONT>

<DIV><FONT size=3D2>For most of your research you need to convert the =

signed=20

integer to a hex value and then search for that. Here's some info</FONT>=

<FONT=20

size=3D2>I've collected over time:</FONT></DIV>

<DIV><FONT size=3D2></FONT>&nbsp;</DIV>

<DIV><FONT size=3D2>

<TABLE style=3D"WIDTH: 697pt; BORDER-COLLAPSE: collapse" cellSpacing=3D0 =



cellPadding=3D0 width=3D929 border=3D0 x:str>

<COLGROUP>

<COL style=3D"WIDTH: 61pt; mso-width-source: userset; mso-width-alt: =

2962"=20

width=3D81>

<COL style=3D"WIDTH: 50pt; mso-width-source: userset; mso-width-alt: =

2450"=20

width=3D67>

<COL style=3D"WIDTH: 162pt; mso-width-source: userset; mso-width-alt: =

7899"=20

width=3D216>

<COL style=3D"WIDTH: 200pt; mso-width-source: userset; mso-width-alt: =

9728"=20

width=3D266>

<COL style=3D"WIDTH: 224pt; mso-width-source: userset; mso-width-alt: =

10934"=20

width=3D299>

<TBODY>

<TR style=3D"HEIGHT: 12.75pt" height=3D17>

<TD class=3Dxl24=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: =

61pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; =

BACKGROUND-COLOR: transparent"=20

width=3D81 height=3D17><FONT size=3D2>Code</FONT></TD>

<TD class=3Dxl25=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 50pt; =

BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"=20

width=3D67><FONT size=3D2>Hex</FONT></TD>

<TD class=3Dxl24=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 162pt; =

BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"=20

width=3D216><FONT size=3D2>Constant</FONT></TD>

<TD class=3Dxl26=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 200pt; =

BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"=20

width=3D266><FONT size=3D2>Description</FONT></TD>

<TD class=3Dxl26=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 224pt; =

BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"=20

width=3D299><FONT size=3D2>Sample</FONT></TD></TR>

<TR style=3D"HEIGHT: 51pt" height=3D68>

<TD class=3Dxl24=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: =

windowtext 0.5pt solid; HEIGHT: 51pt; BACKGROUND-COLOR: transparent"=20

align=3Dright height=3D68 x:num=3D"-2147467259"><FONT=20

size=3D2>-2147467259</FONT></TD>

<TD class=3Dxl25=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =

solid; BACKGROUND-COLOR: transparent"><FONT=20

size=3D2>80004005</FONT></TD>

<TD class=3Dxl24=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =

solid; BACKGROUND-COLOR: transparent"><FONT=20

size=3D2>E_FAIL</FONT></TD>

<TD class=3Dxl26=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; WIDTH: 200pt; BORDER-BOTTOM: =

windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"=20

width=3D266><FONT size=3D2>Unspecified error</FONT></TD>

<TD class=3Dxl27=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; WIDTH: 224pt; BORDER-BOTTOM: =

windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"=20

width=3D299><FONT size=3D2>=B7</FONT><FONT class=3Dfont0 size=3D2>=

&lt;Have received=20

as a generic timeout message&gt;<BR>=B7 Cannot generate SSPI =

context<BR>=B7=20

OLE DB provider for Jet cannot find file<BR>=B7 SHUTDOWN is in=20

progress</FONT></TD></TR>

<TR style=3D"HEIGHT: 12.75pt" height=3D17>

<TD class=3Dxl24=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: =

windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent"=20

align=3Dright height=3D17 x:num=3D"-2147217906"><FONT=20

size=3D2>-2147217906</FONT></TD>

<TD class=3Dxl25=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =

solid; BACKGROUND-COLOR: transparent"><FONT=20

size=3D2>80040E0E</FONT></TD>

<TD class=3Dxl24=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =

solid; BACKGROUND-COLOR: transparent"><FONT=20

size=3D2>DB_E_BADBOOKMARK</FONT></TD>

<TD class=3Dxl26=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; WIDTH: 200pt; BORDER-BOTTOM: =

windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"=20

width=3D266><FONT size=3D2>Invalid bookmark</FONT></TD>

<TD class=3Dxl26=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; WIDTH: 224pt; BORDER-BOTTOM: =

windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"=20

width=3D299><FONT size=3D2>Bookmark is invalid.</FONT></TD></TR>

<TR style=3D"HEIGHT: 63.75pt" height=3D85>

<TD class=3Dxl24=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: =

windowtext 0.5pt solid; HEIGHT: 63.75pt; BACKGROUND-COLOR: transparent"=20

align=3Dright height=3D85 x:num=3D"-2147217900"><FONT=20

size=3D2>-2147217900</FONT></TD>

<TD class=3Dxl25=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =

solid; BACKGROUND-COLOR: transparent"><FONT=20

size=3D2>80040E14</FONT></TD>

<TD class=3Dxl24=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =

solid; BACKGROUND-COLOR: transparent"><FONT=20

size=3D2>DB_E_ERRORSINCOMMAND</FONT></TD>

<TD class=3Dxl26=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; WIDTH: 200pt; BORDER-BOTTOM: =

windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"=20

width=3D266><FONT size=3D2>The command contained one or more =

errors</FONT></TD>

<TD class=3Dxl26=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; WIDTH: 224pt; BORDER-BOTTOM: =

windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"=20

width=3D299><FONT size=3D2>=B7 Incorrect syntax near =

'&lt;whatever&gt;'.<BR>=B7=20

[Microsoft][ODBC SQL Server Driver][SQL Server]...<BR>=B7 =

&lt;"Transaction=20

log full" messages come through under this&gt;</FONT></TD></TR>

<TR style=3D"HEIGHT: 38.25pt" height=3D51>

<TD class=3Dxl24=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: =

windowtext 0.5pt solid; HEIGHT: 38.25pt; BACKGROUND-COLOR: transparent"=20

align=3Dright height=3D51 x:num=3D"-2147217871"><FONT=20

size=3D2>-2147217871</FONT></TD>

<TD class=3Dxl25=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =

solid; BACKGROUND-COLOR: transparent"><FONT=20

size=3D2>80040E31</FONT></TD>

<TD class=3Dxl24=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =

solid; BACKGROUND-COLOR: transparent"><FONT=20

size=3D2>DB_E_ABORTLIMITREACHED</FONT></TD>

<TD class=3Dxl26=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; WIDTH: 200pt; BORDER-BOTTOM: =

windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"=20

width=3D266><FONT size=3D2>Execution aborted because a resource =

limit has been=20

reached; no results have been returned</FONT></TD>

<TD class=3Dxl26=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; WIDTH: 224pt; BORDER-BOTTOM: =

windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"=20

width=3D299><FONT size=3D2>Timeout</FONT></TD></TR>

<TR style=3D"HEIGHT: 25.5pt" height=3D34>

<TD class=3Dxl24=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: =

windowtext 0.5pt solid; HEIGHT: 25.5pt; BACKGROUND-COLOR: transparent"=20

align=3Dright height=3D34 x:num=3D"-2147217911"><FONT=20

size=3D2>-2147217911</FONT></TD>

<TD class=3Dxl25=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =

solid; BACKGROUND-COLOR: transparent"><FONT=20

size=3D2>80040E09</FONT></TD>

<TD class=3Dxl24=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =

solid; BACKGROUND-COLOR: transparent"><FONT=20

size=3D2>DB_SEC_E_PERMISSIONDENIED</FONT></TD>

<TD class=3Dxl26=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; WIDTH: 200pt; BORDER-BOTTOM: =

windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"=20

width=3D266><FONT size=3D2>Permission denied</FONT></TD>

<TD class=3Dxl26=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; WIDTH: 224pt; BORDER-BOTTOM: =

windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"=20

width=3D299><FONT size=3D2>EXECUTE permission denied on object =

'&lt;obj&gt;',=20

database '&lt;db&gt;', owner '&lt;own&gt;'.</FONT></TD></TR>

<TR style=3D"HEIGHT: 38.25pt" height=3D51>

<TD class=3Dxl24=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: =

windowtext 0.5pt solid; HEIGHT: 38.25pt; BACKGROUND-COLOR: transparent"=20

align=3Dright height=3D51 x:num=3D"-2147217913"><FONT=20

size=3D2>-2147217913</FONT></TD>

<TD class=3Dxl25=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =

solid; BACKGROUND-COLOR: transparent"><FONT=20

size=3D2>80040E07</FONT></TD>

<TD class=3Dxl24=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =

solid; BACKGROUND-COLOR: transparent"><FONT=20

size=3D2>DB_E_CANTCONVERTVALUE</FONT></TD>

<TD class=3Dxl26=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; WIDTH: 200pt; BORDER-BOTTOM: =

windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"=20

width=3D266><FONT size=3D2>A literal value in the command could not =

be=20

converted to the correct type due to a reason other than data=20

overflow</FONT></TD>

<TD class=3Dxl26=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; WIDTH: 224pt; BORDER-BOTTOM: =

windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"=20

width=3D299><FONT size=3D2>=B7 Error converting data type numeric to =

int.<BR>=B7=20

Error converting data type datetime to =

smalldatetime.</FONT></TD></TR>

<TR style=3D"HEIGHT: 38.25pt" height=3D51>

<TD class=3Dxl24=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: =

windowtext 0.5pt solid; HEIGHT: 38.25pt; BACKGROUND-COLOR: transparent"=20

align=3Dright height=3D51 x:num=3D"-2147352566"><FONT=20

size=3D2>-2147352566</FONT></TD>

<TD class=3Dxl25=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =

solid; BACKGROUND-COLOR: transparent"><FONT=20

size=3D2>8002000A</FONT></TD>

<TD class=3Dxl24=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =

solid; BACKGROUND-COLOR: transparent"><FONT=20

size=3D2>DISP_E_OVERFLOW</FONT></TD>

<TD class=3Dxl26=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; WIDTH: 200pt; BORDER-BOTTOM: =

windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"=20

width=3D266><FONT size=3D2>Out of present range.</FONT></TD>

<TD class=3Dxl26=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; WIDTH: 224pt; BORDER-BOTTOM: =

windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"=20

width=3D299><FONT size=3D2>Out of present range. (Got this when =

attempting to=20

assign a value to an ADO Command parameter which was outside the =

range of=20

an int.)</FONT></TD></TR>

<TR style=3D"HEIGHT: 38.25pt" height=3D51>

<TD class=3Dxl24=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: =

windowtext 0.5pt solid; HEIGHT: 38.25pt; BACKGROUND-COLOR: transparent"=20

align=3Dright height=3D51 x:num=3D"-2147217873"><FONT=20

size=3D2>-2147217873</FONT></TD>

<TD class=3Dxl25=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =

solid; BACKGROUND-COLOR: transparent"><FONT=20

size=3D2>80040E2F</FONT></TD>

<TD class=3Dxl24=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =

solid; BACKGROUND-COLOR: transparent"><FONT=20

size=3D2>DB_E_INTEGRITYVIOLATION</FONT></TD>

<TD class=3Dxl26=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; WIDTH: 200pt; BORDER-BOTTOM: =

windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"=20

width=3D266><FONT size=3D2>Value violated the integrity constraints =

for a=20

column or table</FONT></TD>

<TD class=3Dxl26=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; WIDTH: 224pt; BORDER-BOTTOM: =

windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"=20

width=3D299><FONT size=3D2>=B7 Cannot insert the value &lt;blah&gt; =

into column=20

'&lt;whatever&gt;' etc.<BR>=B7 Duplicate key was =

ignored</FONT></TD></TR>

<TR style=3D"HEIGHT: 25.5pt" height=3D34>

<TD class=3Dxl24=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: =

windowtext 0.5pt solid; HEIGHT: 25.5pt; BACKGROUND-COLOR: transparent"=20

align=3Dright height=3D34 x:num=3D"-2147168237"><FONT=20

size=3D2>-2147168237</FONT></TD>

<TD class=3Dxl25=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =

solid; BACKGROUND-COLOR: transparent"><FONT=20

size=3D2>8004D013</FONT></TD>

<TD class=3Dxl24=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =

solid; BACKGROUND-COLOR: transparent"><FONT=20

size=3D2>XACT_E_XTIONEXISTS</FONT></TD>

<TD class=3Dxl26=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; WIDTH: 200pt; BORDER-BOTTOM: =

windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"=20

width=3D266><FONT size=3D2>An enlistment in a transaction already=20

exists.</FONT></TD>

<TD class=3Dxl26=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; WIDTH: 224pt; BORDER-BOTTOM: =

windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"=20

width=3D299><FONT size=3D2>Cannot start more transactions on this=20

=

session.</FONT></TD></TR></TBODY></TABLE></FONT></DIV></BODY></HTML>



------=_NextPart_000_00A9_01C4C33F.8A1B7DF0--



-
george

Registered User

Fri Nov 05 14:17:07 CST 2004

Re:Error numbers

This is a multi-part message in MIME format.



------=_NextPart_000_000B_01C4C331.5F930160

Content-Type: text/plain;

charset="Windows-1252"

Content-Transfer-Encoding: quoted-printable



Thanks 10 million %, I will search for the hex to see what happens.



Thanks

"Jeff Johnson [MVP: VB]" <i.get@enough.spam>wrote in message =



"george collins" <george@nospan.com>wrote in message =

Quote
Could someone point me to a good place to research VB/ADO error =

numbers.

Quote
=20

Example

-2147189544



[Profuse apologies to the plain-text zealots, but there was no easy =

way to format this with only plain text.]



For most of your research you need to convert the signed integer to a =

hex value and then search for that. Here's some info I've collected over =

time:



Code Hex Constant Description Sample=20

-2147467259 80004005 E_FAIL Unspecified error =B7 <Have received =

as a generic timeout message>

=B7 Cannot generate SSPI context

=B7 OLE DB provider for Jet cannot find file

=B7 SHUTDOWN is in progress=20

-2147217906 80040E0E DB_E_BADBOOKMARK Invalid bookmark Bookmark =

is invalid.=20

-2147217900 80040E14 DB_E_ERRORSINCOMMAND The command contained =

one or more errors =B7 Incorrect syntax near '<whatever>'.

=B7 [Microsoft][ODBC SQL Server Driver][SQL Server]...

=B7 <"Transaction log full" messages come through under this>=20

-2147217871 80040E31 DB_E_ABORTLIMITREACHED Execution aborted =

because a resource limit has been reached; no results have been returned =

Timeout=20

-2147217911 80040E09 DB_SEC_E_PERMISSIONDENIED Permission denied =

EXECUTE permission denied on object '<obj>', database '<db>', owner =

'<own>'.=20

-2147217913 80040E07 DB_E_CANTCONVERTVALUE A literal value in =

the command could not be converted to the correct type due to a reason =

other than data overflow =B7 Error converting data type numeric to int.

=B7 Error converting data type datetime to smalldatetime.=20

-2147352566 8002000A DISP_E_OVERFLOW Out of present range. Out =

of present range. (Got this when attempting to assign a value to an ADO =

Command parameter which was outside the range of an int.)=20

-2147217873 80040E2F DB_E_INTEGRITYVIOLATION Value violated the =

integrity constraints for a column or table =B7 Cannot insert the value =

<blah>into column '<whatever>' etc.

=B7 Duplicate key was ignored=20

-2147168237 8004D013 XACT_E_XTIONEXISTS An enlistment in a =

transaction already exists. Cannot start more transactions on this =

session.=20



------=_NextPart_000_000B_01C4C331.5F930160

Content-Type: text/html;

charset="Windows-1252"

Content-Transfer-Encoding: quoted-printable



<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<HTML><HEAD>

<META http-equiv=3DContent-Type content=3D"text/html; =

charset=3Dwindows-1252">

<META content=3D"MSHTML 6.00.2900.2523" name=3DGENERATOR>

<STYLE></STYLE>

</HEAD>

<BODY bgColor=3D#ffffff>

<DIV><FONT face=3DArial size=3D2>Thanks 10 million %,&nbsp; I will =

search for the=20

hex to see what happens.</FONT></DIV>

<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>

<DIV><FONT face=3DArial size=3D2>Thanks</FONT></DIV>

<BLOCKQUOTE dir=3Dltr=20

style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =

BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

<DIV>"Jeff Johnson [MVP: VB]" &lt;<A=20

href=3D"mailto:i.get@enough.spam">i.get@enough.spam</A>&gt; wrote in =

message <A=20

=

href=3D"news:%237O40l2wEHA.2980@TK2MSFTNGP10.phx.gbl">news:%237O40l2wEHA.=

2980@TK2MSFTNGP10.phx.gbl</A>...</DIV>

<DIV><FONT size=3D2></FONT>&nbsp;</DIV>

<DIV><FONT size=3D2>"george collins" &lt;</FONT><A=20

href=3D"mailto:george@nospan.com"><FONT =

size=3D2>george@nospan.com</FONT></A><FONT=20

size=3D2>&gt; wrote in message </FONT><A=20

href=3D"news:OMwXzb2wEHA.1396@tk2msftngp13.phx.gbl"><FONT=20

size=3D2>news:OMwXzb2wEHA.1396@tk2msftngp13.phx.gbl</FONT></A><FONT=20

size=3D2>...</FONT></DIV>

<DIV><FONT size=3D2>&gt; Could someone point me to a good place to =

research=20

VB/ADO error numbers.<BR>&gt; <BR>&gt; Example<BR>&gt;=20

-2147189544<BR></FONT></DIV>

<DIV><FONT size=3D2>[Profuse apologies to the plain-text zealots, but =

there was=20

no easy way to format this with only plain text.]</FONT></DIV>

<DIV><FONT size=3D2>&nbsp;</DIV></FONT>

<DIV><FONT size=3D2>For most of your research you need to convert the =

signed=20

integer to a hex value and then search for that. Here's some =

info</FONT><FONT=20

size=3D2>I've collected over time:</FONT></DIV>

<DIV><FONT size=3D2></FONT>&nbsp;</DIV>

<DIV><FONT size=3D2>

<TABLE style=3D"WIDTH: 697pt; BORDER-COLLAPSE: collapse" =

cellSpacing=3D0=20

cellPadding=3D0 width=3D929 border=3D0 x:str>

<COLGROUP>

<COL style=3D"WIDTH: 61pt; mso-width-source: userset; mso-width-alt: =

2962"=20

width=3D81>

<COL style=3D"WIDTH: 50pt; mso-width-source: userset; mso-width-alt: =

2450"=20

width=3D67>

<COL style=3D"WIDTH: 162pt; mso-width-source: userset; =

mso-width-alt: 7899"=20

width=3D216>

<COL style=3D"WIDTH: 200pt; mso-width-source: userset; =

mso-width-alt: 9728"=20

width=3D266>

<COL style=3D"WIDTH: 224pt; mso-width-source: userset; =

mso-width-alt: 10934"=20

width=3D299>

<TBODY>

<TR style=3D"HEIGHT: 12.75pt" height=3D17>

<TD class=3Dxl24=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: =

61pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; =

BACKGROUND-COLOR: transparent"=20

width=3D81 height=3D17><FONT size=3D2>Code</FONT></TD>

<TD class=3Dxl25=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 50pt; =

BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"=20

width=3D67><FONT size=3D2>Hex</FONT></TD>

<TD class=3Dxl24=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 162pt; =

BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"=20

width=3D216><FONT size=3D2>Constant</FONT></TD>

<TD class=3Dxl26=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 200pt; =

BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"=20

width=3D266><FONT size=3D2>Description</FONT></TD>

<TD class=3Dxl26=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 224pt; =

BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"=20

width=3D299><FONT size=3D2>Sample</FONT></TD></TR>

<TR style=3D"HEIGHT: 51pt" height=3D68>

<TD class=3Dxl24=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: =

windowtext 0.5pt solid; HEIGHT: 51pt; BACKGROUND-COLOR: transparent"=20

align=3Dright height=3D68 x:num=3D"-2147467259"><FONT=20

size=3D2>-2147467259</FONT></TD>

<TD class=3Dxl25=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =

solid; BACKGROUND-COLOR: transparent"><FONT=20

size=3D2>80004005</FONT></TD>

<TD class=3Dxl24=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =

solid; BACKGROUND-COLOR: transparent"><FONT=20

size=3D2>E_FAIL</FONT></TD>

<TD class=3Dxl26=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; WIDTH: 200pt; BORDER-BOTTOM: =

windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"=20

width=3D266><FONT size=3D2>Unspecified error</FONT></TD>

<TD class=3Dxl27=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; WIDTH: 224pt; BORDER-BOTTOM: =

windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"=20

width=3D299><FONT size=3D2>=B7</FONT><FONT class=3Dfont0 size=3D2>=

&lt;Have=20

received as a generic timeout message&gt;<BR>=B7 Cannot generate =

SSPI=20

context<BR>=B7 OLE DB provider for Jet cannot find file<BR>=B7 =

SHUTDOWN is=20

in progress</FONT></TD></TR>

<TR style=3D"HEIGHT: 12.75pt" height=3D17>

<TD class=3Dxl24=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: =

windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent"=20

align=3Dright height=3D17 x:num=3D"-2147217906"><FONT=20

size=3D2>-2147217906</FONT></TD>

<TD class=3Dxl25=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =

solid; BACKGROUND-COLOR: transparent"><FONT=20

size=3D2>80040E0E</FONT></TD>

<TD class=3Dxl24=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =

solid; BACKGROUND-COLOR: transparent"><FONT=20

size=3D2>DB_E_BADBOOKMARK</FONT></TD>

<TD class=3Dxl26=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; WIDTH: 200pt; BORDER-BOTTOM: =

windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"=20

width=3D266><FONT size=3D2>Invalid bookmark</FONT></TD>

<TD class=3Dxl26=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; WIDTH: 224pt; BORDER-BOTTOM: =

windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"=20

width=3D299><FONT size=3D2>Bookmark is invalid.</FONT></TD></TR>

<TR style=3D"HEIGHT: 63.75pt" height=3D85>

<TD class=3Dxl24=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: =

windowtext 0.5pt solid; HEIGHT: 63.75pt; BACKGROUND-COLOR: transparent"=20

align=3Dright height=3D85 x:num=3D"-2147217900"><FONT=20

size=3D2>-2147217900</FONT></TD>

<TD class=3Dxl25=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =

solid; BACKGROUND-COLOR: transparent"><FONT=20

size=3D2>80040E14</FONT></TD>

<TD class=3Dxl24=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =

solid; BACKGROUND-COLOR: transparent"><FONT=20

size=3D2>DB_E_ERRORSINCOMMAND</FONT></TD>

<TD class=3Dxl26=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; WIDTH: 200pt; BORDER-BOTTOM: =

windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"=20

width=3D266><FONT size=3D2>The command contained one or more=20

errors</FONT></TD>

<TD class=3Dxl26=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; WIDTH: 224pt; BORDER-BOTTOM: =

windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"=20

width=3D299><FONT size=3D2>=B7 Incorrect syntax near =

'&lt;whatever&gt;'.<BR>=B7=20

[Microsoft][ODBC SQL Server Driver][SQL Server]...<BR>=B7 =

&lt;"Transaction=20

log full" messages come through under this&gt;</FONT></TD></TR>

<TR style=3D"HEIGHT: 38.25pt" height=3D51>

<TD class=3Dxl24=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: =

windowtext 0.5pt solid; HEIGHT: 38.25pt; BACKGROUND-COLOR: transparent"=20

align=3Dright height=3D51 x:num=3D"-2147217871"><FONT=20

size=3D2>-2147217871</FONT></TD>

<TD class=3Dxl25=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =

solid; BACKGROUND-COLOR: transparent"><FONT=20

size=3D2>80040E31</FONT></TD>

<TD class=3Dxl24=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =

solid; BACKGROUND-COLOR: transparent"><FONT=20

size=3D2>DB_E_ABORTLIMITREACHED</FONT></TD>

<TD class=3Dxl26=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; WIDTH: 200pt; BORDER-BOTTOM: =

windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"=20

width=3D266><FONT size=3D2>Execution aborted because a resource =

limit has=20

been reached; no results have been returned</FONT></TD>

<TD class=3Dxl26=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; WIDTH: 224pt; BORDER-BOTTOM: =

windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"=20

width=3D299><FONT size=3D2>Timeout</FONT></TD></TR>

<TR style=3D"HEIGHT: 25.5pt" height=3D34>

<TD class=3Dxl24=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: =

windowtext 0.5pt solid; HEIGHT: 25.5pt; BACKGROUND-COLOR: transparent"=20

align=3Dright height=3D34 x:num=3D"-2147217911"><FONT=20

size=3D2>-2147217911</FONT></TD>

<TD class=3Dxl25=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =

solid; BACKGROUND-COLOR: transparent"><FONT=20

size=3D2>80040E09</FONT></TD>

<TD class=3Dxl24=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =

solid; BACKGROUND-COLOR: transparent"><FONT=20

size=3D2>DB_SEC_E_PERMISSIONDENIED</FONT></TD>

<TD class=3Dxl26=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; WIDTH: 200pt; BORDER-BOTTOM: =

windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"=20

width=3D266><FONT size=3D2>Permission denied</FONT></TD>

<TD class=3Dxl26=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; WIDTH: 224pt; BORDER-BOTTOM: =

windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"=20

width=3D299><FONT size=3D2>EXECUTE permission denied on object=20

'&lt;obj&gt;', database '&lt;db&gt;', owner =

'&lt;own&gt;'.</FONT></TD></TR>

<TR style=3D"HEIGHT: 38.25pt" height=3D51>

<TD class=3Dxl24=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: =

windowtext 0.5pt solid; HEIGHT: 38.25pt; BACKGROUND-COLOR: transparent"=20

align=3Dright height=3D51 x:num=3D"-2147217913"><FONT=20

size=3D2>-2147217913</FONT></TD>

<TD class=3Dxl25=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =

solid; BACKGROUND-COLOR: transparent"><FONT=20

size=3D2>80040E07</FONT></TD>

<TD class=3Dxl24=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =

solid; BACKGROUND-COLOR: transparent"><FONT=20

size=3D2>DB_E_CANTCONVERTVALUE</FONT></TD>

<TD class=3Dxl26=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; WIDTH: 200pt; BORDER-BOTTOM: =

windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"=20

width=3D266><FONT size=3D2>A literal value in the command could =

not be=20

converted to the correct type due to a reason other than data=20

overflow</FONT></TD>

<TD class=3Dxl26=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; WIDTH: 224pt; BORDER-BOTTOM: =

windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"=20

width=3D299><FONT size=3D2>=B7 Error converting data type numeric =

to int.<BR>=B7=20

Error converting data type datetime to =

smalldatetime.</FONT></TD></TR>

<TR style=3D"HEIGHT: 38.25pt" height=3D51>

<TD class=3Dxl24=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: =

windowtext 0.5pt solid; HEIGHT: 38.25pt; BACKGROUND-COLOR: transparent"=20

align=3Dright height=3D51 x:num=3D"-2147352566"><FONT=20

size=3D2>-2147352566</FONT></TD>

<TD class=3Dxl25=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =

solid; BACKGROUND-COLOR: transparent"><FONT=20

size=3D2>8002000A</FONT></TD>

<TD class=3Dxl24=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =

solid; BACKGROUND-COLOR: transparent"><FONT=20

size=3D2>DISP_E_OVERFLOW</FONT></TD>

<TD class=3Dxl26=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; WIDTH: 200pt; BORDER-BOTTOM: =

windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"=20

width=3D266><FONT size=3D2>Out of present range.</FONT></TD>

<TD class=3Dxl26=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; WIDTH: 224pt; BORDER-BOTTOM: =

windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"=20

width=3D299><FONT size=3D2>Out of present range. (Got this when =

attempting=20

to assign a value to an ADO Command parameter which was outside =

the=20

range of an int.)</FONT></TD></TR>

<TR style=3D"HEIGHT: 38.25pt" height=3D51>

<TD class=3Dxl24=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: =

windowtext 0.5pt solid; HEIGHT: 38.25pt; BACKGROUND-COLOR: transparent"=20

align=3Dright height=3D51 x:num=3D"-2147217873"><FONT=20

size=3D2>-2147217873</FONT></TD>

<TD class=3Dxl25=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =

solid; BACKGROUND-COLOR: transparent"><FONT=20

size=3D2>80040E2F</FONT></TD>

<TD class=3Dxl24=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =

solid; BACKGROUND-COLOR: transparent"><FONT=20

size=3D2>DB_E_INTEGRITYVIOLATION</FONT></TD>

<TD class=3Dxl26=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; WIDTH: 200pt; BORDER-BOTTOM: =

windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"=20

width=3D266><FONT size=3D2>Value violated the integrity =

constraints for a=20

column or table</FONT></TD>

<TD class=3Dxl26=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; WIDTH: 224pt; BORDER-BOTTOM: =

windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"=20

width=3D299><FONT size=3D2>=B7 Cannot insert the value =

&lt;blah&gt; into=20

column '&lt;whatever&gt;' etc.<BR>=B7 Duplicate key was=20

ignored</FONT></TD></TR>

<TR style=3D"HEIGHT: 25.5pt" height=3D34>

<TD class=3Dxl24=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: =

windowtext 0.5pt solid; HEIGHT: 25.5pt; BACKGROUND-COLOR: transparent"=20

align=3Dright height=3D34 x:num=3D"-2147168237"><FONT=20

size=3D2>-2147168237</FONT></TD>

<TD class=3Dxl25=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =

solid; BACKGROUND-COLOR: transparent"><FONT=20

size=3D2>8004D013</FONT></TD>

<TD class=3Dxl24=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =

solid; BACKGROUND-COLOR: transparent"><FONT=20

size=3D2>XACT_E_XTIONEXISTS</FONT></TD>

<TD class=3Dxl26=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; WIDTH: 200pt; BORDER-BOTTOM: =

windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"=20

width=3D266><FONT size=3D2>An enlistment in a transaction already=20

exists.</FONT></TD>

<TD class=3Dxl26=20

style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =

windowtext; BORDER-LEFT: windowtext; WIDTH: 224pt; BORDER-BOTTOM: =

windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"=20

width=3D299><FONT size=3D2>Cannot start more transactions on this=20

=

session.</FONT></TD></TR></TBODY></TABLE></FONT></DIV></BLOCKQUOTE></BODY=

Quote
</HTML>



------=_NextPart_000_000B_01C4C331.5F930160--



-