Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-09-24 : 09:15:49
|
| Perry writes "Hi,We are building an application which makes at startup one connection to the database (Visual Basic application using ADO 2.7). Immediately after making the connection we execute stored procedure sp_setapprole. After a few queries the application role is lost from the connection. When looking in the SQL profiler we see an line 'Audit login'. All queries after this line don't use the application security.Is this a connection pooling problem?How can we solve this?Thanks in advance,Perry van KuppeveldWinIt Software Engineering" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
|
|
|
|
|
Application Secutiry 