I am the owner of the database. When I use the query analyzer the command works fine. It is when I try to access it through the application is when it blows up.

Below is how I am accessing it:
lnHandle = SQLCONN("DSN","Userid","password") I get my connection.
lnExe = SQLEXE(lnHandle,"Exec sp_setapprole 'ROLE','Password'") This bombs it returns -1 for lnExe. lnHandle comes back with 1 so I have a connection.

This code is run within an application.

How do you set up your ODBC connection and fire up sp_setapprole?