ADO Error Numbers.

[Ed2020]

I have recently started working seriously with ADO and have come across a very annoying problem - not only are the rror numbers utterly ridiculous (very large negative numbers) but you also get the same error number for several different errors - primary key violation, null primary key, duplicate in distinct key, etc., etc.

Is there any way around this?

Ed Metcalfe.

 

[cmmrfrds]

Check out the ErrorValueEnum under the ADO help file. I found the help file on my PC by searching for *ADO*.chm and it found ado210.chm, but this can be different depending on your version of ADO.

Here is a reference that describes some error nummbers.

http://www.devguru.com/Technologies/ado/quickref/error_number.html

Apparently the following 3 are the same in number, negative number, and hexidecimal.
3707
-2146824581
0x800A0E7B

The last 4 hex digits 0E7B are 3707 in decimal, which should be the error number returned in the ADO errors collection. I don't know how the negative decimal converts to the other numbers. I am curious on how to convert the negative decimal number to the error number.