AdoConnection

Izpolzwam AdoConnection za wryzka s MSSQL Server. Prihwashtam syobshtenia ot greshkite, wyzniknali pri swyrzane kym servera i gi pokazwam na ekrana, posredstwom slednata primerna konstrukcia:

For j:= 0 To AdoConnection.ConnectionObject.Errors.Count-1 Do
Showmessage(AdoConnection.ConnectionObject.Errors.Items[j].Description);

AdoConnection.ConnectionObject.Errors.Item[j] e obekt ot tip Error, koito ima property Description, kydeto e informaciata za syotwetnata greshka.

Kakto se i ochakwa syobshtenieto e na angliiski. Celta mi e da izwejdam syotwetwashti alternatiwni syobshtenia na bylgarski ezik.

Wyprosa mi e kyde se syhraniawa informaciata ot syobshteniata za greshki i kak da stigna do neia?

mersi predwaritelno!

[линк]

Освен описание има и код на грешката. По него можеш да спретнеш един файл:
код=описание
код=описание
и после да работиш с Values колекцията на TStringList

чети и дишай по-леко

Constant	Value	Description

adErrBoundToCommand	3707	Cannot change the ActiveConnection property of a Recordset object which has a Command object as its source.

adErrCannotComplete	3732	Server cannot complete the operation.

adErrCantChangeConnection	3748	Connection was denied. New connection you requested has different characteristics than the one already in use.

adErrCantChangeProvider	3220	Supplied provider is different from the one already in use.

adErrCantConvertvalue	3724	Data value cannot be converted for reasons other than sign mismatch or data overflow. For example, conversion would have truncated data.

adErrCantCreate	3725	Data value cannot be set or retrieved because the field data type was unknown, or the provider had insufficient resources to perform the operation.

adErrCatalogNotSet	3747	Operation requires a valid ParentCatalog.

adErrColumnNotOnThisRow	3726	Record does not contain this field.

adErrDataConversion	3421	Application uses a value of the wrong type for the current operation.

adErrDataOverflow	3721	Data value is too large to be represented by the field data type.

adErrDelResOutOfScope	3738	URL of the object to be deleted is outside the scope of the current record.

adErrDenyNotSupported	3750	Provider does not support sharing restrictions.

adErrDenyTypeNotSupported	3751	Provider does not support the requested kind of sharing restriction.

adErrFeatureNotAvailable	3251	Object or provider is not capable of performing requested operation.

adErrFieldsUpdateFailed	3749	Fields update failed. For further information, examine the Status property of individual field objects.

adErrIllegalOperation	3219	Operation is not allowed in this context.

adErrIntegrityViolation	3719	Data value conflicts with the integrity constraints of the field.

adErrInTransaction	3246	Connection object cannot be explicitly closed while in a transaction.

adErrInvalidArgument	3001	Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

adErrInvalidConnection	3709	Operation is not allowed on an object referencing a closed or invalid connection.

adErrInvalidParamInfo	3708	Parameter object is improperly defined. Inconsistent or incomplete information was provided.

adErrInvalidTransaction	3714	Coordinating transaction is invalid or has not started.

adErrInvalidURL	3729	URL contains invalid characters. Make sure the URL is typed correctly.

adErrItemNotFound	3265	Item cannot be found in the collection corresponding to the requested name or ordinal.

adErrNoCurrentRecord	3021	Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

adErrNotExecuting	3715	Operation cannot be performed while not executing.

adErrNotReentrant	3710	Operation cannot be performed while processing event.

adErrObjectClosed	3704	Operation is not allowed when the object is closed.

adErrObjectInCollection	3367	Object is already in collection. Cannot append.

adErrObjectNotSet	3420	Object is no longer valid.

adErrObjectOpen	3705	Operation is not allowed when the object is open.

adErrOpeningFile	3002	File could not be opened.

adErrOperationCancelled	3712	Operation has been cancelled by the user.

adErrOutOfSpace	3734	Operation cannot be performed. Provider cannot obtain enough storage space.

adErrPermissionDenied	3720	Insufficent permission prevents writing to the field.

adErrPropConflicting	3742	Property value conflicts with a related property.

adErrPropInvalidColumn	3739	Property cannot apply to the specified field.

adErrPropInvalidOption	3740	Property attribute is invalid.

adErrPropInvalidValue	3741	Property value is invalid. Make sure the value is typed correctly.

adErrPropNotAllSettable	3743	Property is read-only or cannot be set.

adErrPropNotSet	3744	Optional property value was not set.

adErrPropNotSettable	3745	Read-only property value was not set.

adErrPropNotSupported	3746	Provider does not support the property.

adErrProviderFailed	3000	Provider failed to perform the requested operation.

adErrProviderNotFound	3706	Provider cannot be found. It may not be properly installed.

adErrReadFile	3003	File could not be read.

adErrResourceExists	3731	Copy operation cannot be performed. Object named by destination URL already exists. Specify adCopyOverwrite to replace the object.

adErrResourceLocked	3730	Object represented by the specified URL is locked by one or more other processes. Wait until the process has finished and attempt the operation again.

adErrResourceOutOfScope	3735	Source or destination URL is outside the scope of the current record.

adErrSchemaViolation	3722	Data value conflicts with the data type or constraints of the field.

adErrSignMismatch	3723	Conversion failed because the data value was signed and the field data type used by the provider was unsigned.

adErrStillConnecting	3713	Operation cannot be performed while connecting aynchronously.

adErrStillExecuting	3711	Operation cannot be performed while executing asynchronously.

adErrTreePermissionDenied	3728	Permissions are insufficient to access tree or subtree.

adErrUnavailable	3736	Operation failed to complete and the status is unavailable. The field may be unavailable or the operation was not attempted.

adErrUnsafeOperation	3716	Safety settings on this computer prohibit accessing a data source on another domain.

adErrURLDoesNotExist	3727	Either the source URL or the parent of the destination URL does not exist.

adErrURLNamedRowDoesNotExist	3737	Record named by this URL does not exist.

adErrVolumeNotFound	3733	Provider cannot locate the storage device indicated by the URL. Make sure the URL is typed correctly.

adErrWriteFile	3004	Write to file failed.

adWrnSecurityDialog	3717	For internal use only. Don't use.

adWrnSecurityDialogHeader	3718	For internal use only. Don't use.

AquilaX

____________
умният знае кога да говори, мъдрият знае кога да мълчи

10x

[линк]