Guest_imported
New member
- Jan 1, 1970
- 0
Hi everyone,
I've got a problem with my application developped under VB and working with a SQL Server DB... For security purposes, I allow access to the DB, within my app, with an app role and for the people who have got a valid NT account, they can access my DB outside the app, but they can only see the datas through views. Everything's should be alright there, but the call to sp_setapprole doesn't work well everytime, and I can't understand why :-(
I can start my app 10 times and in those 10 times, sp_setapprole won't work 1 time (at the best...)! I can't figure it out why! The worst thing is that i don't change the parameters of sp_setapprole for those 10 times!! So why does the call works sometimes, and not ALWAYS ?
The error I get is : "sp_setapprole was not invoked correctly"
If someone can help me...
Thanx in advance!
I've got a problem with my application developped under VB and working with a SQL Server DB... For security purposes, I allow access to the DB, within my app, with an app role and for the people who have got a valid NT account, they can access my DB outside the app, but they can only see the datas through views. Everything's should be alright there, but the call to sp_setapprole doesn't work well everytime, and I can't understand why :-(
I can start my app 10 times and in those 10 times, sp_setapprole won't work 1 time (at the best...)! I can't figure it out why! The worst thing is that i don't change the parameters of sp_setapprole for those 10 times!! So why does the call works sometimes, and not ALWAYS ?
The error I get is : "sp_setapprole was not invoked correctly"
If someone can help me...
Thanx in advance!