Select statement returns error

[f1012jasper]

Hi Folks,

Just started using iReport - I am trying o execute a simple select statement and get an error  [Oracle][ODBC][Ora]ORA-00904: "TableName"."FieldName" :Invalid identifier 

My statement is:

SELECT     TableName."FieldName" AS Column1
FROM   "TableName" TableName

Please advice,

Thanks,

Frank

 

 

[pjamack]

 Check to make sure you have the right Database name, right table names, right column names.  
Check to see if you have the right datasource properties set up, right JDBC Oracle driver, etc.

Sometimes you might need to reference domain, server name,etc. 

FOr example 

Your database is called TOYS  and resides on ABC server.   You might need to reference it as ABC.TOYS.tablename  and so on.

[f1012jasper]

Thanks a lot - that was the problem, works like a charm now.

Frank