strange problem

  • - I have inserted 4 columns in an existing database (25000 records)

    - I populate a crystal report state using a stored procedure that queries these columns .It works fine when I display the report within Crystal report. When I try to display that state through Crystal webserver, I get an error

    - I access that database through a dll I have written. When my dll tries to write to these new columns (through ODBC), I get an error. If I write to the other columns it works fine.

    QUESTION : Is it possible that when you add new columns, security attributes are different, than existing columns

    Best regards,

    Nicolas

  • hi lenyn

    Can you tell us what is the error you get?

  • Sounds like something has not been recompile/updated? Used to use Smart Viewer and remember the TTX files needed to be updated.

  • I got the problem answer. When using crystal report, two system environment variables need to be created (TMP and TEMP) and they need to point on a directory of your choice. That directory needs to be "write-enabled" to the crystal web server. Doing it it solved my issue. It was looking like it was a SQL pb. WHATEVER, THANK YOU VERY MUCH FOR YOUR HELP

    Nicolas

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply