Hi,

> I tried to use firebird throw MS reproting services. I was able to
> connect on my database. But when i tried to execute my sql statement
> example "select * from crs". i had this error
>
> Dynamic SQL Error
> SQL error code = -104
> Token unknown - line 2, char 12
> [
> The following statement executed when creating named query:
>
> SELECT dbo.[CRS].*
> FROM [dbo].[CRS]

Two things are wrong --

Apparently, the MS reporting services thingy is trying to add
an owner, "dbo" by default. Firebird doesn't have these.

And it tries to use the non standard "[" for delimited identifiers,
while " is the SQL standard.

Better check some options to see if you can modify this behaviour.

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com