jdang's Q&A profile

• SQL Server Performance tuning issues

  I have built a solution which runs for two hours on a server with 4CPU 2GHz each and 2GB of RAM on windows 2000 server (CPU utilization almost 70% and almost out of RAM). I moved the two source databases and the solution to a new box runing 8 xeon's at 3GHz each and 16GB of RAM running widows 2003 server 32bit and it still runs for 2 hours (CPU utilization 10% and ample RAM left). I was expecting it to run much faster. So I started exploring the performance tuning features in SSIS and started tweaking the following: Control Flow: DefaultBufferMaxRows: Based on row size and buffer size, calculated the max rows. DefaultBufferSize: Set this to max 100MB DataFlow Destination: Rows Per Batch: Set this to equal to the numbe of ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Dream-Build-Play: Where are thou?

  Well, on the webpage it states: The Dream-Build-Play Challenge #1 starts the week of February 5 th , 2007. Brush up your skills this weekend and be ready first thing next week. And if I know how to read a calender right, then that run has passed, and we should have that thing now. So whats the status on that Do anybody know My team is falling apart because we have to wait and wait and wait, and the deadlines keep exspanding. Whats the deal Well, thanks for your answers. Its just a bad thing that im a very bad person to wait. But it chould be nice if they just telled us the status of the situation - just to let us know ...Show All

• Windows Forms UNC/URL path from OpenDialogForm

  Hi I'm using the OpenFileDialog control in VS .net 2003 to allow users to select file paths and save them into a grid and add a description. Now this works fine for local and network files which can be resolved to a UNC path. My problem is that when trying save the path of a file located on the web with a URL path it downloads the file locally to the users temporary folder and points to that rather then the source path. example: select file at google.co.uk/documents/programming/OFDCode.vb Click Open File is downloaded to temporary folder The .FileName property updated to C:\Documents and Settings\%USER%\Local Settings\Temporary Internet Files\Content.IE5\GHGJGZUP\OFDCode.vb I need the .FileName property to return th ...Show All

• Gadgets Help test the screensaver gadget

  Before releasing this to the masses, I was wondering if a few of you could go ahead and install my gadget and see if it works. It works on my machine but may not on someone else's if things don't register correctly. The gadget is a simple screensaver gadget that embeds a screensaver that you choose into its window (see http://blogs.msdn.com/photos/markhsch/picture1718045.aspx for a screenshot of it using the Ribbons screensaver). If you install it and it displays a white window with a red x, remove the gadget and re-add it to the sidebar to see if it goes. If you do test, please post on this thread with your results (either positive or negative). Thanks and here's the link: http://www.schmidt6.com/blogfiles/ScreenSaverGadget. ...Show All

• Visual C# How to add SQL ConnectionString editor form.

  I have created little C Sharp TOOLKIT application utilizing SQL ConnectionString. I use standard windows installer. It compiles nicely creating TOOLKIT.exe.config file with default ConnectionString settings. Sure my customer could go to TOOLKIT.exe.config XML file and edit string to connect to their SQL database. It is simple for us, but for customer it can be little harder. I would like to make their lives easier. My question – Is there any simple way to add a form that would edit ConnectionString after software is installed. Something like we have by name “Add Connection” http://www.windowsitpro.com/Files/09/9002/Figure_05.gif Thank you a lot! I started to write a class lik ...Show All

• SQL Server importing XML/ASCII files to SQl database using VB express

  Hi everyone, I have to write a program in VB to receive the read data from a RFID reader for my graduation project.The problem is I am not a computer science student so I have only general info on programming. I created my DB in VB express but I couldn't find out how to send the read data (that will be either in XML or ASCII format) to my database...The read data will be transferred to my computer by the RFID reader's software but after that I don'T know how to transfer it to my DB.As I know I have to use commands like read.xml etc,but no idea how write the complete program. I checked the forum and couldn't find the answer,sorry if someone already answered my question and I missed it. Thanks... Can ...Show All

• Visual C# Starting windows service

  I'm made one windows service which serves as a remoting host, but I can't run it! I built it, called installservice mywindowsservice.exe It said me that is successfully installed, but now I don't know how to start it.... I can't find it in services list... What am I doing wrong I figured out a part of my problem (I didn't have serviceinstaller included) But, now when a call installutil, it asks me for some username and password! What is it ...Show All

• Visual Basic 2005 IDE Service Pack/Patch ???

  Will there be a service pack or set of patches soon for the Visual Basic/Visual Studio IDE soon   I've been sending the bug reports everytime a bug/crash occurs in the IDE and I'm hoping these help. "While I understand that Microsoft staff may have felt the need to react to the terribly adverse publicity about VS 2005 product quality, and the ongoing pressure of trying to support such a bug infested product, making empty promises doesn't impress anybody. Please, give a firm date for a stable release of VS 2005 and let us know what will be fixed and what won't." What adverse publicity ...Show All

• Software Development for Windows Vista What's wrong with the DirectShow Samples distributed with the MS PSDK R2 ?

  Hi Everyone, I can not find some of the samples mentioned in the SDK documentation, such as Push Source Filters Sample, Contrast Filter Sample, Grabber Filter Sample, ... in the Filter Samples examples, as well as their project files. How can I obtain their source and project files And I' like to buy a good book about DirectShow Filter Design Could anyone recommend a book or a tutorial about DirectShow Filter Design Sincerely Cem DEMiRKIR Some of the older samples have been removed from the SDKs for R2 and Vista, including the Contrast and Grabber filters. The PushSource filter sample should still be there. I think you can still get the older stuff here: http://www.microsoft.com/downloads/details.aspx FamilyID=8af0 ...Show All

• .NET Development .Net 3.0 RC1 installation errors

  Any idea where the log files are saved Thanks, Yaakov ...Show All

• Visual Studio 2008 (Pre-release) Getting DLINQ to work in existing projects

  Hi Is it possible to get DLINQ working in existing projects or do I have to use the special DLINQ template evrytime greets Bastian Terotech.Com Ltd wrote: Hi, You can use DLinq either in new or existing projects. For existing projects you may have to perform a bit of refactoring of your existing codebase in order to be able to fully integrate with the DLinq way of working. regards, DaveW This is exactly what I want to do. In other posts here someone talked about custom compiler actions that are needed - how do I get them into my project Regards Bastian ...Show All

• SQL Server Vista, 18452 and the remote domain

  Hello We have a setup of two very separate domains, they are connected via a couple of routers, we connect to the remote domain mainly for administration mostly via remote desktop. We setup the same user name & password on both domains, with XP as the operating system we can setup the sql link via odbc using windows authentication which works fine, a couple of PC's have now been upgraded to Vista but the increased security stops this from working, we now get error 18452 error code with the user name of "null" I assume vista has stopped the passing of local credentials to what it considers an untrusted domain, fair enough, does anyone know a way of either adding another trusted domain to Vista I do not want to setup an ...Show All

• .NET Development Oracle CommandTimeout does not work in .NET Framework 2.0 (Microsoft Enterprise Library)

  Hi, I'm trying to change CommandTimeout to a value different of 0. I can't. See this code: Dim sqlConn As New System.Data.OracleClient.OracleConnection(strConnectionString ) Dim sqlCmd As New System.Data.OracleClient.OracleCommand(strSQL, sqlConn) 'sqlCmd.CommandTimeout value is 0 sqlCmd.CommandTimeout = 10 'sqlCmd.CommandTimeout still value is 0 After the last line is executed, CommandTimeout = 0. Using Oracle.DataAcess.Client instead of System.Data.OracleClient works right. The problem resides at Microsoft Enterprise Library that uses System.Data.OracleClient . Any help will be useful!! Thanks in advance. None of the current Microsoft impleme ...Show All

• Visual Studio Subclassing SaveAs dialog

  Hi, I have subclassed the SaveAs dialog prompt by Visual Studio .Net 2003 and now i am able to get the file name data field . My problem is, it's only giving me file name not the full path. Is there any means so that i can have the full path from SaveAs dialog. "cTitle" in the following code only provides the file name. BOOL CALLBACK EnumChildProc(HWND hwndChild, LPARAM lParam) { GetClassName(hwndChild,cClassName,1000); GetWindowText(hwndChild,cTitle,1000); if(0 == strcmpi(cClassName,"RichEdit20W")) { MessageBox(NULL,cTitle,"Subclass",0); } return TRUE; } LRESULT CALLBACK FileSaveAsSubClass(HWND hWnd, UINT uMsg, WPARAM wParam, LPA ...Show All

• .NET Development Using STDREGPROV with alternate credentials

  Hello, I have the following WMI query that uses the STDREGPROV provider since I need to pass alternate credentials to a remote machine. It works fine for a standard string look up, but when I need to do a REG_MULTI lookup it doesn’t work as its not a proper collection. Any ideas on how to convert this to a collection I can then enumerate properly with Alternately, Does anyone know if the Registry.OpenRemoteBaseKey has a way to specify credentials This would alleviate this issue. ConnectionOptions oConn2 = new ConnectionOptions (); oConn2.Username = username; oConn2.Password = password; const uint LOCAL_MACHINE = 0x80000002; System.Management. ManagementScope oMs2 = new Syste ...Show All