SQL Role Provider not instantiating
Just published a web site to a host provider with SQL Server 2005. SqlRoleProvider.CreateRole procedure give me the following error:
"Object reference not set to an instance of an object."
Here's my code to support this procedure:
"Partial Class RoleAdd
Inherits System.Web.UI.Page
Dim strRoleName As String
Dim RP As New SqlRoleProvider
Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
strRoleName = TextBox1.Text
RP.CreateRole(strRoleName)
End Sub
End Class"
Note my below is a snippet of my web.config file
"<roleManager enabled="true" defaultProvider="SqlRoleManager" >
<providers>
<add name="SqlRoleManager"
type="System.Web.Security.SqlRoleProvider"
connectionStringName="rumisg3ConnectionString"
applicationName="rumisg3" />
</providers>
</roleManager>"
Supposedly the Aspnet_resql.exe was run (appears it was I I can see the tables in VS server explorer).
Any help here would be appreciated.
JOHN
|