Jean
9/30/2002 2:32:00 PM
Hi to all!!
I'm developing a web application using asp.net and Sql
Server 2000.
I would to use sp_setapprole stored procedure to set
application role for db.
Now I'm encountering a lot of problems using SQLData
object.
Infact I tried to make a new SqlConnection and a
SqlCommand that execute "EXEC sp_setapprole 'AppRoleName',
{Encrypt N 'Password'}, 'odbc'"
When I try to execute this command line I receive
error "odbc parameter is incorrect". If I try to delete
space between N and 'Password' I receive error "Incorrect
syntax near N".
If I use OleDb objects instead of SQLData objects
everything works properly. The problem is that I have a
SQL Db and I would to have benefits using SQLData objects.
Anyone can help me?
Thanks a lot in advance.
Bye