sql server 2012 - MSSQL query no longer works with Windows 10 client: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value -


we have been using following sql query long time in winforms program no problems, until end users upgraded windows 10.

they exception:"error [22007] [microsoft][sql server native client 11.0][sql server]the conversion of varchar data type datetime data type resulted in out-of-range value."

this error has been posted inside here earlier, did not find post occurrence connected windows 10 upgrade.

the query targeted sql server 2012, using native client 11. works on windows 7 , 8, throws exception in windows 10: 

select distinct tblemployee.employeeid, tblemployee.lastname, (coalesce(tblemployee.firstname, '') + ' (' + coalesce(tblemployee.employeeidtext, '') +')' ) firstname  tblemployee  left join tblassignmentservice on tblemployee.employeeid = tblassignmentservice.employeeid  tblassignmentservice.servicedate >= '2015-08-31 00.00.00'  , tblassignmentservice.servicedate < '2015-09-07 00.00.00'  order tblemployee.lastname;

the place datetime fields used in clause, , query works fine against same db windows 8 client. both clients run einglish windows versions. interesting observation query accepted microsoft sql management studio on windows 10 machine. not through native client. dates used in filter created in our program through gui.

have else experienced strange things native client on windows 10, or have suggestion how problem may solved?

i confirm the solution purposed in thread solved problem.

after research found tostring("yyyy-mm-dd hh:mm:ss") call responded differently in windows 7 , windows 10 if current culture set "no" or "nb-no" @ runtime (thread.currentthread.currentculture = new cultureinfo("no");).

the suggested modification did trick: tostring("yyyy-mm-dd hh:mm:ss", cultureinfo.invariantculture). solves problem, dots in time formatting root cause.

but should tostring("yyyy-mm-dd hh:mm:ss") return different formatting in same culture depending on os? :o kind of scary.


-

Comments

Post a Comment

Popular posts from this blog

c# - Binding a comma separated list to a List<int> in asp.net web api -

the default binder in web api expecst http://url.com/webapi/report/?pageids=3243&pageids=2365 to bind public ihttpactionresult report(list<int> pageids){ // exciting webapi code} i wish bind http://url.com/webapi/report/?pageids=3243,2365 as running out of space in url get . i have created class public class commaseparatedmodelbinder : system.web.http.modelbinding.imodelbinder { public bool bindmodel(httpactioncontext actioncontext, modelbindingcontext bindingcontext) { //binding in here } } and registered in webapiconfig.cs var provider = new simplemodelbinderprovider( typeof(list<int>), new commaseparatedmodelbinder()); config.services.insert(typeof(modelbinderprovider), 0, provider); i have altered method signature use model binder so public ihttpactionresult report( [modelbinder] list<int> pageids){ // exciting webapi code} however break point in binder not being
Read more

Delphi 7 and decode UTF-8 base64 -

in delphi 7, have widestring encoded base64(that received web service widestring result) : pd94bwwgdmvyc2lvbj0ims4wij8+dqo8c3ryaw5nptiq2lpyqjwvc3ryaw5npg== when decoded it, result not utf-8: <?xml version="1.0"?> <string>طھط³طھ</string> but when decoded base64decode.org, result true : <?xml version="1.0"?> <string>تست</string> i have use encddecd unit decodestring function. the problem have using decodestring . function, in delphi 7, treats decoded binary data being ansi encoded. , problem text utf-8 encoded. to continue encddecd unit have couple of options. can switch decodestream . instance, code produce utf-8 encoded text file data: {$apptype console} uses classes, encddecd; const data = 'pd94bwwgdmvyc2lvbj0ims4wij8+dqo8c3ryaw5nptiq2lpyqjwvc3ryaw5npg=='; var input: tstringstream; output: tfilestream; begin input := tstringstream.create(data); try output := tfilestream.
Read more

html - Is there any way to exclude a single element from the style? (Bootstrap) -

so, have img logo, overlaid on div styled background-image: url("...") , , both elements inside 2 div classes .to-color , .to-overlay respectively, black transparent overlay. is there way exclude logo style given these 2 classes? here's jsfiddle example: link html , css example: - html - <div class="to-color"> <div class="to-overlay"> <div class="respo"> <div class="row"> <div class="col-xs-4 col-xs-offset-4 text-center"> <img src="http://ansonalex.com/wp-content/uploads/2011/06/google-logo-768x260.png" alt="..." class="img-responsive"> </div> </div> </div> </div> </div> - css - .to-color { background-color: #000; } .to-overlay { opacity : 0.5; } .respo { background-image: url("https://source.unsplash.com/category/objects/1600x900"); background-position: center center;
Read more