Colin Reid's Q&A profile

• SQL Server SSRS Slow waking up on first report

  Greetings, I continue to see this similar post all over the place, but no resolutions. We have SSRS installed and operational in production. There are reports that get accessed from either an aspx page or from the built in IIS site for SSRS. First time access is the performance problem. Here are two scenarios: 1) from your browser, pull up the front page to SSRS: http://myserver/reports . This simple operation will take about 2 minutes to come up. Drill to the report in question and it runs fairly well first time through. Throw a different query at it and it runs faster. If you wait a while (maybe 15 minutes +) the whole thing will spin back down and take 2 minutes to come up again. If you exit the website and come back ...Show All

• Internet Explorer Development IE7 Start up problem

  Hi, I am having problems starting IE7. When I start IE7 it hangs for ages, maybe a few minutes before starting then everything runs OK. I don't think IE7 is the problem because when I start my network connection (tiscali broadband) explorer hangs too and nothing will run until it clears itself, several minutes later. When I boot Windows (XPSP2) iexplorer.exe runs at boot and tries to connect to the internet but I have no applications that call this program at startup, (except maybe McAfee and JavaSun scheduler). I have checked the registry and it seems clear (as far as I can see!) I have tried running McAfee and AdAware but they dont find anything. Have even tried a rootkit analyser but it also says nothing amiss. It is as if a ...Show All

• SQL Server How to give "public" access to cubes

  Hi, I'm deploying cubes over an intranet on web pages using OWC (OWC11). We can create roles to restrict access to dimensions or even the whole cube itself. On the intranet I must give access to everyone, that is users who are not registered on AS2005 Server. How can I give an Anonymous access over my cubes to my cube readers such that anyone can view the cube I've created a role named "public" in which I've added Anonymous Logon but OWC still denies access to non registered users. Thanks. This could be something else. Some connectivity problems. Take a look at this http://www.sqljunkies.com/WebLog/edwardm/ You should find your error there and some clues how to troubleshoot connectivity. Edward. -- Thi ...Show All

• Software Development for Windows Vista Appverifier and VB6

  Hello, we are currenty in the certification process for the "Certified for Windows Vista" Logo Program. One Test Case is: "Verify application does not break into debugger with the specified AppVerifier checks". We discovered that the Debugger (WinDbg 6.6.0007.5) stopps when a VB6 application uses the "On Error Resume Next" Exceptionhandling (I know that this is not good coding, but it is valid). At runtime, the exception is handled by the VB6 Runtime and everything is OK. When using the debugger, it reports an error at the exception handling of the application. Sample: Private Sub ExceptionTest() Dim myRecordset As ADODB.Recordset On Error Resume Next myRecordset.Close ' Debugger breaks here! ...Show All

• Visual C# Security for my application...

  Not sure where to post this so I guess here Anyways, I see in new applications that they use an authorization tool. Can I get something like this for my new application If so, where and what I'm looking to help prevent piracy of my new application. Thanks, Devin Ahh! You are probably looking for some licensing tool for your application. Google will help you in this. Search for ".Net Licensing", ".Net Application Licensing", "Application Licensing" or Software Licensing. If you need to develop your own, then see www.codeproject.com and search XML digitial Signature in Application Licensing abd the other article is Application Trial Maker. If you understand well b ...Show All

• Software Development for Windows Vista Compare WWF to Metastorm?

  Has anyone here worked with the Metastorm workflow product I'm trying to get some information on Metastorm vs. WWF (or SharePoint 2007 workflow). The pros and cons of each, the differences between the functionalities. If there're any resources like whitepapers, discussions, I'd really appreciate if someone could point me to. Thanks in advance. I can't speak about Metastorm but Windows Workflow Foundation (WF), please don't use WWF as an abreviation, is the programming model, engine, and tools for quickly building workflow-enabled applications on Windows, for more information go here . SharePoint 2007 workflow is an implementation of WF. ...Show All

• Smart Device Development CString declared in header doesn't get assigned to

  Hello all, I recently ran into the problem that a CString globaly defined in a header file does not get any value when it gets assigned to in the cpp file. Example: In stringExample.h In class:     private:     CString cStringString;   In stringExample.cpp In function:      cStringString = localCString;   While localCString has a value, cStringString hasn't changed and has no value. Thanks for any answer/suggestion. Hi, thanks for your reply. I verified it and there isn't a local variable with the same name, I also tried declaring some other CStrings in the header with different names to be ...Show All

• Visual Studio Team System Accessing the updated power toys when installed using the .msi

  Hi, Perhaps I missed it, but there doesn't seem to be any documentation that indicates how to access the command line power toys after they are installed using the msi package. I had to do a search on my c: and d: program files folders for tfpt.exe to figure out where it installed to. I would consider modifying the installer to add a shortcut to the start menu that opens a command line with a path setting that points to the installation directory for the power toys. At the very least, some text on the download page that specifies that the power toys install to "C:\Program Files\Microsoft Team Foundation Server Power Toys" would do the trick. Users shouldn't have to search their own hard drive to find the app they just installed! ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Buttermilk Game Engine and LGPL

  I'd like for Buttermilk to have the following features in its license - Free to use and redistribute. Free to publish commercial games on Windows. Free to publish free or commercial games on the XBox360 (XBLA, etc). Basically no restrictions except don't pass my code off as something you made :) Will LGPL do this I hear it's looser than GPL. The looser the better, methinks. Check out the BSD license. The MPL is a pretty good one for that, as well. There's another license that basically says you can do whatever you want with, so long as you don't use it to duplicate the original functionality commercially - I'm not explaining that well. Basically, on a physics library, you couldn't use it as the basis of a commercial ph ...Show All

• SQL Server Accessing Table From Visual Basic

  I have a SQL table and I want to access it using the Visual Basic Code but first I want to check whether the row is exist to update it or not exist so I can add new row. I have wrote this code but it doesn't work. Set mydb2 = ceg.OpenResultset("select * from ProjCost where Mon='" _ & Format(SD, "dd/MM/yyyy") & "'", rdOpenDynamic, 3) If mydb2.EOF Then mydb2.AddNew mydb2(0) = Trim(ProjNum) mydb2(1) = Trim(ProjName) mydb2(2) = Format(SD, "MM/dd/yyyy") mydb2(3 + (mydb1(0) - 1) * 2) = Trim(Total) mydb2.Update Else mydb2.Edit mydb2(3 + (mydb1(0) - 1) * 2) = ...Show All

• Visual Basic Print (.NET)

  I need help with the issue of printing.. i come from vb6, and this looks pretty more difficult for doing a simple printing... can anyone explain me how do i print, line by line a document Thanks ;) you would need to look at the printdocument class: here is an example and the documentation http:/ / msdn2.microsoft.com/ en-us/ library/ system.drawing.printing.printdocument.aspx you may wish to take a look at the printcontroller class also: http://msdn2.microsoft.com/en-us/library/system.drawing.printing.printcontroller.aspx   ...Show All

• Software Development for Windows Vista Stop excution of compisite activity but not terminate parent workflow!

  Hi all, I have to implement a big workflow. I have to divide this big WF into some small part and add them to custom activity. In custom activity, i want to terminate (or stop) execution of it. I try to use Terminate Activity for this, but when i do it, not only the custom activity terminate but also the parent workflow terminate to. How can I fix it Thanks for you reply. I need to explain again about statuation i have. as i mention it before, i extractly need a mechanism to stop execution of a child activity while keep the rest work of a workflow (or a parent activity) to perform normally (not do it by use handler method). Regards! ...Show All

• SQL Server SQL Server 2005 - SQLagent Log message

  We are seeing the following in our SQLAgent log every minute. I cannot find any information anywhere about this error message. [298] SQLServer Error: 599, WRITE: The length of the result exceeds the length limit (2GB) of the target large type. [SQLSTATE 42000] (LogToTableWrite) DO you have a job that runs every minute HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• SQL Server Unattended SQL 2005 Express install enabling Ad Hoc remote queries

  Hi there, I am trying to create an un-attended SQL 2005 Express install. I have successfully made my own template.ini file to install SQL the way I like but I cannot find a way to make it install with the "Ad hox remote queries" option enabled. Is there anyway to do this I can't seem to find any switches in the INI file to allow this. Thanks Joseph Beckett Hi Jens, Thanks for that, it solved the problem. The only thing I had to do was to add: sp_configure 'Show Advanced Options', '1'; GO RECONFIGURE; Before running your command. Once again, Thank you. ...Show All

• Visual Studio 2008 (Pre-release) VMR9 and MediaElement

  I am trying to use a DirectShow filter in MediaElement, and although it works in WMP it does not work in a MediaElement. The author has suggested that maybe MediaElement requires the VMR9 in renderless mode with a custom allocator-presenter but I didn't know so I am asking :) Also what are my debugging options I have hooked up the relevant error event but nothing fails, it all seems to work, I just see a blank area instead of the expected video. I don't know if it is relevant but this filter is for DVB-T and as I mentioned works (very) well in WMP. Any help appreciated. Thanks Nicholas, but it didn't, I appreciate the reply though - more than I've got from anywhere else ;) I was under the impression that ...Show All