Re: handling ado errors

"Marius Kavaliauskas" <markav@xxxxxxxxxxx> wrote:

> I have ADP (Access 2003) nad I have difficulty handling ADO errors.
>
> I have table that has some fields that have to be unique. When enters
> udplicate data in these fields, he gets an error:
>
> Violation of Unique key constraint 'XXX'. Cannot insert duplicate key in
> object 'YYYY'
>
> The main problem is that Form_Error is called and DataErr has the value
> 2627. How to get the real problem, because I want to thranslate errors to
> Lithuanian language?

Have you thought about translating the SQL-Server sysmessages table?
SQL-Server by itself does support localized errormessages and it does
support the Lithuanian-Langugage (mslangID = 1063). Unfortunately
AFAIK Microsoft does not supply a localized version of sysmessages
in Lithuanian.

If you add translated messages to the sysmessages-table of SQL-Server
and set the appropriate language for the SQL-Server Logins you may
solve your problem without changing a single line of code in you
application.

Read the chapter "SQL Server Language Support" in the SQL-Server
documentation for further information.

Cheers
Phil
.

Relevant Pages

  • Re: French, German, Italian SQL Query via ADO
    ... conversion) and use only typed values to communicate with the SQL-Server. ... However, with each user account, there is a default language. ... set language english ... I have a SQL query generator which does something like: ...
    (microsoft.public.data.ado)
  • Re: handling ado errors
    ... access sets language back to english ... and displays english error. ... > Have you thought about translating the SQL-Server sysmessages table? ...
    (microsoft.public.access.adp.sqlserver)
  • Re: count function - calculations
    ... language or to SQL-Server then newsgroups such as m.p.sqlserver.programming ... Total From Order Group by orders) as SQ ... Sylvain Lafontaine, ing. ...
    (microsoft.public.access.adp.sqlserver)