Subject Re: [firebird-support] Excel Query to firebird db using firebird ODBC driver
Author Martijn Tonies
> Just for register question, I'm using on my server the
> FireBird 1.5.2.4731 and ODBC driver version 1.2.0.69.
> I use the Microsoft Excel 2000, and I view the tables
> and fields withou error message, all right.

Yes, but what ODS version is your database?

And what ODS version is the database of the original poster?

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com

> Regards,
>
> Emerson Muniz
> Brazil
>
> datasource, and view the tables. However, when I
> > click on the plus sign to
> > > expand a table to view its fields, I receive the
> > following error message:
> > >
>
> --- Martijn Tonies <m.tonies@...> wrote:
> >
> > Jim,
> >
> > > I'm working on a WinXP system.
> > >
> > > I just downloaded and installed the Firebird ODBC
> > driver for Windows,
> > > version 1.2, dated 8/26/2004.
> > >
> > > I used that driver to create an ODBC data source
> > connecting to a
> > > Firebird/Interbase database used by a data
> > collection system that we
> > > purchased.
> > >
> > > To test this datasource, I used Excel...Import
> > External Data...New data
> > > query. This presents me with a dialog box from
> > which I am to choose
> > > tables/fields to include in the query. I am able
> > to connect to the
> > > datasource, and view the tables. However, when I
> > click on the plus sign to
> > > expand a table to view its fields, I receive the
> > following error message:
> > >
> > > ", Dynamic SQL Error, SQL error code = -206,
> > Column unknown,
> > > FLD.RDB$FIELD_PRECISION, At line 1, Column 112."
> >
> > Can you check the ODS version of your database?
> >
> > And what version of Firebird are you using?
> >
> > With regards,
> >
> > Martijn Tonies
> > Database Workbench - developer tool for InterBase,
> > Firebird, MySQL & MS SQL
> > Server
> > Upscene Productions
> > http://www.upscene.com
> >
> >
> >
> >
> > Yahoo! Groups Links
> >
> >
> > firebird-support-unsubscribe@yahoogroups.com
> >
> >
> >
> >
> >
> >
>
> Emerson Muniz
> emersonmuniz@...
> ejms@...
> Nova Andradina - MS - Brasil
>
>
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>