Thanks for your answer

I use Firebird_ODBC_1.2.0.69; OLEDB driver MDAC 2.8

If I work directly with the ODBC driver all OK;
It seem that the problem is in the OLEDB driver;

I have bypassed the error in this way:

select * from openquery(firebird,'select numeric_field*1 from table')

multypling the numeric field for 1 !!!!!


Bye
GB



--- In firebird-support@yahoogroups.com, Alexandre Benson Smith
<iblist@t...> wrote:

> gbulleri wrote:
>
> >
> >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
> >
> >
> What ODBC driver ?
>
> Did you get correct results if you use he smabe ODBC connection in
> another app ?
>
> see you !
>
> --
>
> Alexandre Benson Smith
> Development
> THOR Software e Comercial Ltda.
> Santo Andre - Sao Paulo - Brazil
> www.thorsoftware.com.br
>
>
>
> --
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.0.308 / Virus Database: 266.8.1 - Release Date:

23/03/2005