> > >I just started to use Firebirs so I am a newbie. I first started
> out
> > >using the Firebird ODBC driver to connect Brio client to the
> > >employee.fdb example. I had no problems querying this db. I then
> > >created a new fdb and created one table, and then created the ODBC
> > >connection. I then connect to the new fdb using Brio and it sees
> the
> > >single table but when I try to query it I get the error "SQL Error
> > >Code = -204, Table unknown". Why am I getting this?
> > >
> > >Dave
> > >
> > >
> > Dave,
> >
> > Give us a bit more information...
> >
> > What the Create table Statement ?
> >
> > What is the select statement that are giving errors.
> >
> > I could think a thing at first sight, Quoted Identififers.
> >
> > When you create a table like this:
> > create table "Foo"(a integeer);
> >
> > you should ALWAYS use
> > select * from "Foo"
> >
> > Quoted Identifier is a pain....
> >
> > see you !
> >
>
> I use IBOConsole to create the table so I don't know if double quotes
> where used. All I know is that both Brio and MS Access cause a ODBC
> error "unknown table" when trying to query it. MS Access won't let me
> put " around the table name as it says invalid syntax. In Brio I
> can't change the from clause and it doesn't use " to enclose the table
> name. Please advise.
>

Well, I recreated the table using isql and DIDN'T use quoted
identifiers. Brio and MS Access can now query the table with no
problems. Why is FB so picky about quoted identifiers?

Thanks, Dave