sql server - How to check which locale is a .NET application running under, without having access to its sourcecode? -

-

context: i'm in charge of running service written in .net. proprietary application. uses sql server database. ran user member of administrators group in local machine. worked alright before added machine domain.

so, added machine domain (win 2003) , changed user member of power users group , now, the

problem: of sql sentences tries execute "magically" in spanish localization (where , separates floating point numbers instead of .), leading errors.

there fewer columns in insert statement values specified in values clause. number of values in values clause must match number of columns specified in insert statement. @ system.data.sqlclient.sqlconnection.onerror(sqlexception exception, boolean breakconnection)

operating system , regional settings in machine in english. asked provider of application , said:

looks have combination of code running under spanish locale, , sql server under english locale. sql expects '15.28' , not '15,28'

which looks wrong me in various levels (how can sql server distinguish between commas separate arguments , commas belonging floating point number?).

so, code seems grabbing spanish locale somewhere, don't know if it's user runs as, or someplace else (global policy, maybe?). question is

what places localization defined on machine/user/domain basis?

i don't know places must search culprit, please me find it!

there 2 types of localisation in .net, both settings cultures can found in these variables (fire .net command line app on machine see says):

system.thread.currentthread.currentculture & system.thread.currentthread.currentuiculture

http://msdn.microsoft.com/en-us/library/system.threading.thread_members.aspx

they relate settings in control panel (in regional settings part). create .net command line app, call tostring() on above properties, should tell property at.

edit:

it turns out setting locales per user held here:

hkey_current_user\control panel\international

it might worth inspecting registry of user spanish locale, , comparing 1 set or whichever locale require.


Comments

Post a Comment

Popular posts from this blog

c++ - How do I get a multi line tooltip in MFC -

-
right now, have tool tip pops when hover on edit box. problem tool tip contains multiple error messages , in 1 long line. need have each error message on own line. error messages contained in cstring new line seperating them. my existing code below. bool ontooltiptext(uint, nmhdr* pnmhdr, lresult* presult) { assert(pnmhdr->code == ttn_needtexta || pnmhdr->code == ttn_needtextw); // need handle both ansi , unicode versions of message tooltiptexta* pttta = (tooltiptexta*)pnmhdr; tooltiptextw* ptttw = (tooltiptextw*)pnmhdr; // tchar szfulltext[256]; cstring strtiptext=_t(""); uint nid = pnmhdr->idfrom; if (pnmhdr->code == ttn_needtexta && (pttta->uflags & ttf_idishwnd) || pnmhdr->code == ttn_needtextw && (ptttw->uflags & ttf_idishwnd)) { // idfrom hwnd of tool nid = ::getdlgctrlid((hwnd)nid); } //m_errprojaccel[ch] contains 1 or more error messages each...
Read more

asp.net - In javascript how to find the height and width -

-
i having .aspx , masterpage page. in masterpage loading aspx page . in aspx page design using generating table structure using code-behind server in javascript how find height , width . regards, kumar if you're looking table height , width, should it var tbl = document.getelementbyid('tbldemo'); alert(tbl.offsetwidth + '\n' + tbl.offsetheight);
Read more

c# - DataTable to EnumerableRowCollection -

-
i have datatable according client requirement can contain invalid date "00/00/1999",null,empty string.(typed datset) when collect them enumerables wish convert of invalid forms empty string. (i.e) enumerablerowcollection<datarow> query = order in _table.asenumerable() select new { orderdate= string.isnullorempty(convert.tostring(order.field<datetime>("orderdate")) || (how check date invalid date) ? string.empty : order.field<datetime>("orderdate") } how check whether date valid date or not? datetime.tryparse...like given current code: datetime date; enumerablerowcollection<datarow> query = order in _table.asenumerable() select new { orderdate= string.isnullorempty(convert.tostring(order.field<datetime>("orderdate")) || !datetime.tryparse(convert.tostring(order.field<datetime...
Read more