Subject | Re: [firebird-support] Excel Query to firebird db using firebird ODBC driver |
---|---|
Author | Emerson Muniz |
Post date | 2005-03-09T12:05:14Z |
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
emersonmuniz@...
ejms@...
Nova Andradina - MS - Brasil
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
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--- Martijn Tonies <m.tonies@...> wrote:
> > expand a table to view its fields, I receive the
> following error message:
> >
>Emerson Muniz
> 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
>
>
>
>
>
>
emersonmuniz@...
ejms@...
Nova Andradina - MS - Brasil
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com