IIS7 - Classic ASP

Re: AddNew() date problem

DanOrc — Fri, 23 Oct 2009 21:20:38 GMT

I know what I have to do...but in an application with over 2500 asp pages it's too late.

But this is not happening in IIS 4,5,6...

Re: AddNew() date problem

CarlosAg — Fri, 23 Oct 2009 20:16:46 GMT

The best thing you can do is if your data type in SQL is a date you should send a Date and not let some layer do the transformation from string to date since that can easily be impacted by locale of the servers, thread, api's, sql settings and many other factors that are not really bugs but just the right behavior.

Could you maybe use something like

RS("data")= DateSerial(2009, month, day)

Re: AddNew() date problem

DanOrc — Fri, 23 Oct 2009 19:21:59 GMT

Hello,

thanks so much for answer, I did put a Cdate() but this didnt solves the problem. I still have this big big problem. If you can suggest anything else I would appreciate.

If I could somehow send you a 1 simple page application to demonstrate the behaviour maybe you will be able to submit a bug to the testers/developers team...

Thank you very much.

Re: AddNew() date problem

steve schofield — Thu, 18 Jun 2009 23:49:53 GMT

This is a datatype issue between ADO and SQL Server. I'd try putting CDATE function around the date 'data'. Probably a newer version of ole-db causing the odd behavior. What do you see in sql profiler when the data is attempting to be written?

AddNew() date problem

DanOrc — Wed, 17 Jun 2009 09:17:25 GMT

hello,

i have an app that was developed with classic ASP(VBScript). my regional language and settings is Romanian. i've copied the local settings to reserved accounts. the database is SQL 2000.

when i write this:

"insert into import_curs (data, valoare) select '06/09/2009', 1571.23 " it's ok. the month is 6, day 9.

but when i write this:

RS.Open "import_curs",Conn,3,3
RS.AddNew()
RS("data")="06/09/2009"
RS("valoare") = 1571.23
RS.UpdateBatch(adAffectAll)
RS.Close

the month is 9 and the day is 6. i really dont know what and where to change this behavior. i have to mention that this is working well in IIS 5.1, IIS 6.

thank you in advance.