Re: Application Role - aduseclient

From: veronique dumon (veronique.dumon@smals-mvm.be)
Date: 06/06/02 

From: veronique.dumon@smals-mvm.be (veronique dumon)
Date: 5 Jun 2002 23:09:49 -0700

I've found a solution :

bestelcon.CursorLocation = adUseClient
bestelcon.Execute "EXEC sp_setapprole '" & user_appl_role & " ', {
ENCRYPT N '" & user_appl_pwd & "' } ,'ODBC'"

I Use a cursorlocation = aduseclient before I set the ApplicationRole.
This prevents that another connection starts the moment I use a
recordset.cursorlocation = aduseclient . Strange, but this works.

Thanks for the given tips !!!