Utsab Chattopadhyay's Q&A profile

• SQL Server SQL Server 2000 and 2005 - Application Role - sp_setapprole

  Hi All, Is there any limitation for setting password to an approle (like it should be 8 character long, should not start with numbers) If so, what are those limitations Does the same is applicable for sp_setapprole which uses the same password please confirm, for both SQL Server 2000 and 2005 versions. thanks in advance, Regards, Kailai On SQL Server 2000 there is no password policy feature, and SQL Server will not try to check for password complexity in any way. When running under Windows 2003, SQL has the possibility to use the Windows password mechanism policy. For more information on this topic you can consult Password policy ( http://msdn2.microsoft.com/en-us/libr ...Show All

• SQL Server SQL Server 2005 Evaluation Install Error

  I downloaded the SQL Server 2005 Evaluation setup .exe. When I wen to install it by clicking "SQLEVAL.EXE", I received an eror stating "There is not enough space on Drive C:\ to extract this package. I have over 50 gig of available spac eon my C drive. What gives When I downloaded the .exe, I had the Norton AntiVirus Auto-Protect enabled. Could that have caused it Also, 2 days ago, I installed MS-Accounting 2007. Could that have caused a problem I have seen this error posted on the SS2005 forums and the standard response is to look at the installation logs. I have no logs. The extraction never completed. Thanks. 1. create a folder c:\temp 2. copy any file to c:\temp, a txt, a ...Show All

• .NET Development Accessing files over network using smart client

  Hi, I'm writing a smart client, but I can't figure out how to make it work using .net framework 2.0. For debuging purposes I've written a real simple server-app, running it on the server works fine, but running it on a client gives an errormessage. Without fileaccess the client runs with no problem. The simplified code: private void button1_Click(object sender, System. EventArgs e) { try { FileIOPermission f2 = new FileIOPermission (FileIOPermissionAccess.Read, "C:\\"); f2.AddPathList(FileIOPermissionAccess.Read, "c:\\testFile.txt"); StreamReader sr = new StreamReader ("c:\\testFile.txt"); string line; while ((line = sr.ReadLine()) != null) debug.AppendText(line + "\r\n"); } catch (Except ...Show All

• Software Development for Windows Vista Add a rule conditions programmatically in an activity

  I'm almost exploding here... please help me. I am trying to create an activity that implements a lot of functionality so that the user can just drag it on his workflow and not be concerned about the implementation of certain tasks. My activity dynamically adds a ConditionedActivityGroup, for which rule conditions are needed. I have tried three ways to add the conditions to the workflow: Add a .rule file to the activity files by manually adjusting the project file. The problem is that the runtime does not seem to find the embedded file. Create and add the conditions programmatically and add them in the constructor of the activity and add them using rootActivity.SetValue ( RuleDefinitions . RuleDefinitionsProperty, ruleDef); . The problem ...Show All

• Visual Studio Debug C# code and VB

  I've tried to debug C# code with my VB6 project with no success. I wonder what settings I need to set in VB6 and VS 2003 environments. My VB project is referenced to C# code using late-bound method. Thanks! When using COM interop to call C# .NET code from VB6, you need to attach to the VB exe process from VS 2003 (Tools menu -> Debug Processes...) You can set breakpoints in the C# code by adding the following lines: #if(DEBUG) System.Diagnostics.Debugger.Break(); #endif ...Show All

• Visual Studio Team System customer rule

  how can i create a customer rule to check if both side of '+' has space thanks a lot As FxCop reads from binaries and not source code, things that do have not representation in IL can not be analyzed. This includes whitespace, braces and language specific keywords and concepts. This kind of analysis can not be done. Regards David ...Show All

• Visual Basic Printing the .NET Framework

  Is there some way in VS or elsewhere to print the entire .NET Framework including classes and their sub-classes Ok. I'm trying to train some people on VS2005 and thought that the visual would be helpful. I'm looking for something similar to the poster that is included in the VS2005 box. Thanks for your input. ...Show All

• Visual C# IE7 and Visual Studio

  Installed Internet Explorer 7 and after that we get the message Visual Studio Busy ..... message when doing a build. We are using XP Professional. You must be kill the process with task manager after that. We tried various things, but after going back to a restore point that was the one before we installed IE7 the message has not shown up again.   Any ideas on what is happening with this message   I have also seen a balloon, without IE7, that indicates that Visual Studio is busy and I wonder if there is more to this issue than just installing IE7 We did not go back an install IE7 again to prove that it really was a bad install, but wit AV software maybe your right. ...Show All

• Visual Basic Object Required: 'My' - why?

  I'm getting an error when trying to setup a click command in outlook 2003 script editor. Here's the script. Sub CommandButton2_Click Me.Textbox7.Text = My.Computer.Filesystem.ReadAllText("C:\info.txt") End Sub Everytime I try to click the button, it's giving me a debugger that say "object required: 'My'" I'm not sure what this means. I thought maybe I just didn't have the myservices class on this computer, but I installed .net 3.0 just to make sure, and this isn't helping. Well, I certainly appreciate the help. I'm a newbie to VB, just asked by my boss to write this up for him. You've saved me hours of time looking for an answer that doesn't exi ...Show All

• SQL Server Strange behavoir with XQuery and UNIQUEIDENTIFIER

  With the example below the first guid works but the second doesn't! Does anyone have any ideas Thanks, Simon declare @id uniqueidentifier declare @xml xml set @id = 'cb5ae187-1012-4b1f-b02c-f08e28fa3dc1' set @xml = '<service><id>cb5ae187-1012-4b1f-b02c-f08e28fa3dc1</id></service>' --set @id = '7F0FDB3C-5EE4-4806-9A8E-DDE7006B62C7' --set @xml = '<service><id>7F0FDB3C-5EE4-4806-9A8E-DDE7006B62C7</id></service>' SELECT @xml.exist('/service[./id= sql:variable("@id")]') It has to do with that SQL uniqueidentifiers will always be cast in uppercase to the guid form. Since string comparisons in XQuery are case-sensitive, you will not find the value if the ...Show All

• Windows Forms Prevent DataGridView selecting a row - is it possible?

  Hi all, I have a sorted, non-editable DataGridView which contains some cells in each row that are traffic-lighted (ie: they have a different b/g colour depending on value) but when I populate the control the row that was the first one (before sorting) is always highlighted thus wiping out my custom coloured cells. I have tried every combo of colours and highlighting options to try and stop the DGV doing this but can't find a way. Ideally I just want to suppress altogether the DGV control selecting a row when it populates - does anyone know how I can go about this This is driving me mad so I hope someone can help! TIA... Mike I have similar, but still a little bit different problem: in fact, I'd like th ...Show All

• Visual Studio Tools for Office Multi-threading in VSTO

  I have read throught many texts and i am not able to get to a conclusion. I have an excel application. The application queries various tables. After data is obtained through each table it is processes. Doing everything serially takes a lot of time. Is there any way i can put each task on a separate thread. None of the threads will be calling the Excel COM server. The tasks will perform data access/processing operations and once all the threads are done, the MAIN thread will do the writing on the workbook. In other words "Is is possible to do multi threading in VSTO solutions, assuming that threads won't interact with the office object" Thanks1!! Currently, there are no "interop" for ...Show All

• Smart Device Development Application loses focus when closing a Form - but only on one Form it happens...

  Hi all, I have this strange problem/issue that I have had bothering me for a while now. I have an application where the users browses through Forms to perform various bits of functionality, and then closes the form to return back to the previous form (the Form from which it was openned), and the Focus is right back with the Form that openned the closed Form (if you know what I mean :)). Now this all works fine in my application apart from in one place, where when the called Form is closed, the calling form (or my Application even) doesn't get focus back until the 2nd tap on the application with the pen. The Windows start button and Input control on the MainMenu are focused and can be activated from the first click on them, but not my appli ...Show All

• Visual C++ Trying to get a simple C++ console program to run on another computer...

  Hello, new to the forums. I hope I'm posting in the right place. I'm using Visual Studio 2005. I've written a very simple game as a Win32 console program (for test purposes) which I later plan to make into a full-blown windows ap. When I build the source, it makes an executable file for the program in the Debug folder. When I doubleclick this file, the program runs fine. However, when I try to run this item on a different computer, it doesn't. Instead, I get an error message reporting that the configuration is incorrect. Exact message : "The application has failed to start because the application configuration is incorrect." I can only assume that I missed a huge step somewhere along the line. Can a ...Show All

• Visual Basic ToolTip control and DataGridView

  I have a tooltip control on my form. The tool tip pops up great for all the other controls on the form except for the DataGridView control. Any idea what could be the problem Precisely. I set all properties at Design time. The tooltip shows for all the other controls except for this grid. Not sure if it matters, The grid is "DataBound" , and it is placed on a panel. ...Show All