When I try to set up an email subscription for SSRS 2000, I get: EXECUTE permission denied on object 'sp_add_category', database 'msdb', owner 'dbo'. The dbo user for the msdb has admin priviledges. I'm stumped on what to do or look for. Found this in the catalog.sql file: GRANT EXECUTE ON msdb.dbo.sp_add_category TO RSExecRole I ran this script for the msdb database via Query Analyzer, tried the subscription again, and got: An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help EXECUTE permission denied on object 'sp_add_category', database 'msdb', owner 'dbo'. We're connecting to the db server from a shared datasource w/ a user, let's say "reportuser", that has only "Read Access" to pull the data. Any suggestions? Thanks!

I have a button click and what I need to do is too things: 1. Send an email to the value of what was selected from a required dropdown list of people 2. Then send the user to another page. I wanted to do both of these in the code behind, and it's been decided the application owner (person who's funding the application) would like to use the client's email application (ie. Eudora, Outlook, etc.) when sending this email. I'm not sure how to replicate the href='mailto:person@person.com' that's possible with the anchor tag.

...and that's what I couldn't figure out as far as the DeleteCommand getting fired. When there are two records on the 2nd page, there's no exception thrown when I click the #1 page link. If I delete one record from the 2nd page and now there's only 1 record on that page, the exception get's thrown when I click the link to go to page #1. Why does the DeleteCommand get fired when I click the page #1 link? I tested my original datagrid, and it doesn't do this...it's works fine. The only difference is the edit item template for this current datagrid where I put two dropdown lists and two text boxes in one column, so the user didn't have to scroll horizontally. The original datagrid, which changes my 4th text box/column to a ddl, and my 6th textbox/column to a ddl doesn't throw any errors. Weird......but at least it's a better UI than before, and I just display a tiny error message. Thanks!

With only one record on my 2nd page in my datagrid, when I go from page 2 to page 1 in my Datagrid (ASP.NET v1.1), I get: Input string was not in a correct format. [FormatException: Input string was not in a correct format.] Microsoft.VisualBasic.CompilerServices.DoubleType.Parse(String Value, NumberFormatInfo NumberFormat) +193 Microsoft.VisualBasic.CompilerServices.IntegerType.FromString(String Value) +92 [InvalidCastException: Cast from string "" to type 'Integer' is not valid.] Microsoft.VisualBasic.CompilerServices.IntegerType.FromString(String Value) +206 Work_PackageVBConvert_P3E.SARESTableSubform.DataGrid1_DeleteCommand(Object source, DataGridCommandEventArgs e) +185 System.Web.UI.WebControls.DataGrid.OnDeleteCommand(DataGridCommandEventArgs e) +109 System.Web.UI.WebControls.DataGrid.OnBubbleEvent(Object source, EventArgs e) +589 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +26 System.Web.UI.WebControls.DataGridItem.OnBubbleEvent(Object source, EventArgs e) +106 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +26 System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +121 System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +115 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +138 System.Web.UI.Page.ProcessRequestMain() +1292 **************************************************************** I have no idea what's going on or why this is happening. If I add another record to my datagrid, and now I have two rows on my second page, I can go to the first page successfully. The PageIndexChanged routine is simply: DataGrid1.CurrentPageIndex = e.NewPageIndex Call DG() Any ideas? Thanks!

Guffa, Thanks for staying with this. Yes, my string is something like: "Bush George W | 987987" ...and I thought this would/should do the trick to make sure the end of my string is correct: Dim regEx As New Regex("\s\|\s\d{6}$") ...am I missing something? What I don't want someone to do is allow users to take "Bush George W | 987987" and make it : "George W Bush" or "Bush George W" or "Bush George W | 987"

Guffa, That's all I want to allow: a single white-space character, a single alphanumeric character, a single white space character and six digits

I got it with: 'Start Expression Code Dim regEx As New Regex("\s\|\s\d{6}$") 'last six characters are digits for number If Len(Trim(strNewPerson)) > 0 Then 'Means there are characters for the name If InStr(strNewPerson, " | ") = 0 Or Not regEx.IsMatch(Trim(strNewPerson)) Then lblStatus.Text = "* Name value must be from dropdown list built when typing name(last name first)!" Exit Sub Else lblStatus.Text = String.Empty End If End If 'End Expression code Thanks!

I'm trying the following in a code behind subroutine, and it's not working. If the value they select is CORRECT, the exeption is still thrown. txtWPMgr.Text should get built from a SQL string the does a select colName+' | '+colNumber It's the colNumber value I want to compare in this expression. Dim regEx As New Regex("^\s\w\s\d{6}$") 'last six characters are digits If Len(Trim(txtWPMgr.Text)) > 0 Then 'Means there are characters for the name If InStr(txtWPMgr.Text, " | ") = 0 Or Not regEx.IsMatch(Trim(txtWPMgr.Text)) Then intDisable = 1 'Mark integer flag lblStatus.Text = "Bad Format!" End If

Hello! I'm using an autosuggestion text box, and the user can either use blank (string.empty) or a value they got from the ddl for the UPDATE sql. What I'd like to do is make sure if they did select from the ddl, they used the values from the db, and not their own. A correct value would be: Smith Jonathan R | 88899 .....the flow is last name, first name, MI, space, pipecleaner, space, then a six digit character. I know I can use the following as an expression: \s\w\s\d{6}$ ....but I'd also like to do a couple more checks in my subroutine as well. What I'm having trouble is with actually writing the VB in the subroutine for the expression. Everything uses the RegularExpressionValidator that I've gotten back from Google. Thanks!

Got it to work with this: http://www.411asp.net/func/content?tree=411asp/tutorial/specific/web/userinte/webcontr/listbox&id=5881410 Thanks to all for the help!

Guffa, I get the items from a db call to populate the left listbox on my page. The user will click on this listbox to transfer the "number" over to the right side listbox, Listbox2, on the page. I'm trying this code to sort the items in Listbox2, but get: At least one object must implement IComparable. Dim items As New ArrayList(ListBox2.Items) items.Sort() ListBox2.DataSource = items

Thanks Mark! I got the duplicate code to work...I actually put the code in the wrong listbox. So, I'll try the hashtable with the listbox items then for the sort.

Hello! I used this code, and it works to not allow duplicates: Dim li As New ListItem For Each li In LB1.Items If li.Selected = True Then If Not ListBox2.Items.Contains(li) Then ListBox2.Items.Add(li) End If End If Next After the items are added, my second goal is to sort them ASC too. Haven't quite figured that out as well. Any suggestions are appreciated. Thanks! -- modified at 9:57 Monday 7th August, 2006

Hello! I'm trying to use the Autocomplete for the AjaxPro.dll from: http://munich.schwarz-interactive.de/autocomplete.aspx I keep getting "Object Expected" in my javascript on my .js include file along with that in the HTML body. I've added this to my web.config file: ********** ********** My code behind is trying to return names from my table (for starters) so I can see the names with the autosuggest: _ Public Function SearchAdvanced(ByVal orderNumber As String, ByVal customerID As Integer, ByVal count As Integer) As DataTable Dim ds As DataSet = New DataSet Dim sCon1 As New SqlConnection sCon1.ConnectionString = Session("DBDDL") Dim cmd As New SqlCommand("SELECT Authority FROM Signature_Authority_Names WHERE Authority like @CustomerID") '+ '"AND OrderNumber LIKE @OrderNumber " + '"ORDER BY OrderNumber, PartNumber, JobNumber", conn) cmd.Parameters.Add("@CustomerID", customerID) 'cmd.Parameters.Add("@OrderNumber", orderNumber + "%") Try sCon1.Open() Try Dim da As SqlDataAdapter = New SqlDataAdapter(cmd) da.Fill(ds) Finally sCon1.Close() End Try Catch Return Nothing End Try 'Return ds.Tables Return ds.Tables(0) End Function ********** ********** My HTML is: //Code for Autocomplete function init() { var x = new MS.Web.AutoCompleteDataTable("searchCustomerID", 10); x.getDisplay = function(item) { return (item != null ? item.Authority : ""); } x.getValue = function(item) { return (item != null ? item.Authority.toString().trimRight() : ""); } x.getData = function() { Namespace.ClassName.AjaxMethod(this.ele.value, this.count, this.callback.bind(this)); } } addEvent(window, "load", init); //error received on this line //End Code for Autocomplete

....I get an error on the line for addEvent(window, "load", init); saying "Object Expected" ***

Hello! I can type in the value in one text box, then it'll go to the code behind of another page and do the correct functionality....which will tell the user if the number is distinct or not. The only problem is when I post back the page via the button_click event, I get an IE error, iexplore.exe error, The instruction at "0x4a594476" referenced memory at "0x00000004". The memory could not be "read". HTML code is: WebForm1 var xmlHttp = createXmlHttpRequestObject(); function createXmlHttpRequestObject() { var xmlHttp; if(window.ActiveXObject) { try { xmlHttp = new ActiveXObject("Microsoft.XMLHTTP"); } catch (e) { xmlHttp = false; } } else { try { xmlHttp = new XMLHttpRequest(); } catch (e) { xmlHttp = false; } } if (!xmlHttp) { alert("Error creating the XMLHttpRequest object."); } else { return xmlHttp; } } function process() { varWBS = encodeURIComponent(document.getElementById("TextBox1").value); xmlHttp.open("GET", "test.aspx?WBS=" + varWBS); xmlHttp.onreadystatechange = handleServerResponse; xmlHttp.send(null); } function handleServerResponse() { //if (xmlHttp.readyState == 4 && xmlHttp.status == 200) //{ // document.getElementById("show").innerHTML = xmlHttp.responseText; //} //} //New code if (xmlHttp.readyState == 4) { if(xmlHttp.status == 200) { var parentElement = document.getElementById('show'); var wrappingDiv = document.createElement('div'); wrappingDiv.innerHTML = document.getElementById("TextBox1").value+' '+xmlHttp.responseText; parentElement.appendChild(wrappingDiv); //document.getElementById("show").innerHTML = xmlHttp.responseText; //document.all[show].innerHTML = xmlHttp.responseText; } else { alert("hmmmm"); } </x-turndown>

Nick, Thanks for staying on top of this. This is a new area for me. I thought I would get everything except HttpExceptions with: If Not ex.GetType.FullName = "System.Web.HttpException" Then

Thanks Ista! That's exactly what I was doing...except in VB: Sub Application_Error(ByVal sender As Object, ByVal e As EventArgs) ' Fires when an error occurs Dim ex As System.Exception = Server.GetLastError() If Not ex.GetType.FullName = "System.Web.HttpException" Then Dim message As MailMessage = New MailMessage message.From = "help@help.com" message.To = "help@help.com" message.Subject = "Problem: " & ex.Message message.Body = "InnerException: " & ex.InnerException.Message & _ "StackTrace: " & ex.StackTrace & System.Environment.NewLine & _ "DateTime: " & Now.ToString & System.Environment.NewLine & _ "Source: " & Context.Current.Request.Url.ToString() SmtpMail.Send(message) End If End Sub

Ista, I did the following in the global.asax file: Sub Application_Error(ByVal sender As Object, ByVal e As EventArgs) Throw New NotSupportedException ...ran the app and no errors on build or running the application. Thanks!

Ista, I just put the following at the top of the global.asax page, and that looked like it fixed the issue: Imports System Basically, "Imports System" was never there in the first place till I just added it. Shouldn't this be okay now? The blue "squiggly" is gone, so it looks like the code is correct and a build succeeded. Thanks!

I just tried to add a global.asax file (right click, and "Add New Item" to my application, and get: Type 'EventArgs' is not defined ...in the parameters section for the routines inside the global.asax page. I want to have the page errors / exceptions notices sent to the development team, but I can't get past this 'Event Args' error. I'm trying the following in the global.asax and the build liked it: Imports System.EventArgs ...subroutine now looks like: Sub Application_Error(ByVal sender As Object, ByVal e As System.EventArgs) ..instead of previous: Sub Application_Error(ByVal sender As Object, ByVal e As EventArgs) Any suggestions are welcome! Is this allowed??????? Thanks!