Thanks Roman
This works fine :)

Regards
Plutarco Gonzalez


--- In Firebird-Java@yahoogroups.com, "Roman Rokytskyy"
<rrokytskyy@...> wrote:

>
> Use
>
> select * from "pedimentos"
>
> instead. You very likely created table with quoted identifier, so

you have

> to use it everywhere now.
>
> Roman
>
> On 16:53:36 2007-04-14 "Plutarco" <plutarco_gonzalez@...> wrote:
> > Hi, I setup Coldfusion MX 7 to use firebird 2.0
> > but have this error message
> >
> > -----------------------------------------------------------------

----

> > GDS Exception. 335544569. Dynamic SQL Error SQL error code = -204
> > Table unknown PEDIMENTOS At line 1, column 15
> >
> > The error occurred in C:\Inetpub\wwwroot\iON\prueba.cfm: line 1
> > Called from C:\Inetpub\wwwroot\iON\prueba.cfm: line 1
> > Called from C:\Inetpub\wwwroot\iON\prueba.cfm: line 1
> >
> > 1 : <cfquery name="test" datasource="pruebas" username="SYSDBA"
> > password="masterkey">
> > 2 : select * from pedimentos
> > 3 : </cfquery>
> >
> > SQL select * from pedimentos
> > DATASOURCE pruebas
> > VENDORERRORCODE 335544569
> > SQLSTATE HY000
> > -----------------------------------------------------------------

----

> >
> > my datasource "pruebas" (DBfirebird= test.ddi) include table
> > named "pedimentos" with two fields "trafico" and "pedimento" I

check

> > this with IBExpert, but i dont understand GDS Exception
> >
> > anyone can help me
> >
> > Many thanks
> >
> > Plutarco
> >
> > --- In Firebird-Java@yahoogroups.com, "Mike Hickman" <mikehi@>
> > wrote:
> > >
> > > Thanks to Claus Heeg and Ramon for replying and setting me on

the

> > > right track.
> > >
> > > So easy and logical once when the configuration is pointed

out.

> > >
> > > Many thanks
> > >
> > > Mike Hickman
> > >
> > >

__________________________________________________________________

> > > --- In Firebird-Java@yahoogroups.com, "rockxwre" <rockxwre@>

wrote:

> > > >
> > > > Hi Mike,
> > > >
> > > > Haven't tried it in MX 7 but in MX 6 you could do the

following:

> > > >
> > > > - copy the necessary jars (jaybird-full-2.1.0.jar and maybe
> > more) to
> > > > \CFusionMX\wwwroot\WEB-INF\lib folder;
> > > > - restart ColdFusion;
> > > > - go to the ColdFusion Administrator;
> > > > - go to Datasources;
> > > > - fill in a Data Source Name, choose the Driver "other" and
> > > > click "Add";
> > > > - a new form appears, fill in JDBC URL, this is something

like:

> > > > jdbc:firebirdsql://localhost:3050/<path-to-db>
> > > > - fill in the Driver Class: org.firebirdsql.jdbc.FBDriver;
> > > > - fill in the Username and Password fields;
> > > > - click "Submit";
> > > > - check if it works by using the Verify button.
> > > >
> > > > Done!
> > > >
> > > > Since there are no big differences on this part in MX 7, I
> > expect
> > > > this should work for you too.
> > > >
> > > > Bye,
> > > > Ramon
> > > >
> > > > --- In Firebird-Java@yahoogroups.com, "Mike Hickman"

<mikehi@>

> > > > wrote:
> > > > >
> > > > > Does anyone have any experience using the Driver with
> > Coldfusion
> > > > MX 7 ?
> > > > >
> > > > > I am testing Coldfusion Developer edition for use with
> > Firebird 1.5
> > > > > database's.
> > > > >
> > > > > How do I create a datasource or make available a Firebird
> > database
> > > > to
> > > > > a Coldfusion Server?
> > > > >
> > > > > I have not used drivers in the past so I have no clue as

to

> > where
> > > > to
> > > > > start.
> > > > >
> > > > > I have downloaded the drivers. What do I do next ?
> > > > >
> > > > > Assistance/hints appreciated
> > > > >
> > > >
> > >
> >
> >
> >
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
>