unable to access data dictionary

[Ewan_(Guest)]

I am trying to use R&R with a SQL server database. I have installed it on XP with the options :__Workstation/typical/ODBC Core Files AND SQL Server. This seems to be OK apart from the fact that I cannot get access to the data dictionary which it says does not exist or is invalid with this version.__Any ideas on how to fix this greatly appreciated.__Ewan

[kfleming]

Do you have an /RL folder below the R&R folder and does it have DATADICT.EXE in that folder?____Kathleen__R&R Support

[Ewan_(Guest)]

Do you have an /RL folder below the R&R folder and does it have DATADICT.EXE in that folder?____Yes. Both are present.__Regards__Ewan

[kfleming]

Do you have full rights to the files in the RL folder?____What is the exact error you are getting?____Kathleen__R&R Support

[Ewan_(Guest)]

Yes, I have full access rights on the RL dir.____Sequence of events is as follows:__R&Rv10 - report designer____- open existing report____- select report____- enter login details____- Menu - Database/sql select:_____change values in sql where clause____- OK____ERROR - "Must specify additional parameters"____- ignore and continue____ERROR - "Data Dictionary is not available or installed correctly"____- OK____- File/Print Preview (successfully displays output).____Screenshots available if required.____Regards__Ewan

[kfleming]

What is the SQL SELECT statement that you are changing?____The dictionary error must be a residual of whatever is happening when you edit the where and may not really mean that there is a dictionary problem.____Kathleen__R&R Support

[Ewan_(Guest)]

Set @SelectStatement = ^<<(Select tb_job.jobid from tb_job where upper (TB_Job.Reference) >= upper(^^SL027018^^)__And upper (TB_Job.Reference) <= upper(^^SL027068^^) )>>^____changed to:____Set @SelectStatement = ^<<(Select tb_job.jobid from tb_job where upper (TB_Job.Reference) >= upper(^^SL027018^^)__And upper (TB_Job.Reference) <= upper(^^SL027078^^) )>>^____Regards__Ewan