Subject | Oledb/ODBC not able to read numeric |
---|---|
Author | gbulleri |
Post date | 2005-03-23T20:22:42Z |
Hi,
Just my first post..... If someone can help me....
I am Working with SQL Server T-SQL and I am using OPENQUERY over an
ODBC connection to Firebird 1.5. , for example:
select * from openquery(firebird,'select * from table')
the problem is that the driver cannot read a NUMERIC(15,6) field ...
in FB for example I see 1.123456 but the OLEDB/ODBC driver get
0.00001;
Any idea?
Thanks
GB
Just my first post..... If someone can help me....
I am Working with SQL Server T-SQL and I am using OPENQUERY over an
ODBC connection to Firebird 1.5. , for example:
select * from openquery(firebird,'select * from table')
the problem is that the driver cannot read a NUMERIC(15,6) field ...
in FB for example I see 1.123456 but the OLEDB/ODBC driver get
0.00001;
Any idea?
Thanks
GB