tssweb's Q&A profile

• .NET Development How to avoid the garbage collection in the call to COM

  I got 3 party COM object with a method int RetrieveAdjAndUnadjStock( int MarketNumber, int StartDate, int EndDate,       VARIANT* IntResultArray, VARIANT* FltResultArray).   IntResultArray is a 2 dimensional integer array and FltResultArray is a 2 dimensional float array. I am making on evere run of my app 7,000-7,500 calls to this method with different parameters. in C# interop generated by type library both IntResultArray and FltResultArray became out objects so I got boxing and to work with them I need later to unbox them. So on every call there is double construction of both arrays and destruction(and eventually garbage collectio ...Show All

• SQL Server Please help - Missing sqlbw.exe of SQL Server 2005

  Recently, my SQL server infected with virus which modified some of .exe files on the server. Unfortunatly, the auti-virus software found those infected .exe files and removed them from server including the sqlbw.exe. Now I can't run the management studio. I tried to reinstall the only the management tools but failed. It said that my version is incorrect. I also tried to apply the SP1 but failed too. What can I do to recover only the management studio I don't want to uninstall the SQL server because I have live database running on it. Please help. Why are you trying to run sqlbw.exe You can launch management studio using sqlwb.exe and not sqlbw.exe Thanks, Sravanthi ...Show All

• SQL Server Report Sever . WMI . PathNAme propery

  I am not connect to reportserrver by means WMI to read PATHNAME property my code: ConnectionOptions connOptions = new ConnectionOptions (); connOptions.Authentication = AuthenticationLevel .Default; scope = new ManagementScope ( "\\\\<servrername>\\root\\Microsoft\\SqlServer\\ReportServer\\v9\\admin" , connOptions); scope.Connect(); ### exception : Acces Deny; if i write: ConnectionOptions connOptions = new ConnectionOptions (); connOptions.Authentication = AuthenticationLevel .Default; scope = new ManagementScope ( \\\\ <servrername> \\root\\Microsoft\\SqlServer\\ReportServer\\v9 , connOptions); scope.Connect(); // Create the server class. Ob ...Show All

• SQL Server SELECT DISTINCT problem

  I am trying this query which return 247rows: select * from event_log where event_id like '%accounts enabled%' and this query which returns 242rows: select distinct description from event_log where event_id like '%accounts enabled%' but I want to combine both together, which means I want to select all columns in the table but it should have a unique description field.. i tried: select distinct description, event_log.* from event_log where event_id like '%accounts enabled%' but it returns 247rows.. I also tried this but it also returns 247rows: SELECT DISTINCT DESCRIPTION , EVENT_LOG_ID , DATE_TIME , NODE_NAME , LOG_TYPE , SOURCE , CATEGORY , EVENT_TYPE , EVENT_ID , USER ...Show All

• SQL Server Loop container to process all excel files

  What I'm trying to achieve is a SSIS package that will pick up 1 or more excel files, process the data in them via the conditional splitter, pushing the good data into a table, and all other rows into an error table. I'm having some issues using the ForEach container to process multiple excel spreadsheets into tables. The excel import into the tables is more or less working (imports data for good cases, but uses a null if the Excel Source when it gets an unexpected value - but that's a seperate problem). I found something related to this when searching, but it related to CTPs (June and September) and trying to reuse the connection strings they built up there (using my own variable names, naturally) causes a 'Property Va ...Show All

• Visual C++ MSDN Forum Problems

  Last week i had some problems in posting my replies to MSDN forums. Yesterday one of my post were automatically posted and even I could not edit or delete it :( What could be wrong I tried with both Firefox and internet explorer to post my answers. I believe this not the problem at my end. Even if error page displayed. some of my answers were already posted to the forums Is there any problem with Forum Servers The error page had the following error message We apologize, but an unknown error has occured in the forums. This error has been logged. I had a similar issue, but didn't even get an error message. I was unable to post, reply, or edit my posts. The posting page just kept reloading. Tried ...Show All

• Visual Studio Express Editions Can someone help?

  The problem is that I dont really know how to do this. Say I had the username textbox and the password textbox and I want it to send whatever anyone puts in them, to send it to my email... Do you know how to do this A general Idea but there are loads of of examples but the class/namespace you want to be looking at is System.Net.Mail. This will enable you to send email. You will need a mail server and you may need to authenticate yourself to send the emails but the general code is something like the following. If it doesnt work then do a web search on vb.net + system.net.mail.mailmessage for more information. 'Create a new MailMessage object and specify the"Fr ...Show All

• Software Development for Windows Vista Visual Studio .NET 2003 Professional still can't be installed on Windows Vista

  Since Vista B2, I faced the same problem to install Visual Studio .NET 2003 Professional:   The prerequisites CD fail to install .NET framework 1.1 and J# .Net framework 1.1, so I can’t continue the installation process since prerequisites aren’t guarantees.   I can figure how I can’t install .NET framework 1.1 since Vista come with its own 3.0 .NET framework. But why .NET 2003 install process still want to install an older .Net framework   Moreover, this issue could be bypassed by installing Visual Studio .NET 2003 Professional on XP SP2, then by upgrading XP to Vista. Not so convenient…and it is no long working with Vista RC2 upgrade.   Is their any plan to correct this issue ...Show All

• Windows Forms Modeless window does not lose focus

  Hello, How can I make a modeless window not release focus once the user clicks on another form in the application I tried using Deactivate event or LostFocus with no success. I basically need the functionality of a modal form, (i.e. ShowDialog, so it does not lose focus) but the code execution must continue after the form is shown . I also tried running ShowDialog from another thread, but this doesnt really make sense, and actually does not preserve the modality. Thanks! You do need to ask yourself first why "execution must continue". ShowDialog() starts a new message loop that keeps all events alive. Other forms in your app will keep painting themselves, they are just disabled so they ...Show All

• Visual Studio Team System Making all the fields in work item read only.

  Hi, In my work item I have a field "Status" whihc decides the status of the "Defect" work item. When the value of "Status" is closed, I want the work item to be read only. Hence I have put the following conditions for all the fields in my work item including the "Status" control. < WHEN field = "Defect. Status " value = " Close " > < READONLY /> </ WHEN > But when I set the value of "Status" as "Close" the fields does not become read only. Catch here is, if I remove the above condition for "Status" field, all the fields except "Status" field become read only. Is there some kind of cyclic action happenin ...Show All

• .NET Development Can Someone Help me With this ?

  hi all ------------------------------------------------------------- using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; public partial class Personal : System.Web.UI. Page { ITS . Learner_PersonalDataTable Personal_Info; string STUDENT_NAME = "name" ; protected void Page_Load( object sender, EventArgs e) { ITSTableAdapters. Learner_PersonalTableAdapter adapter = new ITSTableAdapters. Learner_PersonalTableAdapter ( ...Show All

• Visual Studio Express Editions Address Book

  I'm trying to write a program that is similar to an Address Book. I want the user to select a name from the dropdown list and the information will display in the text boxes I created. Everything seems to be working fine, but when I select a name, the first record on the list disappears and the information becomes mixed on the text boxes. For example, John Doe, Jane Bah, Jill Who. If I select John Doe first, everything is OK. After that, if I select Jane Bah, Jane stays but her last names turns to Doe. John Doe disappears from my drop down list. And then it's caose from there on. What is going on The only way I can access the first record is if I push the back button at the top. And finally, how can I cascade the dropdown list For exam ...Show All

• Visual Studio 2008 (Pre-release) Default Settings for the Designer

  Hi, I would like to know why there is no default settings somewhere, like preferences, whereby I can set the default behaviour of the designer when it loads. The default for the latest CTP is to show the designer and xaml editor at the same time in a split window. It would be nice if there were 3 default options, namely, 1 - the split window, 2 - default to the xaml editor, 3 - default to the designer. Thank you very much, Jaco We feel that there are more basic things to focus on first before moving on to finishing touches, such as option settings. As far as split view is concerned, we will take your suggestion into consideration. The current plan is to persist the split view settings on a per ...Show All

• Smart Device Development How To Monitor GPRS Traffic

  Hi, How can I monitor GPRS traffic I need to measure amount of bytes sended and received to/from certain IP during a day. Best regards. You can P/Invoke the GetTCPStatisticsEx for that: http://msdn2.microsoft.com/en-us/library/ms927394.aspx ...Show All

• Visual Studio Team System Installing Team Foundation Server (Databases) on a Cluster

  I cannot get the TFS databases to install on our existing SQL cluster. The installation doesn't give any errors during the system health checks, but, returns a general setup failed error during the actual install of the databases. The VSMsiLog has the following errors in it. ConfigureSql: Error 0x80004005: Failed to determine if database already exists ConfigureSql: Error 0x80004005: Failed to ensure database CurrituckDB.D19110DD_8531_4670_8844_A399C45690FF exists ConfigureSql: Error 0x80004005: failed to install databases Please help!! The SQL Cluster is already configured and running as the backend to several web sites. The web sites run on a set of load balanced servers. I tried installing to the ...Show All