|Subject||Re: Firebird ODBC Driver Unknow Table Error|
> > >I just started to use Firebirs so I am a newbie. I first startedWell, I recreated the table using isql and DIDN'T use quoted
> > >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
> > >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.
identifiers. Brio and MS Access can now query the table with no
problems. Why is FB so picky about quoted identifiers?