M3talh's Q&A profile

• SQL Server Divide by Zero Error

  I have a function that compiles a number of different aspects of a Select query and then creates some high-bred fields based on the result. The problem I have is that some of these values contain a zero or Null and therefore I am getting a divide by zero error. The three sums I have are as follows; Number 1:- SELECT........, fnWTRalldata . floortotocc / fnWTRalldata . floortotal AS floorspaceperc, BLAH BLAH FROM Number 2 :- SELECT........, fnWTRalldata . NetRent / fnWTRalldata . FinalRtLsincSC ) - 1 AS rentrolldiscperc, BLAH BLAH FROM Number 3 :- SELECT........, fnWTRalldata . NetRent / fnWTRalldata . floortotocc AS ...Show All

• SQL Server Foreach NodeList Enumerator

  Does anyone have any experience of using the NodeList enumerator in a Foreach loop BOL is a bit light on this. I want to enumerate over an XML Document that is passed into my package. The package is executed from a .net application. Has anyone done anything like this Any demo material Should I pass the XML Document into an SSIS object variable or a String variable Can the NodeList enumerator enumerate an XML document that is stored in a String variable etc... Thanks Jamie Since others might be struggling with figuring out the InnerXPathString I thought I would post my experiences. I have the following recursive schema in the ...Show All

• .NET Development DirectoryServices - Get users from active directory

  Hello! I'm using the following code to get the users of a specific active directory, but it also returns the computer names. How can I get the users only Dim myDirectory As New DirectoryEntry("LDAP://" & directoryName, sAdminUser, sAdminPassword) Dim mySearcher As New DirectorySearcher(myDirectory) mySearcher.Filter ="(&(objectClass=user)(objectClass=person))" Dim mySearchResultColl As SearchResultCollection = mySearcher.FindAll() For Each mySearchResult As SearchResult In mySearchResultColl     ..... Next   "(sAMAccountType=805306369)" " (sAMAccountType=805306368)" ...Show All

• SQL Server MIRROR database questions

  Hello all. I was reading an article by Rich Heiges called Mirroring - A New Look at HA. It left me with 2 questions (A) Can I change the operating modes of the principal and mirror roles on the fly, or do I have to stop the MirROR process (B) It said that MIRROR supports 32-bit to 64-bit H/W interoperability -- but will it support interoperability between 32-bit and 64-bit instances of the database Thanks! For (A), you meant role-swithing (i.e. making mirror the principal and vice-versa). You can do manual fail over but this requires you to suspend mirroring. Active transactions are rolled back b ...Show All

• Visual C++ Problem with interaction between classes when trying to open files manually

  Hi, I have written a MFC SDI program (i am a begginer in programming) that needs to load and save an array of cards.  In the next version I add more members to my card class so its serialization is different. Now I want to provide a function in my program that loads the files that are saved under the standard of old version and save them under the standard of the new version. This should be a secondary serialization function Added to CKianDoc class which loads the data under the old version standard (which I have named Update(CString strPath) ).  But if I want to give the user an option to brows and select the file I should u ...Show All

• Visual C# Crystal Reports

  Hi All Does the C# 2005 Express edition come with a report generator I know that crystal reports was available with 2003 Thanks Hi, Sorry but crystal reports is not available in the Express Products... Its available in the Standard Edition and higher... Here's the visual studio product line... http://lab.msdn.microsoft.com/vs2005/productinfo/productline/default.aspx cheers, Paul June A. Domag ...Show All

• Windows Live Developer Forums Help! My app still wont start!!!

  I've created the app Game of the Generals and up until now, I'm still not able to launch it. I've tried different machines in different locations but still no success . I keep on getting the message: MSN Messenger cannot start this program. Please try again later. Can someone please help me!!! Well I can start it, so there is nothing wrong with the game... I don't know why you can't start it... ...Show All

• Windows Forms AppUpDater Problems / Removed From TaskVision ?

  We have an application that uses appupdater to refresh an application developed inhouse. The application was developed using .NET Framework 1.0. We have had multiple incidents of appplications that live in the program files directory being deleted and have narrowed it down to machines that have the 1.1 .Net Framework Loaded. I found some hits on the TaskVision s ...Show All

• Visual Studio Team System Project Creation Wizard was not able to connect

  How do I solve this : Error Unable to connect to the Windows SharePoint Services at 192.168.1.12  Explanation The Project Creation Wizard was not able to connect to the Windows SharePoint Services at 192.168.1.12. The reason for the failed connection cannot be determined at this time. Because the connection failed, the wizard was not able to complete creating the Windows SharePoint Services site.  User Action Contact the administrator for the Windows SharePoint Services at 192.168.1.12 to confirm that the server is available on the network. Also, you might find additional helpful information in the project creation log. The lo ...Show All

• SQL Server Mass flat file loading

  Here is what I'm trying to do in SSIS: - I have hundreds of flat files that were dumped during last several month from a legacy system. All files have consistent naming including date/time stamp and a prefix that defines what table will it end up in. What I need is: - build SSIS package to load exiting files - build SSIS package to load files on daily basis in future What would be the best way to loop through the file folder I imagine someone has done this before I just need a pointer to what tools from SSIS are best fit for the job. Dima. You have 2 options: 1) Use the ForEach loop ...Show All

• Software Development for Windows Vista Error debugging a workflow

  Hi, I have the RTM version of VS 2005 installed with the 2.0 framework and the November CTP of WinFX and specifically the WWF VS integration. Everything seems to work fine except I get an error when trying to debug a workflow: "Error occurred while Loading Workflow An error occurred while loading the workflow. Please correct the following error and try reloading the document to view the Workflow. Attribute 'Class' not found on the root activity." This happens for even the most basic of workflows if I simply create a sequential workflow project and then add a "Hello World" code activity, set a breakpoint on the activity and debug. Thanks ...Show All

• .NET Development web service does not work on webserver only on local box!

  Hi there. Interesting thing I just found. I made a webservice which updates my app on request. This is the way it works, simple pseudo: [webservice] Recieves incoming versioning compares with server files if server file versioning > incoming versioning    send the file name end if [client] if filename != null    create the file    request file size from webservice [webservice] recieves incoming request for update file size sends update file size in byte[] [client] creates byte[] of size of file in byte[] sent by server thats just a quick psuedo of what is happening My app consists of 2 apps: Server (runs on ...Show All

• Visual Basic Where put initialization code in 2005

  In VB 2003, when creating a winform, there was always a section that read like this: 'This call is required by the Windows Form Designer. InitializeComponent() 'Add any initialization after the InitializeComponent() call In VB 2005 there is no such concept, so where do you put initialization code in VB 2005   WoodrowS wrote: In VB 2005 there is no such concept, so where do you put initialization code in VB 2005 No, there is, in the Form.Designer.vb there is a sub-routine called "InitializeComponent()". ...Show All

• Visual Studio Tools for Office VSTO Installation included in Visual Studio 2005 Team Suite

  Hi At the end of the installation I get an error message saying that vsto couldn't be installed, and propose that I run VSTOR.EXE manually. Running VSTOR.EXE I get an error message saying that I need to uninstall "Visual Studio .NET prerequisites - English", but I don't have that. From the support page ( http://msdn.microsoft.com/vstudio/express/support/uninstall/ ) I downloaded the uninstall tool, even if I never installed beta version before. Running it, it does uninstall SQL Server 2005 Express, then I get this error: The following task did not complete successfully: Uninstall Visual Studio components I am blocked, and really p ...Show All

• Smart Device Development Browse different folders in PDA using C#

  I am developing a application in c# compact framework for PDA, i want to browse through all the folders, to select a file and store in the database. Can anybody help me how to browse the PDA for files in different folders using c#. I tried few functions in the System.IO, but not able to show all the folders in the form, it is showing only 2-3 folders. ...Show All