Overflow Problem [SOLVED]
I have an ASP application that is generating a mysterious Overflow error.
The ASP pages use a DLL to access a SQL Server 2000 database. I am having this problem on only one server. It runs perfectly on multiple other servers. All the code and ASP pages are exactly the same on all the servers. I have even tried restarting IIS and SQL Server. All the servers also have all the latest Service Packs installed. The funny thing is that it used to work up until two days ago, mysteriously.
Has anyone seen this kind of thing? Or, know of a solution?
If figured this out. The datatype of one of the functions in the DLL was of type Integer and it was returning a value of greater than 32768. So I changed it to a datatype Long.