asked on

CRYSTAL Reports - File integrity error

Hi

We have created an ODBC connectivity to Oracle using Oracle 8 ODBC Driver. We are trying to access Oracle Database using the ODBC connectivity in Crystal Reports and we face the folowing Error Message when we try to choose the table.

"Error opening the File"
"There are no fields in the file <schema Name.table Name>"
"file integrity Error"

karoo

hi AnandKy,
That is a problem with the ODBC driver, switching to the native oracle driver will solve your problem.

Oracle 8i driver:
http://support.seagatesoftware.com/communityCS/FilesAndUpdates/cror815.zip.asp

AnandKy

ASKER

We are using the native oracle diver "oralce ODBC driver 8.0"
and crystal report 4.6.1

karoo

I applogise, the link that I provided is actually the latest 8I ODBC driver.

karoo

Are you able to create a report from a different type of database, say M$ Access?

karoo

one more Q: are you trying to repor of a Oracle Stored procedure or table?

AnandKy

ASKER

Hi karoo

i think we got the problem. If the table name has a "underscore" it throws up that error. for example if the table name is "emp" then it works fine and if we rename that to say "trg_emp", it throws up that error. Can u pls let us know how we can overcome this.

ASKER CERTIFIED SOLUTION

karoo

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

karoo

one more thing:

get the 8.0.4.4.0 of the Oracle ODBC driver

karoo

hi AnnandKy, any news?

AnandKy

ASKER

Thanks a lot. That's solved my problem.
thanks again.