Michael J Brown's Q&A profile

• SQL Server Indirect Configuration in SSIS

  Hi, I need to configure my package using SSIS Configurations. When I opened SSIS Configuration wizard, press ADD and selected Xml Configuration, I found two options. One being : Specify configurations directly. next : config location is stored in env variable. How to use the second option [ env variable]. Say I want to configure my connection string for my destination database [ OLEDB Destination Component]. How to do that using second option. Thanks Kishan this link might also help: http://dotnetjunkies.com/WebLog/appeng/archive/2006/05/30/indirectconfigpackagessis.aspx ...Show All

• Visual Studio Team System Problem resolving merge conflict

  Merging from Main to Dev Get a conflict on file A Click on resolve conflict Dialog says building change summary Processor is shoots to 50% usage, fan kicks in and it never comes back. Let it run for 8 hours(over night) and it never came back. I have reduced the merge to just this one file and it will not return from resolve conflict. You can hit cancel and the dialog goes away but it never recovers from eating half of the processor. You basically have to kill VS. We've fixed this, thankfully. Please download SP1: http://www.microsoft.com/downloads/details.aspx FamilyID=8D702463-674B-4978-9E22-C989130F6553&displaylang=en ...Show All

• Software Development for Windows Vista remote debugging in Vista

  I'm trying to remote debug a simple application compiled with VS2005. The dev machine is running VS2005 pro, and the vista box has the remote debug tools installed. I turned off the vista machine's firewall so that would not be an issue. I started the debugger with: "C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\Remote Debugger\x86\msvsmon.exe" /timeout:99999 /noauth /anyuser /port:23 I'm running XP on the dev box (source), logged into one domain, and the vista box is logged into a different domain. I turned off authentication in msvcmon because of this. I also tried using the "run as administrator" with msvcmon, to no avail. The debugger connects (I get a "user connnected" message in msvcmo ...Show All

• Windows Live Developer Forums Setting order's MSNDistributionSite (using API)

  Hello Microsoft, I set an order's MSNDsitributionSite to UnitedStates (via API). When I retrieve the order (via API), I see the MSNDistributionSite field is properly set. When I look at the order in the UI, "Target the location of your customers" is set to "Allow all customers to see my ad". It should be "Select countries/regions" and only the UnitedStates value should be selected. My question is: to whom are my ads presented US only or all over the world Why this inconsistency between API and UI Thank you, Orest My mistake. OrderTarget field of AdCenterOrder class is in charge with what I need, not MSNDistributionSites. Thank you, Orest ...Show All

• Visual C# User-Define Class Library usage and indexing

  hi, I am relatively new to c#. I created several class in a class library project (see the code below). And these classes have a relationship like: HSLibrary.HSLibA.ClassA.ClassB But now I have 3 problem, 1.In the old version, HSLibA only has one child classA, and ClassA also has only one child ClassB. But now in new version, HSLibA has collection of ClassA, and ClassA also has collection of ClassB.I used the System.Collections.ArrayList (I learned it from some articles I read). So now I can use ClassA.HSSettings.Add to add a new ClassB class without any error message, but I can't get any property or method of the ClassB. (Ex. HSLibA.ClassA.HSSettings[index] ) 2.When I import this class in other projects, can I use the strin ...Show All

• .NET Development Native Sybase ASA .NET data provider and VS2005

  Hi All! I have Sybase ASA Net data provider installed, but VS doesn't support it. I can connect to Sybase server via ODBC, but I can't connect by native provider. Server Explorer - Data Connections doesn't contains Sybase driver in list of available data sources. Is this driver can be registered somewhere in VS to allow visual operation Thanks in advance, Alexander I believe that VS integration and driver support is different. Since you have the driver, it means that you can access the db with your app at runtime with this provider. For the Sybase db to be intergrated in VS, sybase or someone else would have to create a VS extension to provide that feature. You can look at the vs sdk documentation. Regards, ...Show All

• SQL Server Extremely Poor Performance - Identical DB's but very different performance

  Hello Everyone, I have a very complex performance issue with our production database. Here's the scenario. We have a production webserver server and a development web server. Both are running SQL Server 2000. I encounted various performance issues with the production server with a particular query. It would take approximately 22 seconds to return 100 rows, thats about 0.22 seconds per row. Note: I ran the query in single user mode. So I tested the query on the Development server by taking a backup (.dmp) of the database and moving it onto the dev server. I ran the same query and found that it ran in less than a second. I took a look at the query execution plan and I found that they we're the exact same in both cases. Then I too ...Show All

• Visual Studio Express Editions RichTextBox - two questions.

  Hi I am using 3rd party dll to receive string messages and displying them in RichTextBox. How can I limit the amount of lines to be in specific number (let's say 100) and in case 101 message arrived delete the first one and insert the new message at the bottom How can I autoscroll the scrollbar in the RichTextBox to the last message that arrived (on every message that arrived the cursor move to the first line). Thanks in advance Asaf. " How can I limit the amount of lines to be in specific number (let's say 100) and in case 101 message arrived delete the first one and insert the new message at the bottom " What action do you want taken Do you want the additional traffic ...Show All

• Visual Studio 2008 (Pre-release) How to get the button on a toolbar to stay suppressed on mouse click?

  Hi, I have a toolbar a number of buttons, each button on click brings up a page. What I would like is to have the button stay suppressed until another button is pressed. The Microsoft Internet Explorer has this behavior with "Search" or the "Favorite" button. how can I do this Thanks in Advance You can use a togglebutton. These buttons have two states and also get the appropriate style, when nested in a toolbar. If you handle the click on the toolbar, you can then also easily uncheck all other togglebuttons nested in the toolbar, so that only one button is pressed (active) at a time. ...Show All

• Visual C++ catch(...) behavior are different in Debug and Release mode ?

  Hi, I have wrote an simple program to test catch(...) statement using VS 2003. But I found that in the Debug mode, it can catch the error; but in the Release mode, it failed ... How can I fix the problem Thanks A Lot, #include <iostream> using namespace std; int main() { int* p = 0; try { *p = 13; // causes an access violation exception; } catch(...) { cout << " in catch(…) block ..." << endl; } return 0; } Hi, Einaros: Thanks A Lot for your help. I've tried again by your description, and I found that the C/C++ > Code Generation > Enable C++ Exception option is a combobox , so I have to choose No or Yes , but if I choose Yes , the compile opti ...Show All

• Visual FoxPro Help with rounding

  Help!  I have to round a number to the closest 500 but if last three digits are between 0 - 250 round down, 251 - 499 round up, 500 - 750 round down, 751 up, round up. Example: 2140 should round to 2000 2257 should round to 2500 2660 should round to 2500 2760 should round to 3000 Thanks in advance! Expanding on Giulio's idea, here's a function for you. I've only tested this with your data values, so be sure to test more extensively. FUNCTION RoundToNearest(nNum, nNearest) nRemainder = MOD(nNum, nNearest) IF nRemainder > nNearest/2 nResult = INT(nNum/nNearest) * nNearest + nNearest ELSE nResult = INT(nNum/nNearest) * nNearest ENDIF RETUR ...Show All

• SQL Server Issues --- PLEASE HELP

  i am running the following and i keep getting process errors " can not read next data row for data set SERVER. transaction process id 838 was deadlocked on lock comminication buffer resources with another process and has been chosen as the deadlock victum rerun transactions." SELECT transactions.practice_id, practice.practice_name, CONVERT(smalldatetime, transactions.closing_date) AS Date, transactions.type, ISNULL(SUM(trans_detail.paid_amt), 0) AS Pmts, ISNULL(SUM(trans_detail.adj_amt), 0) AS Adjs, 0 AS NSF, transactions.tran_code_id, 0 AS Debits, 0 AS Credits, 0 AS Capitation, 0 AS UnAppl, trans_detail.system_charge_code,'' FROM provider_mstr RIGHT OUTER JOIN charges O ...Show All

• Visual Studio Team System Different deploy requirements for differrent environments

  Hi, I have an unanswered thread here: https://forums.microsoft.com/MSDN/ShowPost.aspx PostID=912956&SiteID=1 about how we manage differrent requirements for different environments. Here's an example of a problem I'm having. Our developers are all grouped together in an AD group called SomeDomain\Developers. That group has various permissions assigned in our dev environment. We also have those same permissions setup in our DBPro project. However, we don't want that group to have the same permissions on our other environments. In fact, when we go into our live environment we don't want this group to have any permissions at all. If we use DBPro to do all of our deployments then, unless we change something, that group will ...Show All

• Visual Studio Tools for Office Display Word Document onto a Panel

  Hi all, I want my application to automate a MS Word Window and display within a panel. Is any one know how to do it Thanks VSTO doesn't support some of the Windows Form controls on Office documents, and the Panel control is one of them. See http://msdn2.microsoft.com/en-us/library/ms178765(VS.80).aspx for details. ...Show All

• Software Development for Windows Vista Where can I host the runtime in a SOA based environment?

  Hello everybody, I am planning to use Listen, Delay and event-based Activities in a sequential workflow like the one in the hands on labs WF HOLD01. In this case the manager can approve the report, otherwise it will be escalated if a certain time-limit is exceeded... Now my question, how and where can I host the runtime if my architecture consists of web services (or respectively wcf in aspnetcompatibility mode) and the workflows take several days So far I hosted the runtime in an Application variable and after each service request I saved the instances through the manualworkflowscheduler service in the database, but now I want to add a LISTEN Activity and inside a DELAY Activity which executes after 3 days, so I must not save th ...Show All