>Has anyone ever tried to connect to SQL through the application role. I am tring to fire up the sp_setapprole through an ODBC connection and it is not working. When I fire up the sp_setapprole through the query analyzer it works fine.
> Has anyone else had this problem and if so have they been able to resolve it.
>
>Thanks ahead of time.
What's the error?
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown