shax's Q&A profile

• Microsoft ISV Community Center Forums HTTP request - simple problem

  I have a small server application (PHP) that is envoked with a URL and writes the attached parameters to a file. I want a client application to do the HTTP work. How do I call an URL from VBA without launcing a browser The URL (requested by a client application, not a browser) looks like http://www.test.com/fileWrite.php var1=234&var2=26&var3=4 Hi, You can use MSXML's XMLHTTP object to make requests. Here's an example: Private Sub Command1_Click() Dim HttpReq As New MSXML2 .XMLHTTP40 HttpReq.open "GET", "http://XMLSampleServer/CatalogServer.asp", False HttpReq.send MsgBox HttpReq.responseText End Sub ...Show All

• SQL Server Passing value inthe Query

  Hi All, I have problem creating query. here is the scenario I have a table EMPLOYEE , the fields are Employee Name, month1,month2,month3,..month12 thomas,100,1200,400...1200 wilson,500,1100,500...1000 carol,200,500,200... 3400   I am creating report using visual studio reporting services I am passsing the report parameter to the query, but i could not the actuall result MY PARAMETER  is 2 ( varrialble is gmonval) I am writing the query  like, select empname,"month"+Ltrim(@gmonval) from employee the result which am getting is thomas,month2 wilson,month2 carol,month2   it suppose to be thomas,1200 wilsom,1100 carol,500 how to get the above result. plea ...Show All

• SQL Server SQL 2005 becomes unresponsive Help

  I have a very strange issue going on with my SQL 2005 64bit version of SQL. The OS I am running is server 2003 r2 64bit enterprise with 12 gig of ram with dual core Xeons. The server runs fine for a while and then all the cups go up to about 90% for no reason. There is nothing in the SQL logs or the Events Logs. When this happens all of my websites and internal apps become unresponsive. The server has been running perfect for about 6 months and now this. The only software I have added besides SQL is LightSpeed by Quest. My server also Pages what I would say is way to much. The swap file is 16 gig and never gets about 11.5 gig full. I have service pack 1 for SQL installed from the beginning. I also from time to time get a general network e ...Show All

• SQL Server Derived Column Transformations - DT_STR operand cannot be used with the conditional operation

  Hi all I am trying to convert the string "(null)" in the [PASSWORD] column of my table to an actual NULL value. I have tried to use two different forms of a conditional operator to achieve this end. However I am getting the below errors both can be summed up with the following statement. DT_STR operand cannot be used with the conditional operation. The expression directly below however is using a type DT_I4 in the conditional clause as this is what FINDSTRING returns. Hence the equivalencey test to the literal integer 0. So I must say I am somewhat confused by this. Does anyone know why neither of the below statements are working Also is there an easy way to accomplish what I am trying to do - convert the string "(n ...Show All

• Windows Forms Win Vista - Setup Project Deployment

  I have a Setup Project Deployment in VB.NET 2005 for my application In that project I use a Custom Action with a argument "\install" to install a Auxiliary Tool that my application needs in order to run It works fine in Windows XP...but in Windows Vista my setup crashes when it tries to install that auxiliary tool How can I fix this in order to be compatible with Vista another question : How can I change the custom action in order to install auxiliary tools by users choice If all you want to do is conditionally launch the custom action, but don't need to know the checkbox state inside of your custom action: you don't need to pass the checkbox state to the custom action usi ...Show All

• Visual Studio Team System TFS Migration to a new server

  Has anyone been successful in migrating a TFS server to a new machine with a new name We are currently still using the RC, but I was surprised at some of the problems I had during a migration. Specifically Sharepoint, I don't know if its been improved with the RTM, but the restore procedures I saw were just wrong. The 1st trial I did had Sharepoint completely messed up. I finally fixed it, but it took my own understanding of Sharepoint, not the backup\restore procedures provided on msdn. Has anyone else had these issues We are experiencing the same issues, but we already went thru the process and restored all the databases, including the config one. So if this is the case any idea what our best course of action is In your recommenda ...Show All

• Visual C# How do you define a method with optional/default parameter?

  Thanks Maybe the documentation is buried somewhere. I just a want to implement a simple optional parameter in c#. Something like; int Function(int index, bool recurse = true) Its saying "Default parameter specifiers are not permitted." For some reason, overloads don't work quite well when you are writing COM. I want to experiment if optional parameter will work. Also just for regular programming, it will be nice to know if optional/default parameter is doable in C#. ...Show All

• Visual Studio Team System From Express to Team

  I just installed Team Suite from Express. Do I need to rebuild the current projects I'm excited, it seems there are more tools/option in the Team version Thank you Luis, that's very kind of you. A few hours ago the prob has solved. Somebody told me to install "Virtual CD-ROM Control Panel v2.0.1.1" and change the .img to .iso and it worked. Best regards, ...Show All

• Visual C++ c++/cli wrapper assembly fails to load

  Hi, I have a class A (unmanaged code, exported in A.dll). I wrote a wrapper B in a new assembly interfacing class A and its members/methods. This is all done in Visual Studio 2005 Standard. Now I wrote 2 test programs - the first as c++/cli and the second in c#. No matter which of those two I invoke, on startup a BadFileImage Exception is thrown. And the first line of code is never reached. What can be wrong here I have a similar project, where a class A is exported by a static library. In that case, everything works as expexted. I do not understand what's going wrong here. Any help is appreciated. ...Show All

• Visual Studio 2008 (Pre-release) Can Triggers affect elements they are not applied to?

  I have this program here that consists of a Label and a Button.  I have a Style that contains a trigger that says that when someone mouse overs the button the button background should turn yellow.  But let's say I wanted the label to also turn yellow when someone mouses over the button.  How can I have a Trigger applied to one element (in this case, the button) affect other elements around it   I know you can do this in code, but how can this be accomplished in XAML   < Window x:Class = " WindowsApplication3.Window1 " xmlns = " http://schemas.microsoft.com/winfx/2006/xaml/presentation " xmlns:x = " http://schemas.microsoft.com/winfx/2006/xaml " Title = " WindowsApplication3 " Height = " ...Show All

• SQL Server PSSDiag Failed to instantiate an XML DOM

  Can anyone explain to me what I need to do to correct this I have ran the SAME PSSDiag install from the this particular server MANY times before. All of a sudden, it now fails to start and I find this error, that is posted in teh subject line of the thread, in teh Windows Application Event Log. If I need to install another app in order to correct this, please let me know if the installed app will need a reboot of the server to take affect. I have to schedule down time for that. Thanks ALL! Check with this http://www.microsoft.com/downloads/details.aspx familyid=3144b72b-b4f2-46da-b4b6-c5d7485f2b42&displaylang=en ...Show All

• SQL Server Linked Server issue

  I have a problem querying a linked server connected via the OleDB provider for ODBC. This is the DataDirect 32-BIT SequeLink 5.4 client driver connecting to a FileMaker Pro 8 database. I've tested this in VB.net 2005 by adding an ODBC connection in server explorer and a data grid to a form. I can run the tooty and the data loads in the grid with no errors what so ever. So using the above ODBC connection I added a linked server called 'DNA' and run the following query on the Stock_DNA table. SELECT * FROM OPENQUERY ( DNA , 'SELECT * FROM Stock_DNA' ) The result I get is this; OLE DB provider "MSDASQL" for linked server "DNA" returned message "Requested conversion is not supported.". Ms ...Show All

• .NET Development Manually disconnect from network?

  Is there a way in C# to disconnect from the current network Thanks, There is no way to do this from a .Net Framework library. THere may be a native API to do this which you could P/Invoke to, but I will need to do some searching to see what that would be ...Show All

• Software Development for Windows Vista Setting custom HandleExternalEventActivity properties on activation/creation

  I have what must be a common and simple requirement in my WF application but I am unable to see how it it can easily be achieved. The application contains a large library of custom activities, many of which subclass from a single "UserActivity" activity, which in turn derives from HandleExternalEventActivity. These are all human activities, which block until a user sends a message to the runtime (hosted in WS) from the client application to notify the WF that the current activity is completed. All of this works fine. However, during creation (not invocation) of each UserActivity for the first time I want to set some properties from internal business rules. For example, UserActivity has a DateTime property called TargetFinishTime. This is s ...Show All

• Visual Studio Default values not stored

  When properties have default values, their values are not stored in the XML model. This means that when the default changes in the DSL, it is automatically propagated to all the models. This isn't always the wanted behaviour. I think you should be able to specify that the default is only used during creation of an element, thus storing. Furthermore, if you want to do something with the XML, the default value is not available. The consequence of this is that the default is defined at two places, in the DSL and in the tool that uses the XML. I would like (at least in some case) the property values to be stored always, even if they contain the default values. This prevents a double specification of the default value. I have ...Show All