Subject Re: [firebird-support] Excel Query to firebird db using firebird ODBC driver
Author Emerson Muniz
Hi 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.

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