Pratyush's Q&A profile

• SQL Server External Activation with "n" servers processing messages.

  I am attempting to use Service Broker to distribute message processing across multiple machines. I have mulitple queues setup to all notify a single service with the QUEUE_ACTIVATION event. My external application then sits in a "WAITFOR RECEIVE" on that event queue and when it receives a message for a particular queue, will begin processing the messages in that queue if that particular server is configured to process messages of that type. My problem is that once one server starts receiving messages, the others don't always start processing and I end up with one server attempting to process all the messages by itself. What is the best way to notify multiple servers that there are messages in a particular queue which need process ...Show All

• SQL Server "Connect Object Explorer" issue

  HI All, When I connect to a remote database server my IP gets stored in the Object Explorer connection wizard. How do u ensure that once the server is disconnected you have to reenter the server IP again. It also shows the username as soon as i enter the server name. I don't want this to happen. Please help. A SQL Server MVP had the same question not too long ago. We found him an answer and he posted it on this blog: http://devcow.com:80/blogs/adnrg/archive/2006/09/08/Clear_SQL_Server_2005_Management_Studio_recent_servers_drop_down_list.aspx Basically, there is no way to clear it out through the UI. You have to delete the following file: C:\Documents and Settings\<user>\Application ...Show All

• Visual Studio Solution Folders in Projects - Can IDE be tricked into doing it

  Forgive me for asking this question in this forum, if it is in appropriate. I love VS "solution folders". They make organizing support material trivial. However, as near as I can tell they can only exist at the solution level not within projects. Here is what I'm doing As seen by me Project A Stuff needed by VS Art Data Doco After build or installation as seen by program: program's exe Art Data Doco Because I'm linking all the contents into Art Data and Doco from master solution folders - a slick trick IMHO - within the structure of the project on the hard drive Art Bin and Doco are empty at the level of the the project. Yet VS forces me to add a real folder in which to put the links. Thes ...Show All

• Visual Basic TNS error through visual studio connection string

  I am trying to connect to an Oracle database (I think it is 9.x) on a network using VS 05'. I made a form (form1) and started adding a new data source (strongly typed). This is where I get the TNS error - ORA-12154: TNS:could not resolve the connect identifier specified. My tnsnames.ora file is correct, and I can connect to the server using PL/SQL, I just can't connect through VS. So my question is- does VS require the tnsnames file to be located someplace else other than in the Oracle directory I am able to connect without trouble on my laptop through VS without changing the directory location of the tnsnames file. datawhse = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = datawhse.home.com)(PORT = 1521)) ...Show All

• SQL Server When debugging, do you have to shut down and restart BIDS every time you rebuild the custom component that you're debugging?

  Hi, I have found that when I'm debugging a custom component in BIDS that I've created in another instance of Visual Studio, every time I rebuild the component I have to shutdown and restart BIDS and then reattach to the BIDS process. Which is pretty time consuming... And if I find a small error in my custom component when debugging then I don't seem to be allowed to make any changes to the code unless I stop debugging and go through the process above. Am I missing something here Or do I really have to manually go through these steps every time I want to change code in the component I'm debugging Can I automate the process with MSBuild or NAnt If so, is there an example of this anywhere Thanks in advance, Lawrie. ...Show All

• Visual Studio How to convert property into item group

  I have property defining dependencies <XDepends>a;b;d</XDepends> how can i convert it to item group or somehow iterate on all the values seprted be ; Thanks, Sajjad Something like the below example would convert a property with ; seperated line to an item list <PropertyGroup> <Test>a;b;c</Test> </PropertyGroup> <Target Name="Build"> <CreateItem Include="$(Test)"> <Output TaskParameter="Include" ItemName="out"/> </CreateItem> <Message Text="%(out.Identity)"/> </Target> Thanks, Jay Shrestha ...Show All

• Visual C++ Error regarding the includes

  Hi all, I faced a problem with a code in VC++ 6 . The errors are "fatal error C1083: Cannot open include file: 'qedit.h': No such file or directory GraphicsRendering.cpp " - and the same error regarding another file called 'dshow.h' I did not write the code myself. These two files are not existant with me but I found that there are some include statements in another header files belonging to the same workspace that are not existant also in the PC evenso it does not complain about them. It is sometihng regarding Directex but I have installed it..May be the version Appreciating any replies Hello Re: Error regarding the includes Such questions are outside the scope of this ...Show All

• Internet Explorer Development Issue on iframe and page reload

  Hello I'm quite sure this is the best forum to post to, since I fear it is an Internet Explorer issue even if part of the problem is with pages with server content (a jsp) I have a issue with a iframe and an application we are developing. We have a page (a fragment of a page in a tile build by Struts, actually) containing the following code: <iframe id= "menuFrame" name= "menuFrame" frameborder= "0" scrolling= "yes" src= "<c:url value='common/menuFrame.jsp'/>" height= "700px" width= "190px" > </iframe> ... In the page there are other tiles containing code that submits a form, reloading the page with new data (and in so doing the frame ...Show All

• SQL Server BCP (BULK INSERT) with only <lf> as line delimiter (not <cr><lf>)...

  Hi, This might be a noob question, but is there any way to specify just <lf> as a line delimiter, and not <cr><lf> ( /n ) as line delimiter in T-SQL call for BULK INSERT (or BCP utility). How please TIA. Usually any of these three combination would work for all kinds of files. /n /r /r/n You might try /r first, I think that's the one you need if /n doesnt' work. /Kenneth ...Show All

• Windows Forms Smooth Progress bar

  Hi I have the following code, but when i run the form the progress bar is not smooth i was wondering if anyone can help me 1. to make is smooth 2. to make it faster I am a beginner to c# so could you please give me as much as information as possible. Thanks in advance { public partial class Form1 : Form { static int count=0; //time count public Form1() { InitializeComponent(); this .timer1.Interval = 1000; // set timer to tick each 1000ms this .label1.Text = "LOADING ..." ; //"Loading ..." text } private void timer1_Tick( object sender, EventArgs e) { if (count < 15) { count++; //each 1000ms increase time count pro ...Show All

• SQL Server Error in sql management express installation

  Hi, I had earlier installation of microsoft sql server 2005 in my machine. Recently I installed the visual studio 2005 beta which comes with sql express and after going through many hoops(as it kept complaining about the previous installation of beta components) i was able to install it correctly. I was also able to also use visaul studio 2005 server explorer to connect to the SQLEXPRESS and create table etc... Now I wanted to install sql server management express so I downloaded SQLEXPR_ADV from te microsoft's website. During the installation it complained about the older version of SQL server management sutdio installed and hence could not install the sql server management express. By looking at different forums I found following st ...Show All

• SQL Server SSIS connect to cube and extract fact data

  Hello, how can I connect to a cube (on a SQL 2005 server) and get (fact) data to process with SSIS I looked at the toolbox but I see no applicable tool. It would be fine if somebody can provide a link to an article or example. Thanks in advanced! -flyall- Pipo1 wrote: ... although I'm pretty confident that this is not exactly the intended use; SSIS is, due to the nature of the product, better equipped to get data into a cube, than it is to get it out. But hey, where's the fun in using products for what they were made for Hi, I have to transfer data from the Cube into another system via a file interface. Report services do not have the power to set the data in the right w ...Show All

• Gadgets IFrame Sample

  Thanks tod ToddOs, my module has now been submitted and it's working ... The 10 downloads I got so far don't really compare well to the 15,000 hits I get from G**gle per day, but what the hell, at least I'm learning :) Anyway, since the script appears to work well, I think it could potentially be useful to others as well. Here are the individual files, which have to be packaged into a ZIP file for submission. This will load an iframe from http://www.tapper-ware.net/patience/live/patience.htm , resize it to width=100% and height=224px ==== gadget.xml: ==== < xml version="1.0" > <rss version="2.0" xmlns:binding=" http://www.live.com "> <channel> <title>Solitaire / Patience</title> <descri ...Show All

• Software Development for Windows Vista WF and Sql Server 2005 Service Broker

  I am not sure of what the current mix between the two is and what is planned for the future. My ideal app would allow for a "messagebox" BT-like messaging glue so that each step in a workflow can execute on any number of servers. Sql Server 2005 Service broker sounds like the ideal solution. Are there any online resources discussing this particular issue Thanks Costas Hi Costas, I am not aware of any SSB related activities but Tomas Restrepo has created some activities for MSMQ that should basically let you do the same thing. See http://www.winterdom.com/weblog/2006/03/03/MSMQWorkflowActivitiesV1.aspx for the details. One thing to keep in mind if you want to do some form of load bal ...Show All

• Visual Studio Team System How to Add .cs test into a Load Test scenario?

  I used Code Generator to generate the C# code for a Web Test. I want to run a load test based on the C# test scripts. However, when creating a load test project, I found the load test wizard did not allow me to add a test that is C# based. How could I make this work or, VS does not accept .cs test scripts at all. Thank you Thank you, Rick. I have added the .cs files into the load test project. Thanks for your help! Matthew ...Show All