We use the 'SQL Server' ODBC driver for (a third party app) wrinting to a MSSS2005 db.
We track a lot of lfoating point values and these are written to the DB every second.
However, sometimes, our field data sources give us very low values (to the tune of 10 ^ -30 and below).
During this, sometimes we have data values going down to 10^-308 and beyond. SQL SERVER can round this value to a zero (0)
but the ODBC driver is not able to handle these numbers. It rejects thaat data piece and since the field end is sending data continuously,
between the data source sending data and the ODBC continously rejecting data, we are hanging up operations.
Can any one suggest a resolution on this. On the DB itself, we have tried limiting the format to 'real' than a 'float' , but the issue is with the ODBC , rejecting the value. Is there a fix to the current SQL SERVER ODBC driver, which can handle or truncate
Any help is appreciated.
Our MDAC version is 2000.086.3959(srv03_sp2_rtm.070216-1710)
View Complete Post