veXed's Q&A profile

• SQL Server Slowness in SSIS package and the importance of disk maintenance

  During testing a package repetatively that deletes/inserts into several tables, over the course of several days, my package, which took 45 minutes to load 1700 XML files, began to take over 6 hours. Turns out it was an I/O bottleneck, and the Avg Disk Queue Length was around 200 and I was incurring many PAGEIOLATCH_EX. My devl machine uses a single local disk, no raid, so I had no options there, but I ran the maintenance wizard to recreate indexes/statistics and defraged the hard drive, and regained my original 45 minutes time. I guess I'll have to put a maintenance plan together to do this nightly. -Kory KoryS wrote: During testing a package repetatively that deletes/inserts into several tab ...Show All

• Software Development for Windows Vista MSDTC error : Import of MSDTC transaction failed: Result Code = 0x8004d00e.

  Hi everyone! I suppose you've allready heard of this error, I've searched for answers on many other forums and groups but I didn't find a clear answer. So, for something to begin with - I am working on a VB 6.0 - 3 layered application and I get the error when the business layer is trying to persist some data. The broplem is that the transaction is not persisted - the application hungs and returns the "server busy" error. The wole application is blocked after this - when trying to save some data i keep getting this error. The persistent objects MTS transaction mode is set to "Requires transaction" and the component security levels are set to process level, the authentication level is None, and the ...Show All

• Visual C# panel.visiable's problem..I've to double click then it works

  // in my webpage I put my controls in a panel , when page load I set panel.visable = false. only when botton_click and then panel.visable=true //my problem is panel doesn't appear when I click once. I've to double click and then panel become visiable.. what's going wrong is my problem concern with "post back " I've no idea... P.S... I write panel.visiable while datareader.read() thanks hm.. that's what I did .. I set protected void Page_Load(object sender, EventArgs e) { PanelYes.Visible = false; PanelNo.Visible = false; } // if member found protected void btnS(object sender, EventArgs e) { if (dr.Read()) { Panel1.Visible = true; ...Show All

• Visual C++ Copying file trees in a custom build

  I have a large number of files which I want to include as part of my build process but which only need to be copied to the output directory in the same relative folder that they're in for the project (ie, if the file is in Documentation/Images/Header.jpg relative to the project then I want to copy it to $(OutputDir)/Documentation/Images/Header.jpg). I can create the custom build steps for these files and manually set their output directories but it's tedious. Instead what I want to do is create a custom build tool which will copy the files from their current project-relative location to the output directory in the same relative location. The problem is I can't seem to come up with a project-relative directory using any of the built-in macr ...Show All

• Visual C# Retrieving last index value in an ArrayList

  I want to populate an int variable with the last index of an ArrayList. I haven't yet found a property of ArrayList that will do that for me and I'm wondering if I'm missing something. Right now I am doing it this way: int theLastIndex = theArrayList.Count - 1 But I'm wondering if there is a more elegant way. This is in C#, by the way. Thanks in advance. Sorry, but that won't work at all. If that even could compile, it would set the lastIndex value to theArrayList.Count and then increment theArrayList.Count. However, Count is read-only, since it doesn't make sense to increase the number of items without actually adding an item. ...Show All

• Visual C# Proceses and Arguments?

  How Would I Send a command to CMD like netstat through c# and So far My app can open CMD I'm lost from here... Any help would be appreciated TY... If I understand correctly, you wish to pretty much "write" into the console from your application correct Well I guess you would need to start that process, CMD, then redirect the input and output streams to your application so you can control it and send commands etc....within your application Take a look at the link I supplied, it will show you the things to do. (look for redirectstandardinput and redirectstandardoutput) ...Show All

• Visual C++ Build successful but cannot run helloworld?

  Hi, Any help would be aprreciated. I am a beginner trying to run a c++ helloworld project I did on visual studio 2005 as win32 console project. I am using a centrino laptop is that is useful info to solve this. I have 2 questions. Question 1: Why can I only build successfully if I put "void" in front of the main and inside the brackets I see in tutorials that people can build without the "void"s. Question 2: Why even after building successfully I press F5, the program still cannot run and I get the error messages: 'Myprogram.exe': Loaded 'C:\Documents and Settings\Manlee Wan\My Documents\Visual Studio 2005\Projects\MahJong\debug\MahJong.exe', Symbols loaded. 'Myprogram.exe': Loaded 'C:\WINDOWS\system32\ntdll.dll', N ...Show All

• Smart Device Development Cdate cast error

  Hi all I'm trying to do a Cdate(datestring) where datestring is the value 25/6/2006 but it's giving me a cast error here are some code examples from the command window Now #11/28/2006 6:12:49 PM# CDate("25/6/2006") Run-time exception thrown : System.InvalidCastException - Cast from string "25/6/2006" to type 'Date' is not valid. CDate("6/25/2006") #6/25/2006# system.Globalization.CultureInfo.CurrentCulture {System.Globalization.CultureInfo} Calendar: {System.Globalization.GregorianCalendar} CompareInfo: {System.Globalization.CompareInfo} CurrentCulture: {System.Globalization.CultureInfo} CurrentUICulture: {System.Globalization.CultureInfo} DateTimeFormat: {System.Globalization.DateTimeFormatInfo} ...Show All

• Visual Studio Tools for Office Excel bound/cached data problem

  Hi, I tried out the walkthrough on creating a Master Detail Cached dataset in Excel. I followed each step precisely. ms-help://MS.MSDNQTR.v80.en/MS.MSDN.v80/MS.VisualStudio.v80.en/dv_vstcore/html/419f4e07-c67f-4fc9-973a-bc794f349ac3.htm Simple enough, and the data displays correctly. Problem is that I cannot get the data to sync with the DB. I worked within DevEnv (VS2005 Team, SP1, VSTO SE), in debug mode i.e. havent deployed. The data changes I made to the child table were saved in the excel, but did not reflect in the DB (SQL2005x64,SP1). What have I missed TIA Kar Looking at this example, this only explains/shows how to get data and view it in a disconnected state, not actu ...Show All

• SQL Server SQL Server 2000 - Generating new field containing the sum of other rows

  Hi guys, This one seems to be a difficult one: I have a table called "myTable" with a field called "myField" (which contains only numbers). I need to generate a new field where each row is the sum of the row in field "myField" plus all the values in the rows before it. something like this: myField NewField 100 100 = 100+0 200 300 = (200+100) 300 600 = (300+200+100) 400 1000 = (400+300+200+100) 500 1500 = (500+400+300+200+100) I'll apprecciate any smart help. Aldo. I can't answer that question without knowing the structure of your table, the data in your table and exactly what operation you are trying to perform. This code will create ...Show All

• Visual Studio Express Editions GetPixel

  Hi, I'm doing a C++ program that gets a pixel of a specific window here is the code (simplified) : HWND handle = FindWindow( NULL,"blabla - Mozilla Firefox"); if (handle) { SetForegroundWindow(handle); hDC = GetDC(handle); if (hDC){ COLORREF color = GetPixel(hDC, Xmin+x*30,Ymin+y*30); wsprintf(msg, "%X", color); MessageBox (handle, msg, "test", MB_OK); } } For some reason i get FFFFFF which is an error code of getpixel when the point is outside the clipping region. But my point is inside the clipping region, and a strange thing is that if i put a call to a messagebox before the call to getpixel, then this code works... I don't get it since setforegroundwin ...Show All

• Microsoft ISV Community Center Forums VBA to VB/Java

  I have created a form (using Word as a shell) that applies logic rules and outputs a series of text strings in a field of the same form. I no longer use the Word functionality in any fashion other than as a shell for VBA (i.e. a way to launch and run the VBA form. Is there any compilers/applications that will convert VBA to another language such as VB or Java or any common language that I can run stand alone I found one for Excel, but not Word. I am hoping someone has a suggestion. John I haven't done that, but from the articles I looked at, it appeared the code would be different. The properties all seemed to be different. And drop down lists also seemed to be handled differently. It's been a f ...Show All

• Commerce Server MenuAdapter.cs

  I know the menu adapter intercepts every asp:Menu server control and let's you perform custom logic / modify the output of the control. My question is, is there a way to selectively use the adapter Say, use it by default for every asp:Menu control, except if the control has an ID of ABC, then default to the standard asp:Menu output. Regards, Brad I don't believe it's possible. The adapters are chosen based on browser. And since the adapter plumbing is buried deep within System.Web there isn't any easy way around it. You're likely going to have to derive from Menu and affect rendering there instead of using adapters. ...Show All

• Visual Basic Creating shortcuts

  I am trying to create a shortcut on my desktop and also in my startmenu. I have looked over the internet and could not get any of the examples I found to work. Is it really this difficult Thank you, Troy L. See http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=699394&SiteID=1 The code only works when the project is published. It does not add a shortcut while being tested in the IDE. Solution works for XP, but can be modified to work for older versions. You need a PC with an older version to look at and see what it's shortcut file looks like. ...Show All

• Visual C# Opening a file / stream.

  Hi folks, i've got a file in a System.IO.Stream object. kewl. i have a button on my windows form which, when the user clicks it, the file will open with the appropriate default program. I'm not sure how to 'kick in/execute the file'. examples: 1) If the filestream object is an mp3 (ie. extension is .mp3), the default program for .mp3's will kick in 2) if the extension is .txt, notepade or wordpad (whatever is setup as defaults) will kick in. 3) if the extension is .aaa then the 'Please select the program to run this file default dialog thingy' is asked.   cheers :) EDIT:Replaced FileStream -> Stream. Typo. Hi, The catch is that the original poster requires that "Open With..." dialog is ...Show All