I am getting - Failed to retrieve data from the database - Database Vendor Code: 229
on Logicity 1.7.0008 - Crystal 11 - MS sql and MS Terminal Server
RRD works as administrator - but not as this user.
Report uses ODBC windows authentication.
Other reports run - This report uses SQL Procedure with link to table.

That would be a rights issue for the user connecting to the database. Is the ODBC connection setup as a System DSN and not as a User DSN?

If that is setup right, then I would guess its the users rights to the SQL Procedure or the linked table.

Thanks!
Brian

Thanks for pointing me in the right direction. It works when I create a user dsn
on the terminal server.
(normally only use the system dsn). I also had to give the user the rights to
execute that stored procedure.
Thanks of the help.
John