I have an odbc application that is designed to use an application role.
The role has been set up already outside the application and it exists
in the database. The application is getting the following error:
Application roles can only be activated at the ad hoc level.
This is the first sql statement issued to the database after connection.
It is a direct exec sp_setapprole statement and not issued from within
a stored proc. I am not sure what is going on.
Any help will be much appreciated.
N.
