Subject Re: [firebird-support] Excel Query to firebird db using firebird ODBC driver
Author Emerson Muniz
Ops...

Sorry, I forgot about the OSD... :-)

OSD Version: 10.1

About original poster we need wait... heheh

Regarts

Emerson Muniz
Brazil

> Yes, but what ODS version is your database?
>
> And what ODS version is the database of the original
> poster?



--- Martijn Tonies <m.tonies@...> wrote:
>
>
> > 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
> >
> >
> >
> >
> >
> >
>
>
>
>
> Yahoo! Groups Links
>
>
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
>
>
>

Emerson Muniz
emersonmuniz@...
ejms@...
Nova Andradina - MS - Brasil








__________________________________
Celebrate Yahoo!'s 10th Birthday!
Yahoo! Netrospective: 100 Moments of the Web
http://birthday.yahoo.com/netrospective/