Subject Re: Firebird ODBC Driver Unknow Table Error
Author googlepost123
--- In, Alexandre Benson Smith
<iblist@t...> wrote:
> googlepost123 wrote:
> >Hi,
> >
> >I just started to use Firebirs so I am a newbie. I first started
> >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.