Johanvh's Q&A profile

• SQL Server 13 GB Log File that refuses to shrink

  I have a SQL 2005 Database (named SMDataTest) in simple recovery mode. For some reason, the transaction log has grown to 13 GB; howver I am unable to shrink the file. I have already taken the following steps: 1. DBCC OPENTRAN(SMDataTest) -- to chekc for active open transactions 2. BACKUP LOG SMDataTest WITH NO_LOG -- to truncate the log 3. DBCC SHRINKFILE (2) -- where 2 is the fileid of my logfile, to shrink the log 4. DBCC SQLPERF(LOGSPACE) -- to see how much space is being used No matter what I do, SQLPERF(LOGSPACE) always shows that my Log Size is 13 GB and that the log space used is .9%! Can anyone assist. Thank you in advance. MikeB ...Show All

• Architecture Design Patterns

  What is the usage of common GoF design patterns in daily coding I ask this because as a developer I'm constantly trying to improve both my code and my overall design, to create software that's easy to maintain and easy to extend--- hopefully easy to change without effecting the 'client' aspect through the use of interfaces etc--- Is there a more straight forward application of certain design patterns For example, does anyone sit down and actually implement a bridge pattern in their code--- you read about it a lot, but only in academic articles, you equally read of people who find them absolutely useless most of the time... I don't think I ...Show All

• Windows Forms Painting problem

  I hope I can explain this well ..... I have a rectangle A (which is the entire control) and a rectangle B (which is A inflated by -1,-1).  Now, I want to paint the control using B if in one state, else use A.  When painting A, there is no problem because I am filling the entire rectangle.  However, when painting B, there is&nbs ...Show All

• Visual Basic CUSTOM tooltips in VB.NET (bold, italic ...)

  Well it's not a major problem but it visually would look better I have a text line wich cannot fit in control wich i am displaying it so when mouse hovers over that text it is shown in a tooltip Text exmp: Name: John ,Last Name: ... and so on Is there any way to make part of my tooltip bold Name: John , Last Name: ... like this Thank you for your answers and time. This link has an excellent example http://www.vbaccelerator.com/home/NET/Code/Controls/Popup_Windows/Floating_Controls/article.asp Just set the font before DrawString in OnPaint of the FloatControl ...Show All

• .NET Development How to use a C#.NET DLL in ASP?

  Hi, I've build a DLL to comunicate with ADSI, and it works fine under the .NET environment. My next step was using it with ASP, but I can't register the DLL using regsvr32. It says that the DllRegisterServer entry point was not found. I've tried to use regasm, but it give me the following output: Microsoft (R) .NET Framework Assembly Registration Utility 1.1.4322.573 Copyright (C) Microsoft Corporation 1998-2002. Todos os direitos reservados. Aviso de RegAsm: Nenhum tipo foi registrado Wich, translating to english, it is something like RegAsm Warning: No type was registered. I want to use it like an "usual" COM ...Show All

• Windows Forms Is the terrarium dead?

  Hi, I need help. I am a newbe to terrarium and it looks interesting. But All what I can read on the internet concerning Terrarium looks a long time ago. No recent post I mean, or at the farm... or I look at the wrong place. (Where is everybody ) I see 10 peers, All LED's are green, but I never receive a creature from other peers. I can't introduce my own creature, I get a message "Terrarium is experience some server problems. Please try again later.". I connect to http://www.terrariumgame.net/Terrarium, it is the only server I know. Are their other servers ...Show All

• Visual Studio Setting OuputFileFolder to a SmartDevice project by automation

  Hi, I'm having the following problem: In VS 2003 I could set the deployment path by automation to smartdevices project with the following code: project.Properties.Item("OutputFileFolder").Value = "\Program Files\test" In VS2005 this property does not exists. I was searching and I found the property SDEProjectExtender.DeploymentPath, so I can read the path. But the problem is setting this property. I get the extender using project.Extender("SDEProjectExtender") but I don't know what kind of object it is. I tried to set the property DeploymentPath using CallByName but It failed. Any idea Hi Gaston,    I just peeked into the so ...Show All

• .NET Development How do I copy a solution and all its files to another computer?

  I am new to VB.Net but not to VB. I do part of my development on my laptop and part of it on my desktop computer. I need to be able to keep the code on both machines in sync with each other. What I am used to doing with VB6 is to simply copy the entire code directory from one machine to the other using the file manager and by mapping to the remote drive. I just tried that on some code that I have been working on with my laptop. The files all copied well enough. When I opened the copied solution on my desktop to work on it I found that the forms did not look the same. In comparing the properties of the forms I found that some things were ...Show All

• Visual Basic What's wrong with this code?

  I had this code that i am supposed to use for my current project...Using Crystal Report, I want to sort the record by entering the two dates (dtpFrom, dtpTo), the name of the company(FINAL2.COMPANY), the description(FINAL2.Description) Private Sub ConfigureCrystalReports() Dim mySelectFormula As String = "{FINAL2.Order_Date} >= #"" & dtpFrom & "#" & " and {FINAL2.Order_Date} <= #"" & dtpTo & "#"" & " {FINAL2.COMPANY} > Maxicare " _ & "AND Mid({FINAL2.Description}, 1, 1) = ""C"" " myCry ...Show All

• Visual Basic Urgent....common language runtime detected an invalid program

  Hi EveryOne, I would like to share this problem with the anyone who may have the solution,,, " common language runtime detected an invalid program " I develop a VB.NET windows application with a form that contains more that 340 controls (radiobutton,checkbox,groupbox,...) but those controls are not the regular VB components. they are altered and added about 20 new properties. After building the solution NO ERROR is showen although this error is showen when I click on the button that load the Fully Loaded form but when I reduce the number of controls or change some of them with the regular VB componenet (radiobutton,checkbox,groupbox) no erro ...Show All

• SQL Server Problem using SQL Server Mobile 2005 with Windows Mobile 5 application

  Hello, I am developping a non-managed C++ application for PocketPC using a SQL Server mobile database. The application is compiled for PocketPC 2003 and uses SQL Server Mobile v2. I use Visual Studio 2005. But I need to compile the application for Windows Mobile 5.0 devices. So I installed the WM5 SDK and had the WM5 into my project configuration. The "ssceoledb.h" which I include incluses the "transact.h" file. But my problem is that this file is only provided with the PocketPC 2003 SDK and not in the WM5 SDK. So I cannot use the WM5 configuration project with SQL Server. I also tried with the last SQL Server Mobile 2005 ...Show All

• Visual C++ Upcasting/Downcasting name jargon

  Well I am a little confused with naming jargon of casting. My intended goal was: CBase* pBase = static_cast (derived); What is it called upcasting/downcasting I guess what we are doing is casting a pointer from Dervied Class to Base one so we are moving up in hierachy. Should It not be called upcasting . and There are many articles where it is called upcasting like for example: http://www.codeproject.com/managedcpp/castingbasics.asp While in MSDN they interpret as downcasting: http://msdn.microsoft.com/library/default.asp url=/library/en-us/vclib/html/_mfc_static_downcast.asp Which one is correct Best Regards, ...Show All

• Windows Forms Convert DBNull to String

  As I'm working on a software project which needs a lot of data to be retrieved from a database I have a problem : when a certain field in the DB contains null values, the program crashes and gives the error that a conversion from DBnull to String is invalid. However, even if the value in the db is null I would like to be return ...Show All

• Architecture Version Checking & upgrading in XP

  Can anyone tell me where to search for versions of Windows XP Professional How can I know that my OS is 64bits or 32 bits supporting system Moreover I want to know about the versions of sp1 & sp2_are both of them 64 bit if any XP ver is 32 bits then which one is it If anyone upgrade from sp1 to sp2 from microsoft.com then he has to download the Whole file(300mb file or above)or lesser amount of file or extensin Which one is latest in XP Is it sp2 of 64bit Oprn a cmd prompt from the Start Menu, type in "winver", if you are running the x64bit version of Windows you will plainly see at the top: Windows XP Profession ...Show All

• Visual Studio Team System Is there a version good for me?

  Hello, I work in a small team on a project where we are spread across the country. I want to set up a Team System Foundation server so we can use this for source control and collaboration etc. I am a software guy and not an expert in AD, Domains etc, although I am willing to learn if need be. My problem is.... I have read on these forums that BETA 2 can be installed on a single server (that suits me) but will not work easily over the internet. Logons require AD/domain authentication etc. If this is the case then this is no good to me as the rest of the dev team are geographically dispersed. The JULY CTP is supposed to have fixed the internet ...Show All