Emerson,

Thanks for your follow-up to my posting.

My interest in accessing the Firebird DB from Excel was only to see if I
could. That was not my preferred route. Actually, I am working on a VFP
database, and would like my VFP app to be able to read data from the
Firebird DB via ODBC. And, that seems to work OK from VFP.

So, at this point, I am going to let the Excel question rest.

Jim

_____

From: Emerson Muniz [mailto:emersonmuniz@...]
Sent: Wednesday, March 09, 2005 1:38 PM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Excel Query to firebird db using firebird
ODBC driver



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/


Yahoo! Groups Sponsor

ADVERTISEMENT

<http://us.ard.yahoo.com/SIG=129mpkvna/M=298184.6018725.7038619.3001176/D=gr
oups/S=1705115386:HM/EXP=1110479924/A=2593423/R=0/SIG=11el9gslf/*http://www.
netflix.com/Default?mqso=60190075> click here

<http://us.adserver.yahoo.com/l?M=298184.6018725.7038619.3001176/D=groups/S=
:HM/A=2593423/rand=376010357>

_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/


* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]