Eleda's Q&A profile

• SQL Server How to run an exe in the SSIS scripting task

  Hi, Can anyone help me how to run an exe file in the scripting task. I was trying the below code but it's giving an error. Set wshShell = WScript.CreateObject ("WSCript.shell") wshshell.run "c:\Test\ABC.exe", 6, True set wshshell = nothing   Thanks, rkn   Here's one way.  You may want to check out the MSDN for any security risks, etc.  Dim procID As Integer procID = Shell("""C:\Program Files\Microsoft Office\OFFICE11\winword.exe"" c:\temp\test.doc") Larry Pope ...Show All

• Visual Studio Tools for Office Avoiding security alert in Outlook while accessing Contacts in VSTO 2005

  I am trying to access Items programmatically within a VSTO 2005. When I try to access the 'magic' properties such as email1address, I get the security warning within Outlook. I do not want to go back to redemption - that's why I am using VSTO. How do I avoid the security warnings when doing something like the following: private void Form1_Load(object sender, EventArgs e) { LoadContacts(); } private void LoadContacts() { Outlook.NameSpace outlookNameSpace = Globals.ThisApplication.GetNamespace("MAPI"); Outlook.MAPIFolder contactsFolder = outlookNameSpace.GetDefaultFolder(Outlook.OlDefaultF ...Show All

• Visual Studio 2008 (Pre-release) .NET 2.0 and .NET 1.1 clients for WCF Service

  Hi, I have written a WCF service. I want to consume it in .NET 1.1 client and .NET 2.0 client. My client system does not WCF infrastructre installed. Any idea how to generate the proxies for tese cleints and use them Thanks, Venkat //If we don't have WCF runtime,and if you have only .NET 1.1 /or 2.0,you can use this solution Web Service (ASMX) Client with a Windows Communication Foundation Service http://windowssdk.msdn.microsoft.com/library/default.asp url=/library/en-us/wcf_samples/html/3ea381ee-ac7d-4d62-8c6c-12dc3650879f.asp //If you don't have .NET runtime also,you can implement following solut ...Show All

• Windows Forms Subject morphs to PostMessage?

  I have a CheckedListBox which draws its contents from a datasource, and this is set at design time. When the form loads up, there are 8 items in the CheckedListBox, but no matter where I seem to intercept events before the form appears, there are always ZERO items in the box. At what point can I assume that the data binding has actually filled&nbs ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. MDX, where do I put the symbol files?

  Sorry for the newbie question, but where do I put the Symbol files I am using April 2006 release, VS2003, MDX, x86. Thank you. Well I didn't have that directory, but after a little hunting I discovered that its a separate download. http://www.microsoft.com/downloads/details.aspx familyid=562D72FC-61C8-41A3-8BFF-509466F3D6AA I always assumed these were for C++ only but you are correct that there are symbols for the managed assemblies too. I believe that you don't have to copy them anywhere - you just have to tell Visual Studio where to look for them. Tool/Options/Debugging/Symbols. I'm not sure if you can specify the root direct ...Show All

• SQL Server Cache Problem

  I am using Reporting Services with SQL Server 2000. The report is called in IE and rendered in PDF and displays correctly. However, the problem I have occurs when, during the same IE session, first I call the report, then change the values in the database, and call the report again with the same parameters. The second time, the values in the report remain the same as the first one. Somehow, the second time I call the report, it is not generating a new one but using the one in Cache. If I close IE, reopen it and call the report then the new values are displayed. In the Report Manager Properties/Execution, I chose to execute the report ...Show All

• Visual Studio Team System Changing Permissions on New Branches

  Hi, I am working on a project to migrate from a custom version control system to Team System and I am currently investigating auditing possibilities. One preposed method is to have developers branch from the current project baseline, work in the new branch and then have an auditor merge the changes from the new branch to the baseline. The problem with this is that developers do not have checkin privileges on the project's baseline so when the baseline is branched, they cannot checkin code on the new branch. Is there a way to automatically change the privileges on this new branch to allow developers to checkin code Or is there a way to all ...Show All

• Visual Studio Microsoft Document Explorer cannot be shown because the specified help collection 'ms-help://MS.MSDNQTR.v80.en' is invalid

  I have installed a RC version of VS Team Suite along with full MSDN installation. After completing installation, I'v got " Microsoft Document Explorer cannot be shown because the specified help collection 'ms-help://MS.MSDNQTR.v80.en' is invalid " error when I have tried to access it by doing "Start" -> "All Programs" -> "Microsoft Developer Network" -> "MSDN Library for Visual Studio 2005" When I accessed it from VS 2005, it only have SQL help available. I have tried to reinstall it several time but no luck. Any help would be appreciated. Eric I have the same results as Pieter, n ...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 e.g. -------------------------------------------------------------------- DECLARE searchStr VARCHAR(20) SET searchStr = 'text to search for' UPDATE Table1 SET col1 = REPLACE(CAST(col1 as VARCHAR(8000)),searchStr,'') WHERE col1 LIKE = '%' + searchStr + '%' AND ...... --------------------------------------------------------- ...Show All

• SQL Server Store the output of executesq

  hi I am trying to store the output of sp-executesql into a variable to implement it as a user defined function later The function is ALTER function [dbo] . [UnitsAvailable] ( @id int ) returns int as begin declare @sql nvarchar ( 100 ) declare @params nvarchar ( 500 ) declare @count nvarchar ( 10 ) set @sql = N 'Select count(*) from units where projectid=' + convert ( varchar , @id ) + 'and sold=0 and displayunit=1' set @params = N '@countOUT nvarchar(10) OUTPUT' ; exec sp_executesql @sql , @params , @countOUT = @count OUTPUT ; return @count end The r ...Show All

• SQL Server Shredding recordset object var in ForEach loop (problem)

  I have a package that starts by loading a recordset into an object variable. The recordset is then enumerated with a ForEach loop. The loop sets some string variables. Within the loop container I have a Script task that uses a MsgBox to show the results for testing purposes. The package uses checkpoint restart (if that matters ). The first time I run the package the 1st record is displayed in the MsgBox, then the 2nd, but then the loop is stuck on the 2nd record forever. I break the run, and when I rerun it the 1st record is displayed followed by each subsequent record correctly and the package completes successfully. Now, if I were to r ...Show All

• Visual C# timer

  Hi all!I have these two lines of codes in my program: float time = (float)DateTime.Now.Second; xyGraphControl1.AddPoint(time,power); The result of the codes is that the timer starts at the same second as the clock in my computer. How am I going to force the timer to always and only start at 0 second Thank you very much! or, change your code like so: float time0 = (float)DateTime.Now.Second;   //   initial time //   ... stuff happens float time1 = (float)DateTime.Now.Second;   //   current time xyGraphControl1.AddPoint(time1-tim ...Show All

• Windows Forms How to have multiple panels?

  I'd like to implement a multi panel interface into my Windows Application. What I mean by muilti panel is where when a menu item is selected the appropriate panel shows in the the body of the form. When another menu item is selected the curent panel is removed and the other menu item panel is shown. How can I implement this easily Some other programs which have a similar feature are Tweak - XP and Ad-aware. Make sure to create a separate project for the controls. Basically, you will want to create a user control for each of the view that you would like. Specify the docking/anchoring on the widgets. O ...Show All

• Software Development for Windows Vista Vista backward compatibility

  Hi, is MS Vista supposed to be backward compatible with the other MS win32 operating systems I mean, if I have an application running on MS Windows XP, can it run on Vista as well thanks. My ADS Tech PTV341 DVB-S works only with XP, not Vista nor W98SE, something to do with BDA. ADS Tech has been promising a fix the last year or so. Thus Vista is NOT "backward compatible" Couldn't MS provide a 'switch' in Vista to enable the appropriate functions Regards, Roger ...Show All

• Visual Studio 2008 (Pre-release) Change to MSMQ URIs

  Hope someone can help with this.  There appears to have been a change in the URIs required for MSMQ binding in the most recent WinFX release.  I used to use   "net.msmq://bleuchamp/batchjobconfirmation" in my app, but now this produces an exception "The provided URI scheme 'net.msmq' is invalid; expected 'msmq.formatname'. Parameter name: baseAddress Anyone know what the correct new format is   This is a public queue, and it's being set programmatically - the queue name can be altered at runtime, so not possible via config file.  The exception is thrown by ServiceHost.Open(), the URI having previously been ...Show All