abuck's Q&A profile

• SQL Server Configuring Reporting Services behind a firewall

  Hi, I put my SQL server behind the firewall, and I have put SQL_PORT and “Reporting Services Configuration” in the exception list. However, on a remote machine, if I use SQL Reporting Services Configuration Manager to change the Database Connection setting, I will get an error in the “Create a Grants Rights Script” stage. Looking at the exception, it points to an RPC problem. System.Runtime.InteropServices.COMException (0x800706BA): The RPC server is unavailable. (Exception from HRESULT: 0x800706BA) at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo) at System.Management.ManagementScope.InitializeGuts(Object o) at System.M ...Show All

• Visual Studio Team System BuildStatusChangedEvent in Bissubscribe command

  Hi All, I have been able to use the BisSubscribe.exe command to send emails when the build is complete using BuildCompletionEvent. I want to send the mail in case the build fails. Can anyone suggest how can I apply the filter so that the email is sent only when Buils fails I tried to use the BuildStatusChangedEvent command and when i use it like this: BisSubscribe.exe /eventType BuildStatusChangedEvent /address abc@xyz.com /deliveryType EmailPlaintext /server <servername> /filter "TeamProject = 'ProjectTest' I get this exception in the log file: Exception Message: TF50220: Missing the schema for the following event type: BuildStatusChangedEvent (type ConfigurationErrorsException) Exception Stack Trace: at Microsof ...Show All

• Windows Forms MDI Child Forms not Maximising

  Hello, I had a .NET 1.1 MDI application that I've recently updated to .NET v2.0 but there is a problem with showing MDI child forms that wasn't previously there. The MDI parent is split into two. On the left there is a tree view which, when a node is clicked, shows the relevant MDI child form. The MDI child is set to a fixed tool window and when shown it's maximised to fill the space available in the MDI parent. In .NET v1.1. this worked fine however in .NET v2.0, although the form is shown maximised, the form area being displayed is actually the same size as it is at design time. I know the form is maximised because it can be minimised, and when this is done and then the form is re-maximised it fills the space available as its su ...Show All

• SQL Server CogInStr function fails with MSAS 2005

  Hi, Following MDX query works with MSAS 2000 but fails with MSAS 2005: SELECT { FILTER([Product].AllMembers, CogInStr([Product].CurrentMember.Name,"*", 0) > 0) } ON AXIS(0) FROM [Sales] Following error is thrown: [ 1] Microsoft OLE DB Provider for Analysis S: Query (2, 32) The '[CogInStr]' function does not exist. Any pointers on what needs to be done in order to support this query in MSAS 2005 would be appreciated. Thanks and Regards, Santosh Thanks for your response. Yes, in AS2000 it was implemented as a UDF as shown below: command = USE LIBRARY "CogUdf.CogRExp" command = SELECT { FILTER([Product].AllMembers, CogInStr([Product].CurrentMember.Name,"*", 0) > 0) } ON AXIS(0) F ...Show All

• Software Development for Windows Vista pushsource filter and mpeg multiplexing

  Hi, I am trying to create an application which captures desktop audio and video in mpeg format. I am able to capture both audio (using audio capture device) and video (using pushsource desktop filter). I am also able to encode them into mpeg format using mpeg encoders. Individual audio and video streams are great at this time.Problem comes when I multiplex them using mpeg multiplexer.The stream just vanishes and only zero byte file is created. If I pass just audio through multiplexer, it comes out properly.However, if I pass just video through multiplexer, the stream is gone. Can anybody tell me why this might be happening and how to fix it thanks and regards, Nikita Thanks LGS. yes, I ...Show All

• Visual Basic Difference Between Basic & Web Developer?

  I hope I'm in the right place -- if not, please redirect. I'm new to all of this stuff, but I enjoy teaching myself different aspects of my website. I have a simple, personal website with several pages -- nothing fancy, but I might like it to be. I'm not afraid to learn. Having that said, I downloaded Expression a while back and recently became interested in the Expression Blend trial version, but when I downloaded it, it recommended Visual Basic or C# be downloaded as well. Once on that site, I saw Visual Web Developer. I ended up downloading both Basic and Web Developer. I had my 'Add/Remove Programs' up because of the warning about .NET Framework and dealing with other previous programs before downloading. Obviously, I was ...Show All

• SQL Server SSIS: Error opening solution

  I am trying to open the solution and it is giving me error "The application for the project \\..\..\test.dtproj is not installed Make sure application for the project type(.dtproj) is installed." I tried to open any SSIS solution and it is giving me same error. Anybody has any ideas how to resolve this problem Yashman wrote: Hi Jamie, How can I install the SSIS Workstation Tools. I have already installed SQL Server 2005 Advance Express Edition with the SQL Express Toolkit. Is there any other thing which I missed to install to run this above mentioned package. Appreciate your help. I'm confused. What is 'Advance' edition Note that SSIS is not included with SQL Serv ...Show All

• Visual Studio Team System Load test response time identical with or w/o gzip compression

  We have two web servers: one is configured with gzip compression while the other one is not. I'd expect that when we run the load test against the web server w/gzip compression, the response time would be faster. But our testing shows both servers have similar response time. Any idea why Regardless of what connection speeds I use, the response time appears to be very similar. I know our web server is configured properly. When I ran the test using Fiddler, I could see the content length of most pages on the web server with gzip was about 1/4 the size of the one w/o. ...Show All

• .NET Development C# Lookup Local & Network Servers (Oracle & MySQL)

  Hi All! I'm creating a server connection box in C# which can obtain a list of servers on the Local Network (MSSQL, Oracle and MySQL). I've successfully got MSSQL covered, but am still in need of assistance creating lists of the available Oracle/MySQL servers on the network, and have not been able to figure this out thus far. If you're aware of any methods to go about this, I'd sure appreciate your advice! Kind regards Ben That might have been the problem. I think there might have been some 64bit issues, but since I only have access to 32bit machines I didn't pay much attention. The instance column is the only one that is populated. I don't know if that is by design or not, but it does return ...Show All

• SQL Server How to avoid cursors and loops

  hi, My problem is basically i need to call a stored proc for each entry in a table, i.e, basically a for loop calling stored procs with parameter coming from the table. I know two ways of doing this .. using cursor and using while loop with temp table. I dont like both approaches. Is there any good practice for this situation.. declare mycur cursor fast_forward for select ID from sometable open mycur FETCH NEXT FROM mycur INTO @AID WHILE @@FETCH_STATUS = 0 begin exec dbo.storedproc @AID FETCH NEXT FROM mycur INTO @AID end CLOSE mycur DEALLOCATE mycur Hi there, Thnx for the reps. I cannot use UDF coz there are some underlying procedures to this procedures. UDF's ...Show All

• Visual Studio 2008 (Pre-release) Stylus events from Wacom graphics tablet

  Hi everybody, I'm currently designing an application, which targets the Tablet PC and PCs with a graphics tablet. In this context I wish to use stylus events like StylusDown, StylusMove or StylusInAirMove, which are provided by the new .NET3 framework / WPF. My problem is, that these events are never being created on my desktop/development PC (using a Wacom Graphire4 Classic XL tablet). This is especially weird, because in Tablet.TabletDevices (Tablet is a static class in System.Windows.Input) the tablet IS listed (since after Wacom driver installation). The problem is, that the Stylus.CurrentStylusDevice is null all the time. Even with an InkCanvas only the emulated mouse events are generated, not the stylus events. Due ...Show All

• Visual Studio Team System Cannot pass a GCHandle across AppDomains using unit testing.

  Got a manage C++ class in a class library that uses unmanaged C++ lib. The managed C++ class handles callbacks from the unmanage C++ lib by a delegate "gcroot<MessageDelegate^> m_MessageDelegate". To invoke the delegate I use the call "m_MessageDelegate->Invoke(nMsgId);". This works without any problem when running applications using this class library but when testing the class library using unit testing I got the error "Cannot pass a GCHandle across AppDomains" when I invoke the delegate. When running Unit Tests by default we create an App Domain per test assembly. It seems that MC++ has its own app domain for unmanaged code and gcroot does not allow marshaling across app domains. To walk aro ...Show All

• SQL Server How do you use SQL parameters to UPDATE a column?

  Hi all, I have a problem here where I am trying to use SQL Parameters to update a column in the database, but the problem is that I need to concatenate the same column to the SQL parameter. The code I have is below, but it throws a Format Exception... UPDATE tbl_NSP_Inspection SET Description = Description + @InspectionDescription ...It is because I am trying to Append teh data in the description column to the SQL Parameter ( @InspectionDescription). How do I actually do this using SQL Parameters Thanks Can you please post the actual error message Is this an error message from the server or client The UPDATE statement should work fine if either @InspectionDescription is same type as Description column or implicitly convertible. Also ...Show All

• Windows Search Technologies Unable to initialize the filter host process

  Installed WDS and Outlook 2007. Everything works fine. Uninstalled WDS. Installed it again from the Outlook 2007 prompt. WDS refuses to index. Essentially, the index dialog says that there are 2 items left to scan but it never completes. Instead, I get the following events in the Windows Event Log. Meanwhile, my Outlook search is not functional. Any ideas how to to solve this Some things I tried unsuccessfully include installing/uninstalling, removing teh Program Files/ Windows Desktop Search folder, using RegMon to find what key is causing the issue. Event Type: Error Event Source: Windows Search Service Event Category: Gatherer Event ID: 3100 Date: 1/8/2007 Time: 11:51:39 AM User: N/A Computer: NOR15279 Description: Unable to initiali ...Show All

• Visual C# Loading form in main form

  I'm trying to create an application that has a main screen and when i push a button i would like to load a new form into the main screen, without opening a new screen. Every new screen i open would have to open in the main screen. I tried using a panel and adding this new form into the panel but i get ==> Top-level control cannot be added to a control. Is there anyone who knows a solution to my problem Greetz I beleive what u r asking is about locking the position of the child form and not displaying its title and borders right well u can instantiate ur form as a dialog in which case it will not show any titles or borders better still since u'll be instantiating this form as a child do it in a ma ...Show All