We have an ASP page that grabs data from an Oracle 9i table and then dumps
it into another. It had been working great until we swapped out servers.
After the swap, it only grabs the whole number from the Oracle db. The
Oracle db stayed the same. It is on another computer all together. The
old webserver and the new webserver are both running Win 2000 server. The
only thing that changed was the hardware and the Oracle ODBC. When I use
the Oracle SQL Worksheet to view the record it show the number with the
decimal.

Do you think the Oracle ODBC could be causing the problem?

Below is the code that grabs the data and Form_D3
is the item in question.

mySQL="select * from EOFGMULTIGROUPED2"
mySQL=mySQL & " where LOC_DESC='" & form_Loc & "'"
mySQL=mySQL & " order by Class,ITEMNO,LotNo"

' response.write "</br>sql=" & mySQL

set conntemp1=server.createobject("adodb.connection")
conntemp1.open myDSN
set rstemp1=conntemp1.execute(mySQL)

' If Not rstemp1.eof then

' ***** Now lets grab the PNs *****
do while not rstemp1.eof
Form_D1=rstemp1("ITEMNO")
Form_D2=rstemp1("DESCRIP")
' Form_D3=rstemp1("SumOnHand")
Form_D3=round(rstemp1("SumOnHand"),5)
Form_D4=rstemp1("Class")
Form_SumRG_OnHand=rstemp1("SumRG_OnHand")
if isnull(rstemp1("LotNo")) then
Form_D5="NoLot"
else Form_D5=rstemp1("LotNo")
end if

response.write "</br>ITEMNO=" & Form_D1
response.write "</br>SumOnHand=" & Form_D3