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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 ASP & App Roles

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-05-02 : 07:56:01
Tom writes "Hi,


I am trying to implement Application Roles in my web application and have a couple of question i need answers to. As i understand application roles are invoked on a connection level. My ASP application opens and closes connection on every ASP page that requires DB access.

My Questions are:
Will i have to open only 1 connection and keep it open for the entire session or is there a better way of doing it.

Are application roles recommended for web applications?

What are some drawbacks to using application roles on a web app?


Thanks a lot

TD"
   

- Advertisement -