Hi Jim,

I'm new to Firebird too... :-)

1. I use the IbExpert Personal to create my database,
and it give me the ODS version in properties.

2. I don't know if the IBSERVER 6.2.2.908 work fine
with the Firebird ODBC 1.2.0.69.

3. I use the same ODBC version..., so..., other can
help us about the IBSERVER 6.2 with this ODBC version.

4. I don't know if the MS-Excel 2003 Query is very
diferent from MS-Excel 2000, but this can be a
problema too.

Well, I think the problem can be IBSERVER 6.2 or
MS-Excel 2003 Query. But we need a confirmation with
other member this group.

Regards,

Emerson Muniz
Brazil

--- Jim Walsh <DrJimWalsh@...> wrote:

> I'm the original poster.
>
> I'm new to Firebird, so this may require some
> patience.
>
> 1. I don't know the ODS version of my database. Can
> you tell me how to
> determine that?
>
> 2. The version numbers on IBSERVER & IBGUARD are
> 6.2.2.908, dated 12/11/2002
>
> 3. Firebird ODBC version 1.2.0.69
>
> 4. Excel 2003
>
> Incidentally, I was using Excel Query just to check
> out the Firebird ODBC
> driver. When that didn't work, I tried accessing the
> database from a VFP
> View using the Firebird ODBC driver. This is
> actually my primary goal. And,
> this seems to work just fine, although it seems very
> slow, even when the
> database is located on the same machine.
>
> Thanks for your help.
> Jim
>
> _____
>
> From: Emerson Muniz [mailto:emersonmuniz@...]
> Sent: Wednesday, March 09, 2005 9:31 AM
> To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] Excel Query to
> firebird db using firebird
> ODBC driver
>
>
> 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
>

=== message truncated ===


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/