We help IT Professionals succeed at work.

SQL Server - OLEDB Provider and Locale

MHorner
MHorner asked
on
Medium Priority
206 Views
Last Modified: 2013-12-25
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.  
Comment
Watch Question

Guy Hengel [angelIII / a3]Billing Engineer
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2009

Commented:
i saw that you had already asked similar question:
http://www.experts-exchange.com/jsp/qShow.jsp?ta=vbdatabases&qid=20124720

I am curious as you to understand this messages...
CHeers

Author

Commented:
I did post a simlar message about 6 months ago that was solved by set the default locale on my workstation. After I did this ADO started returning error messages from SQL Server and stopped giving "Method ?~? of object ?~? failed".

This problem is occurring on a mchine that actually has its default Locale set correctly BUT ADO has stopped returning messages from SQL Server. I am assuming that this has occurred after thy have done an sp_attach of a database that I have sent them from here.

I might be barking up the wrong tree but I am hoping someone will tell me if I am.
TimCotteeHead of Software Services
CERTIFIED EXPERT

Commented:
MHorner, are these standard error messages in Sysmessages or user-defined ones? If the former then you could check that the correct localised message exists in sysmessages.

English (UK) = 1033
English (Aus) = 3081
Senior .Net Consultant
CERTIFIED EXPERT
Top Expert 2016
Commented:
I just had this problem because the decimal separator was set to , instead of .

Author

Commented:
I am currently checking with London to see what mslangid values they have in Sysmessages.

Author

Commented:
Someone it seems very wrong that changing teh decimal seperator would have such a potentially serious effect. I am checking with London to see ehether they have done anything like this.
I have been asked to close this question and would like to hear from the experts involved. I will give this question 7 days before resolving it with the comment from emoreau. OR from hearing from the other experts involved.

kb
Community Support Moderator
Experts Exchange

Explore More ContentExplore courses, solutions, and other research materials related to this topic.