Scott McKeown's Q&A profile

• SQL Server How can I compare datetime in a query???

  I have a table with the following columns company_Id employee_id logon_time_id logoff_time start_valid_period end_valid_period Employee's working time should only be counted if it is between start_valid_period and end_valid_period So, if I have for employee1 from company1 logon_time_id = 04/07/2006 11:00 loggoff_time = 04/07/2006 12:20 start_valid_period = 04/07/2006 12:10 end_valid_period = 04/07/2006 12:30 I should consider 04/07/2006 12:10 as the initial datetime, 04/07/2006 12:20 as the final datetime, and count only 10min of work to him. In code: if(logon_time_id < start_valid_period) initialDatetime = start_valid_period else initialDatetime = logon_time_id if(logoff_time < end_valid_period) finalDateti ...Show All

• Visual C++ VS crash when updating intellisense

  hello we using C++ manage code, with about 22 projects, when we open vs project from "VS2005 pro" updating intelisense is start, and when it get about 70% of it process we get microsoft error report, and Vs crash and restart , the only fix we find is to disable intellisense by rename FEACP.DLL. i find this solution unconvenion, we had this error in a last 3 months on diffrent computer in diffrent time. this is part of event viewer log (notepad with event id is attachment) Event Type: Error Event Source: Microsoft Visual Studio Event Category: None Event ID: 1000 Date: 30/01/2006 Time: 16:43:48 User: N/A Computer: **_XP Description: Faulting application devenv.exe, version 8.0.50727.42, stamp 4333e699, faulting module vcpkg.dl ...Show All

• Windows Forms do ini files get published with ClickOnce deployment?

  I have an ini file required for application initialization settings. Does the ini file get published as well It seems like only dll's are included in application.exe.deploy How would I add the ini file so that the exe has it from which to obtain startup values with GetPrirvateProfileString Thank you, -Greg I found the solution as per   http://forums.microsoft.com/msdn/showpost.aspx postid=55780&siteid=1   ...Show All

• Visual Basic ContextSwitchDeadlock error. ?¿

  Hi everyone, I’m stuck with that and spite of I can follow developing it’s a nuisance. When I’m debugging my VB25k console application without pitfalls by using F11 key, suddenly (ramdomly) I obtain an error: Se detecto ContextSwitchDeadlock Message: El CLR no ha podido realizar la transicion del contexto COM 0x1b1880 al contexto COM 0x1b19f0 durante 60 segundos. Es probable que el subproceso que contiene el contexto o apartamento de destino este en espera sin proporcionar mensajes o que procese una operacion de ejecucion muy larga que no proporcione mensajes Windows. Normalmente, esta situacion tiene un impacto negativo en el rendimiento y puede hacer que la aplicacion no responda o que acumule continuamen ...Show All

• Visual Studio Express Editions Web Control

  My apologies if this has been raised elsewhere. I'm just looking into VB Express 2005 and playing around with some of the features outlined in the tutorials. This is the first tool I've used using the .NET framework. I've put in a couple of buttons (back and forward) on a toolbar that i want to become enabled or disabled depending onm a couple of propertys in the Web browser control (eg MyBrowser.CanGoBack and MyBrowser.CanGoFoward. Very simple code (not exactly as below but does show the principal): If MyBrowser.CanGoForward then tbForwardButton.Enabled = True Else tbForwardButton.Enabled = False EndIf I've but this code in an event handler and it does fire as expected. My problem is that the CanGoForward property alw ...Show All

• Visual Studio Express Editions Rich text editor plz help

  i have a rich text box and a set up like the dialogcs video file but i want to use it to also open .php, .pl and .py files i get this error opening anything other than .rtf i get this error message running outside of v c# and this inside See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.ArgumentException: File format is not valid. at System.Windows.Forms.RichTextBox.StreamIn(Stream data, Int32 flags) at System.Windows.Forms.RichTextBox.LoadFile(Stream data, RichTextBoxStreamType fileType) at System.Windows.Forms.RichTextBox.LoadFile(String path, RichTextBoxStreamType fileType) at System.Windows.Forms.RichTextBox.LoadFile(Stri ...Show All

• Visual C++ Common network installation of VC8.0

  I am trying to install a common version of VC8.0. This is to be installed on a network drive and when a member of my team needs to run a compiler (or linker, whatever), they would just have to do <network_path>\cl.exe. This avoids installing VC8.0 on every machine and controls the build environment. I have tried a local install (VC8 does not allow installation on a network drive) and tar/un-tar the file onto the network share and copying the system dlls to the network location (msvcr80.dll etc). No dice. We would be only executing this in batch mode (no need for an IDE). Is there any way to do this Regards, Chris Try installing at least the vcredist_x86.exe on each computer. I assume cl.exe will need them and has likely an e ...Show All

• Visual C++ About obj file for VC8

  I use VC8 lately.It's build some obj files for a project,but I don't know what's the obj file type.It's not COFF file and not OMF file. I use new dumpbin tool to check these obj file, the report show:"ANONYMOUS OBJECT". Who know what's the file type Pleaes help,thanks... Eugene Nalimov wrote: You probably specified /GL compiler flag, i.e. you are using link-time code generation. In that case object file contains internal representation of your program, something resembling abstract syntax tree. That format is not documented anywhere and there is no guarantee it will not change in the next VS version. Eugene I think you are right.I test it that can get the COFF format ...Show All

• SQL Server SQL Profiler launching error

  Not an expert on this but have multiple XP system running SQL Express and am trying to get Profiler90 to run. Regardless of system, every time it is executed, it generates an "application failed to initialize properly (0xc0000005)" error. When running dependency walker against it, it appears the instapi.dll file is not found although it exists on the system. Trying to register the dll produces an entry point error. Is profiler only supported on a server OS Any ideas on how to get it to execute properly hi Profiler is not shipped with this edition This edition can be profiled from a Standard or Enterprise Edition of SQL Server 2005.   http://www.mi ...Show All

• .NET Development Overwriting problem

  hi, This function does the following it has 2 arraylists one contains chars from the file and the other "Symbols" contains all the symbols that appeared in the file without redundency ... the following code counts for each symbol it's frequency and it's probability and stores them in an object of type symbol which contains 3 attributes (the charachter, it's frequency and it's probability) and put all the structures in an array list called testing ... the problem is this is not what happenes I get an overwriting problem in the array list private void counter( ArrayList searching, TextBox textbox1) { int count = 0; Symbol test = new Symbol (); ArrayList testing = new ArrayList (); char ...Show All

• SQL Server Rolled Back and Unfinish installing MSDE2000

  I'm trying to install the MSDE2000 on window xp, sp2. During the installing, apperance the percent bar is rolling back, which is not even completed install. I had read the issue from microsoft to restart the server service, and...but no luck. Is there anyone has an ideas. Here is a great list of potential fixes for this problem: http://www.dbforums.com/t716764.html Thanks, Sam Lester (MSFT) The 14 step solution pasted here... We seem to have figured this one out finally. Prerequisites: The server service must be started. (often disabled by admins) File and print sharing must be enabled. This is a must for XP (often disabled by admins) 1. I recommend cleaning the machine of failed installs f ...Show All

• Visual Studio Team System TFS WorkItem Tracking : Error

  Hello all, i am getting the error in TFS WorkItem tracking in the event viewer like this: I am using Single server deployment of TFS. Event Type: Error Event Source: TFS WorkItem Tracking Event Category: None Event ID: 3000 Date: 12/1/2006 Time: 2:48:40 PM User: N/A Computer: <server name> Description: TF53010: An unexpected condition has occurred in a Team Foundation component. The information contained here should be made available to your site administrative staff. Technical Information (for the administrative staff): Date (UTC): 12/1/2006 9:18:40 AM Machine: <server name> Application Domain: /LM/W3SVC/2/Root/WorkItemTracking-5-128094383134804186 Assembly: Microsoft.TeamFoundation.WorkItemTracking.Server.DataServices, ...Show All

• Visual Studio Adding Additional Content to Sandcastle and the TOC

  I have three questions: 1. How do you add additional content to Sandcastle NDoc has RootPageFileName and AdditionalContentResourceDirectory parameters for this. Is there an equivalent in Sandcastle 2. Can you add your own pages to the Sandcastle TOC NDoc has a RootPageTOCName parameter. Is there an equivalent for Sandcastle 3. Even better, is it possible to add more than one entry to the TOC This was a feature we were hoping to contribute to NDoc and we would really like to see this in Sandcastle. Thanks, Richard Richard, I have answers below: 1. How do you add additional content to Sandcastle Not in an atomated fashion but we will be happy to take this as a feature and deliver it for our RTW ...Show All

• Software Development for Windows Vista Vista - Virtual Directories / Web Services under IIS-7

  Trying to bring up an app that uses web services under Vista. I have a Virtual Directory TBWebServices (gets converted to an "Application" by the installer, which I understand to be just fine). Set it up using Anonymous access (under IIS 5/6, I just have it use the default "ASPNET" account and let IIS manage the password. Software is developed using VS2005, thus Framework 2.0. Default application pool is set to Framework 2.0 I have a Hello.asmx which exposes two test methods: Hello - just returns Hello World HelloDB - accesses the database and returns ok if it could get it. Neither of these work. First got a 401 error. Changed the virtual directory user name to IUSR and then get an error http e ...Show All

• Visual C# scope problem

  I have a piece of code which you can see below: ==================================================== if (some condition) goto l1; if (some other condition) { l1: int u = 9; } ==================================================== actually when i compile my code in vs 2005 C# I get this error : Error 4 No such label 'l1' within the scope of the goto statement But in c++ (vs 6) it has no problem. My question is how to change my code so that 'l1' become visible to goto statement. you know that i can not remove my second if, so do not recommend eliminating it I love you all, I love every one, that is my slogan ZERESHK AFAIK, you cannot jump into a scope, so there is no trick that will make y ...Show All