geertdeprez's Q&A profile

• SQL Server poor performance

  Hello all, I recently pick up a SQL-Server Client-Server application system and I saw very poor performance. for example, if I was doing some join from 3 or 4 tables, our data entry staff can not do anything, the front end VB application would just hang. There are 10 users at maximum logging on the system concurrently. I am not sql server dba but like to improve it, where should I begin to check detailed steps are appreciated. Thanks, Jane what version of sql server are you using If the VB application hangs, how do you know it's SQL Server that's the problem ...Show All

• Visual C++ need help to deal with char* pointers on COM interfaces

  I need to reimplement legacy COM interfaces (derived directly from IUnknown). A lot of methods on the old interfaces are equivalent to the following: HRESULT setValue (const unsigned char* value); HRESULT getValue (unsigned char* buffer, int bufferSize); The pointers on both methods are in fact the addresses of unsigned char arrays, which may be allocated on the old COM client's stack. The COM server needs to use the pointers either to fetch a C-style string (in setValue method), or fill up the client's buffer up to the buffer size (in getValue method). See the big problem (flaw) here The COM server must be able to access the COM client's internal memory directly. But the problem is, that can't happen all the time, because COM ...Show All

• SQL Server Moving sql 2000 to sql 2005- update query run slower

  Earlier I posted this query in SQL Server Database Engine forum. I am reposting it here. We have upgraded our database server from SQL 2000 to SQL 2005. To migrate the DB I attached the mdf file in SQL 2005. After migration website loads quicker than earlier but records updation ( no of records are 20k) got slowdown. I have found that update query run very slow in SQL 2005 as compared to SQL 2000. Although other select query run very faster. Query is called from ASP (active server page) page. Changing of fill factor option from 0 to 70 also did not work. I also have set the competible leve to 90. OLD Sever Config: dual xeon 1GHz, 512MB RAM, window 2000, MS SQL 2000 New server Config: Dual Core Xeon with 2 CPU, 10 GB RAM, window 20 ...Show All

• Windows Forms Launch Conditions (Installer)

  I am trying to create an install for two project solutions I have developed. I would like to have one of the pojects execute only once right after the users install has completed, an initial setup for the other project. How do I configure the installer to perform such a task Thanks Hi You can use a Custom action in the installer for that. You can do programming there for doing such a things like you are asking for. Here is a link that may be helpfull CustomActions Hope this helps Diego Rojas Excelsus ...Show All

• .NET Development Help with TripleDES and RC2 cryptography.

  I have 2 questions - 1) I get the following Exception when I try to decrypt data using TripleDES. - "An unhandled exception of type 'System.Security.Cryptography.CryptographicException' occurred in mscorlib.dll Additional information: Specified initialization vector (IV) does not match the block size for this algorithm." How do I make things right The code is as follows - /* Provides TripleDES encryption and decryption using classes in the .net Framework 1.1 */ public class TripleDES_Cryptography { public static string Encrypt(string plaintext, string key, string IV) { TripleDES des3 = new TripleDESCryptoServiceProvider(); des3.Mode = CipherMode.CBC; byte[] by_plaintext = Encoding.ASCII.Ge ...Show All

• Windows Forms splashscreen problem

  Hi, I've got a problem with my splashscreen; I want to show my splashscreen as long my application is not fully loaded and I don't want to use a timer, it must be "real", so I realy want to see it as long as the application isn't fully loaded. And how can I see what the application is currently loading give me an answer if u know something about it regards tom If you want the delegation usage in VB.net, here's the example: http://www.gotdotnet.com/Community/UserSamples/Details.aspx SampleGuid=7B1E743D-4287-4787-A316-56CF93C6DFC7 ...Show All

• Visual Studio Team System Removing User option under "Assigned To"

  We have recently removed the permissions from an employee that is no longer with the company (he doesn't have access to TFS), but each individual in various groups still have the option to add him as an "Assigned To:" value. Is there anyway to keep the history in the database as to what he worked on while removing him from the option in the field Moved thread to Work Item tracking, since "assigned to" is exclusive to WIT. I think you just need to remove him from any *other* groups to which he belongs (is he a user, admin, or contributor on any team projects, or in any of the project groups ), and he'll be removed from Valid Users as well (but it may take a few minutes to sync). Anything referring to " ...Show All

• SQL Server Sorting and grouping question by allowing users to select the sorting field

  I have a report where I am giving the users a parameter so that they can select which field they would like to sort on.The report is also grouping by that field. I have a gruping section, where i have added code to group on the field I want based on this parameter, however I also would like to changing the sorting order but I checked around and I did not find any info. So here is my example. I am showing sales order info.The user can sort and group by SalesPerson or Customer. Right now, I have code on my dataset to sort by SalesPerson Code and Order No.So far the grouping workds, however the sorting does not. Any suggestions would help. Thanks ...Show All

• Visual Studio Team System Profiling with instrumentation errors out when showing results

  I've run a few profiling sessions with Vs.net 2005 both instrumented and sampling. However in my latest round of profiling with instrumentation Vs.net 2005 displays the error below as it completes report analysis. "Value was either too large or too small for an Int64" Looking at the performance output pane I see this error message: "Failed to load view 0 with error 'Value was either too large or too small for an Int64.'.\nCompleted Analysis for ..." Rerunning the profile session yields the same results. If anyone has experienced this and found a solution please let me know. Thanks Luke for the links. I discovered, quite by accident, the cause of my problem. Terminating profiling by p ...Show All

• Windows Forms Error starting application after publish and install

  Hi People, I have been struggling with this for over three days. I was fortunate to find this forum. Please help... This is the error message in the text file.. PLATFORM VERSION INFO Windows : 5.1.2600.131072 (Win32NT) Common Language Runtime : 2.0.50727.42 System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200) mscorwks.dll : 2.0.50727.42 (RTM.050727-4200) dfdll.dll : 2.0.50727.42 (RTM.050727-4200) dfshim.dll : 2.0.50727.42 (RTM.050727-4200) SOURCES Deployment url : file:///C:/Documents%20and%20Settings/dj76627/My%20Documents/Visual%20Studio%20Projects/PaintSchedulingSolution/PaintScheduling/Paint_Publish/PaintScheduling.application Application url : file:///C:/Documents%20and%20Settings/dj76627/My%20Documents/ ...Show All

• Visual Studio 2008 (Pre-release) WPF not displaying images

  Hi all Today i sat down and decided to do some more work with WPF and i decided to try some stuff out with various images. But when i went to place a PNG image into my window it doesn't display. To clarify further i can see the PNG image in both the Visual Studio and Blend designers, but as soon as i run my app and the window loads with the PNG on it, i don’t see the PNG any more. Also, this same pattern seems to be happening with various other images that i have. Some work and others don't and all of them are included in the project in the root directory. If anyone can help me out on this that would be great. Thanks Anthony Here is the code if it makes any difference, although as you will see i am not doi ...Show All

• Visual C# Help needed for Remote Installation Program in C#

  Hi Friends I want to develop a software in C# 2005 which can install software remotely on client machines of a network environment so that the Administrator could install the desired software on client machines without physically visiting the client machine using network IP's. The system will work on Windows XP or 2000 OS. I need help how can I develop this system e.g. what topics in C# programming language I should study and which books, web sites, articles etc. will be helpful for me to accomplish the task. Thanks. ...Show All

• Visual Studio Express Editions Getting win32 to work on C++ EE

  Hi, I have VC++ EE, Im trying to work on some tutorials for win32 but my first attempt to compile a simple windows app from http://www.functionx.com/win32/index.htm failed due to VC++EE not coming with default configuration for native win32 apps. (Very annoying) I had to download the PSDK and follow the instruction from here http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=7004&SiteId=1 So I created the PlafromSDK directory and move the lib/bin/include directories inside. Now when I compile I don't get windows.h not found, but rather some errors that are pretty obscured to me as a beginner win32 programmer. I tried compiling this very code: #include <windows.h> const char *ClsName = "BasicApp"; const char *WndName ...Show All

• Visual Studio Team System Microsoft Visual Studio Team System Process Editor launched

  Microsoft released the Team System Process Editor as part of the Team Foundation Server Power Tools release v1.2. You can download the Power tools from the following URL: http://www.microsoft.com/downloads/details.aspx familyid=7324c3db-658d-441b-8522-689c557d0a79&displaylang=en Note: Please install DSL Tools for Visual Studio 2005 before you run the Power Tools installer. It is a pre-requisite for the Team System Process Editor. If you don't install this, the Power tools installer will install everything except the Process Editor. DSL tools download is available at http://go.microsoft.com/fwlink/ LinkId=82410 After the power tools installation is complete, you can find the User Guide and the Readme file at Star ...Show All

• SQL Server Script length limitation?

  Hi, The answer to my question may depend on both the sql server engine and the data provider; I do not know enough about the internal goings on to judge this. Thus, I should mention that we are connecting to SQL Server 2000, from an ASP.NET 1.1 application using the SqlClient provider. First a short introduction to my scenario: We have an application that needs to support exporting and importing data between different instances of the database (in a disconnected manner). This has been implemented in such a way that the export generates sql, which is then simply executed on the importing side. (It wasn't me! I'm fully aware of a number of reasons why this solution isn't any good, but this is what I have to work with.)  This is do ...Show All