My company has four web servers running copies of same ASP web application. One of the servers is running on windows 2000 Advanced server edition (without service pack) , MDAC 2.6. The other three servers had windows NT OS and MDAC Version 2.5 installed. We use microsoft SQL server 7.0 as backend. We migrated the NT servers to windows 2000 with service pack 4. We are now facing lot of problems with frequent page crashes in the ASP application.

The point of failure is passing date and numeric parameters to a Stored procedure using a ADO command object. The error message appearing is " Application uses value of wrong type for the current operation".Worst case is that the decimal points in numeric fields are not detected and the numeric values are stored without decimal points resulting in absolute chaos.

When we change the code by formatting the datatype using functions CDate, CDbl or CInt , the code works fine.
The regional settings are all same as before. We cannot afford to change the code as the application is very huge and we cannot allocate resources to debug and test the code base at this time.

We have downgraded the service pack of the three servers to service pack 2 of windows 2000. Now the same code works fine. But we would like to know what went wrong and also want to keep the code base compatible to all service packs.

Have anyone faced similar problems during windows migration? we would be immensely thankful if anybody helps in rectifying this problem.

Hi,

Check if this is not your case

http://support.microsoft.com/default...50&Product=ado

If not, then you would need to post code to reproduce error

hi,

thanks for the reply. but that link did not help. as i told this error
does not happen in all OS. It happens only when run on a server with win
2K without service pack or win 2k with service pack 4. with win 2K and
service pack 2, the code just works fine.

regards,
subby.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!