We are developing a three-tier application using VB5 for the front end, VB5
ActiveX DLLs for the business services running under Microsoft Transaction
Server 2, and Microsoft SQL Server 6.5 for the data services. When running
under MTS, users keep receiving an error message from SQL Server saying that
it has changed the default language to us_english. On further investigation,
this appears to be an informational message only, but ADO is interpreting it
as a real error which it is then raising to the calling component, hence the
users see an error message and their transaction is aborted. We have tried
changing the character set ot the SQL Server to us_english, but this has
made no difference.
Has anyone else come across this? Is there a way to turn these messages off
in SQL Server?
Any assistance gratefully received.
London, UK :-)