Subject | Re: [firebird-support] Excel Query to firebird db using firebird ODBC driver |
---|---|
Author | Martijn Tonies |
Post date | 2005-03-09T12:11:06Z |
> Just for register question, I'm using on my server theYes, but what ODS version is your database?
> 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.
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
>
>
>
>
>
>