I got an ASP page (Classic ASP) that was designed 6 years ago to import data to SQL 2000. the page was running on Windows 2000 IIS 5. I want to upgrade the server to Windows 2003 R2 and move the page there but I came across an issue when I was testing it.
It seems that IIS 6 is removing the leading zero from the data.
I created a file called test.csv in notepad:
I used the application on IIS 5 and data got imported to SQL just fine. Zero was not removed.
I then use the same file in IIS 6 and leading zero in 01233 is being remove when data are being imported.
Data are getting import to the same SQL server.
Is this an IIS setting or do I need to get a programmer to fix the application?
if IIS setting how can I fix this?