I have just sent a copy of a database back to the UK with a VB application that uses ADO to access the data. The database was created on a machine with the Locale set to English (Australia). Everything works fine over here and error messages are returned accurately.
When the same application runs in London on a machine with the Locale set English (United Kingom) the returned error description is a null, string which at runtime results in the infamous "Method ?~? of object ?~? failed" at runtime. If the Locale on this machine is set to English (United States) the messages reappaear again.
I am just seeking information on ADO, SQL Server and Locale that will help me understand and rectify this situation.