Numeric fields are rounded 16 Bit BDE > ODBC SQL Server 2..

Hi all,

I'm getting mad about a problem, where I can't find a solution.

Parts of an old delphi client / server application (16 Bit) runs under
XP, uses 16 bit bde and 32 Bit ODBC to connect to a 64 Bit SQL Server 2005.
Everything works o.k., but when numerical data is to be updated or
inserted, all floats are rounded to the nearest integer. (12.543 => 13,
322.12 => 322).
These rounded values are stored to the database.
The same client configuration with the same database in a 32Bit SQL
Server runs o.k. ( The database had been exported from the 64 bit system
and imported into the 32 bit system).

Any suggestions? What can I do?

TIA,
Uwe.


The profiler trace shows the following:
Not that all "decimal(15,0)" fields below are decimal(15, 5) in reality!

exec sp_executesql N'INSERT INTO PRUFEN2 (PANR ,KUNDENNR ,INVNR ,PPLANNR
,ANDSTAND ,MERKMALNR ,MERKMALBEZ ,SOLLCOUT ,MASS ,PMNR ,BEARBEITER
,NUMMER ,SOLLFUNK ,INFOFLAG ,COLCOUNT ,C1 ,C2 ,C3 ,C4 ,C5 ,C6 ,C7
,MASSSTATUS ,MASSERG ,MERKMALERG ,ERGEBNIS ,FLPRINT ) VALUES (@P1, @P2,
@P3, @P4, @P5, @P6, @P7, @P8, @P9, @P10, @P11, @P12, @P13, @P14, @P15,
@P16, @P17, @P18, @P19, @P20, @P21, @P22, @P23, @P24, @P25, @P26,
@P27)',N'@P1 varchar(31),@P2 varchar(31),@P3 varchar(31),@P4
varchar(31),@P5 varchar(31),@P6 varchar(31),@P7 varchar(31),@P8
decimal(10,0),@P9 decimal(15,0),@P10 varchar(21),@P11 varchar(31),@P12
decimal(10,0),@P13 decimal(10,0),@P14 decimal(10,0),@P15
varchar(31),@P16 varchar(31),@P17 decimal(15,0),@P18 decimal(15,0),@P19
decimal(15,0),@P20 decimal(15,0),@P21 decimal(15,0),@P22
decimal(15,0),@P23 decimal(10,0),@P24 decimal(10,0),@P25
decimal(10,0),@P26 decimal(10,0),@P27 decimal(10,0)','ohne','1','TEST
KM','TEST
KM','a','M1','1',0,-1,'MDMS','Supervisor',1,0,0,'','',10,0,0,0,0,0,0,0,3,3,1