Kimmy's Q&A profile

• Visual Studio SccOpenProject always returns 2 - SCC_I_OPERATIONCANCELED

  Hi I'm trying to call SccOpenProject() after a successful call to SccInitialize; I pass ppContext, hWnd, user name, project name ($/TestFolder), localProjPath (c:\temp), lpAuxProjPath (c:\program files\vss\srcsafe.ini), comment (""), null for lpTextOutProc and dwFlags = SCC_OP_SILENTOPEN. The project $/TestFolder exists in my local database c:\program files\vss but every time SccOpenProject returns SCC_I_OPERATIONCANCELED (2) - does anyone know what is wrong here Thank you Hi Dimmi, I've seen this mistake done before... You have 2 problems with the call: - the lpPro ...Show All

• Microsoft ISV Community Center Forums last Modified date in Excel spreadsheet

  Hello Can anyone help me read details about a current workbook. Bascally everytime an excel spreadsheet is opened I want to saved the last modified date to say Sheet1.range("A1") Thank you in advance. Hey man, The Workbook has a property named 'BuiltinDocumentProperties' that you can use to get pieces of information about the document. One of these is the Last Save Time Cells(1, 1) = ActiveWorkbook.BuiltinDocumentProperties(12) 12 is the last saved time property. This will return an error is the workbook hasn't been saved. ...Show All

• Visual C# ITypeResolutionService.ReferenceAssembly not working

  Using VS 2005 Beta 2 I have a Control Designer for a WebForm control deriving from   System.Web.UI.Design.WebControls.DataBoundControlDesigner, in one of the designer actions I need to add a reference to an external assembly that is not in the GAC, this assembly is however, in the Assembly Folders indicated in the registry entry: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\.NETFramework\AssemblyFolders The problem is when I do this the assembly does NOT get copied into my bin folder as it does when I add the reference using the Property Pages for the project. I use: ITypeResolutionService.ReferenceAssembly The the service is obtained using C ...Show All

• SQL Server remove specific string from text field

  is there a way to look up a string of text and remove it in a text field that resides in my table   datatype of the field is text.  So I want to lookup a string in that field for all records in that table and remove the string of text but leave the rest of the field's text in tact Look up the PatIndex(), CharIndex(), and Replace() functions in the Books OnLine. You will eventually write an update statement that uses the Replace() functionality to replace a string with another string -- in this case the empty string. You can limit the search by using the PatIndex() function to find rows that include the initial string. Wh ...Show All

• SQL Server Unable to install SQL Server 2005 Standard

  I am trying to install SQL Server 2005 Standard Version on my IBM Thinkpad running Windows XP (SP2). I am installing from the CD that was given out to attendees at the Visual Studio 2005 Launch Event. The install is failing on the SQL Database Services with the following error: SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]. The default full-text language is not supported by the full-text search component. All the other options installed OK. I have also successfully installed Visual Studio 2005 on this same PC and I can access SQL databases on other machine ...Show All

• Windows Forms few questions combining msi with clickonce

  Hi, I'm trying to install a clickonce app for all the users on a machine. I know you can't do it via clickonce, but you can via MSI. How could I install an application via MSI and have it look for updates via clickonce Is that possible Please, point me in the right direction. Thanks Hi, ClickOnce applications are per user applications. You cannot install a ClickOnce app for all users. Here is an article comparing ClickOnce and MSI that you might find useful. http://msdn.microsoft.com/smartclient/default.aspx pull=/library/en-us/dndotnet/html/clickoncevsinstaller.asp Thanks ...Show All

• Visual Studio Express Editions Registering and licencing

  I have registered my version of visual web developer installed from CD but I have not received the product key. as I can obtain it The licence expires between a year... When you install from the CD Image you do not have to register the product. Have a look at the registration FAQ Item 7. Visual Studio Express edition Registration FAQ http://msdn.microsoft.com/vstudio/express/register/faq/ ...Show All

• Visual Studio Express Editions Problems removing VS.net for VB Express

  Last year installed VS .net on workstation. Never found the time to do the learning curve. Was pleased to see VB Express and SQL Express as most of my projects fit the parameters of these programs. VB Express installed with no problems on IBM laptop with no prior VS or VB programs, so went to install VB Express on desktop. All warnings pertained to VB express prior beta installs and so went ahead and dl / install VB Express. First thing I noted was that no toolbox shows up, and second when setting up new project there are no templates. Took a snapshot of that but cannot paste into the forum. Tried to delete VS .net via control panel and plac ...Show All

• Visual Studio Add-in howto

  I do not know if this is the right forum for this. How do I even begin my first steps to write a visual studio 2005 add-in Is there a sample example somewhere. I can create a sample add-in from the Visual Studio when creating a new project but after that there is not any good information in help or on MSDN. I want to basically add a new menu item to the context menu in the solution explorer and when the user clicks on it, I need to create a new window which gets filled in with stuff based on the project selected. Then based on what the user selects, I want to start Visual studio debugging session with certain arguments. I looked at the ...Show All

• Visual Studio Team System Test Director Defect Mapping to VSTS Work Item

  We need to be able to map Mercury Test Director defects into VSTS Work Items for developers to work...has anyone written a custom conversion utility After some finger trouble with configuring this utility I now have this synchronization up and working between TD 8.2 and TFS (two way). Things seems to work correctly so far even if running on a beta version of the Juvander software. Some experiences Having this sync as a Windows service is great - no need to log in to Windows to run the synchronization All defects synced from TD to TFS will have the identity of the user that is set up to be the user logging ...Show All

• Visual Studio Express Editions Where is the DLL ?

  Hi I craeated a C# web site using Visual Web Developer Express. I know it might sound like a stupid question, but where are the DLL files created by the build Should I create a seperate setup project for my web in order to create the dlls I added a Bin folder to the web site, but I can't find any dll there. How do I create an actual web site out of my code (assuming I have a URL and an external server) Thanks, A.G Hi A.G. Did you have any luck   I too am looking for the DLL. Cheers, Bill ...Show All

• SQL Server sp_MSForEachDB

  Hello, I know that sp_MSForEachDB is not being supported, but I am wondering if someone would help me find out if I can use sp_MSForEachTable within sp_MSForEachDB . The code below does not work, and I am wondering if the code is feasible. Error Message - "cursor hCForEach already exist" declare @var varchar(1000) set @var = 'EXEC sp_MSForEachTable @command1='INSERT INTO #tblResults2 ([name],[rows],[reserved],[data],[index_size],[unused]) EXEC sp_spaceused '' '''' EXEC sp_MSForEachDB @command1=@var Hi, Seems that they share a common gerneric procedure which open a cursor, t ...Show All

• SQL Server SQL database to XML

  (1) I need to select records from a SQL database and create a XML document which I then need to write to a users directory. I am using SQL express with VWD 2005. I located the FOR XML and can execute in VWD's SQL graphical tool. I haven't tried in a Web Form yet but I assume it will work ok. But then how do I write the xml results from the SQL query to local user's directory (2) I can execute the FOR XML in the SQL graphical tool but how do i Connect to the DB in the Web Form Use data.sqlClient.Connection and use .SQLcommand to perform the SQL query Following is an example I found that shows use of a NameSpace WITH XMLNAMESPAC ...Show All

• Visual Studio Using Properties and Call like NAnt

  NAnt has a nice feature where you can use a combination of properties and the call task to repeat operations. For example: <target name="target_one"> <property name="A" value="Value1" /> <property name="B" value="Value2" /> <property name="C" value="Value3" /> <call target="ALongProcessWithManySteps" /> </target> <target name="target_two"> <property name="A" value="Value4" /> <property name="B" value="Value5" /> <property name="C" value="Value6" /> <call target="ALongProcessWithManySteps" /> </target> The target ALongProcessWithManySteps would then use ...Show All

• Visual C# Design Time Collection Editing

  I am creating a custom menu. I would like to edit it in the same mannor as the ContextMenuStrip is done. Such as the menu on the design form, etc. Is this possible My object contains a ToolStripItemCollection just like the Context Menu Strip... If you could help or atleast point me to a place that would be very helpful. Thanks, Mike Mike, Anything's possible if you want to try hard enough! And Microsoft managed to do this... I haven't seen what you are after actually done, but my guess is you'll have to inherit from the 'item and do some custom painting (ie OnPaint) and key handling. ...Show All