"Out of Present Range" Error in ASP Database Application, after migrating from Windows 2000 -> Windows 2003
Posted on 2005-04-26
We have an ASP application which uses ADODB to connection to a data source (SQL Server 2000). The developers machines are running Windows XP Professional with MDAC version 2.81. We have recently upgraded our main development webserver to Windows 2003, which is running MDAC version 2.82.
Ever since we have done this, we receive the following error on one of the SQL statements we execute:
2147352566:Out of present range.
For the following SQL:
UPDATE FUEL_ISSUES_FW SET DRIVER_RECORD_NUMBER_FW = (SELECT TOP 1 RECORD_NUMBER_FW FROM DRIVERS_FW WHERE DRIVERS_FW.DRIVER_NAME_FW=FUEL_ISSUES_FW.DRIVER_NAME_FW) WHERE DRIVER_RECORD_NUMBER_FW is null
Searching the web, I saw numerous references to the above error message, but in relation to people putting numbers that were too big in to datatypes that were too small. With regard to the database, the fuel issues table, driver record number field is an INT, and the Driver table, record number is an INT IDENTITY. The script above is a "fixup" script.
As I said before, running from IIS on XP Pro, the above works fine (and that IS running against the same database). Running the same code on a different web server, generates the error. Our previous web server was Windows 2000 Server, and we didn't have the problem on that.
Thanks in advance!