Alessandro Camargo's Q&A profile

• Visual Studio Team System DataDude Worning

  Hi all, i get the following warning whene i use the built in Stored Procedure [sp_executesql]. here is my code: Set @parameters = N '@TO nvarchar(64) OUTPUT, @TId uniqueidentifier' Set @Select = N 'Select @TO = Username From ' + quotename (@tableName)+ ' where Id = @TId' EXEC [dbo].sp_executesql @Select, @parameters,@TId = @targetId,@TO = @TargetOwner OUTPUT TSD3012: The following dependencies are missing from your database project: [dbo].[sp_executesql].[@TId], [dbo].[sp_executesql].[@TO]. Your database application might fail at runtime when [dbo].[MyProcedureName] is executed. anybody help please Sorry that we did not follow-up sooner. The problem is that sp_executesql does not define named ...Show All

• Visual C++ Which function change from Unicode to Ansi ?

  Which function change from Unicode to Ansi Thanks you very much. Sarath. wrote: You can also make use of W2A ATL conversion macro Macros such as OLE2A , W2A and the likes cause Stack Overflows when used in loops . have a look on the Following Link http://www.codeguru.com/forum/showthread.php t=337247 ...Show All

• .NET Development How does Process.Start() redirection work?

    Hi All,      I've been working on creating a program that automates my program building and testing.  I am doing the code in C#, but there is a problem with the StreamReader.ReadLine() function where if it tries to read from a Process output pipe before the Process finishes writing to the pipe, it causes the thread reading from the pipe to block and the process then blocks too.  However, if the process is short lived, I have a likelier chance of getting all the output.  So now, I'm testing the Win32 API equivelants and a portion that I'm having issues on is collecting the stdout and stderr on process's children processes (the output is collected properly in .NET).    My que ...Show All

• Visual Studio Installation Problems Visual Studio 2003

  I attempted to update my Visual Studio 2003 through the program with Service Pack 1 yesterday. During the update, it hung, crashed and had to be killed through the Program Not Responding dialog. Of course this corrupted my Visual Studio 2003 installation. I attempted to Install/Repair my installation and that hung about 1/2 way through (writing setup.ini on the second CD). I am now attempting to Uninstall it and it hangs when Generating Setup Script. How do I escape this endless loop! Frustration abounds.... QuanT, Thank you for your response. I did try that with no success. I had to have Microsoft support help me and we finally got it all taken care of. Somehow the SP1 upgrade corrupted IIS which t ...Show All

• SQL Server Restore A Report Model From Reports Database

  Is there a way to restore / export a model from the report database You can click the Edit link in the model properties page in Report Manager. This will download the model as a file. Another option is to call the GetModelDefinition on the report server web service. This is what Report Manager does behind the scenes. We do not support or recomment direct access to the report server database. Hope that helps! ...Show All

• Visual C# Timer event unstable

  I need a timer to display seconds on my form and simultaneously trigger some events every 10 sec. The events in question involve checking for certain configurations in the input stream after the records are put in a few tables. My form's face is totaly inaccessible. I have a TabControl with the first TabPage covering the entire form. Therefore I set up a Label to display hh::mm::ss values on the first Page inside a GroupBox. The problem is that the timer stops and its behavior is so chaotic that it is hard to describe the full range. Occasionally it runs nonstop for a few minutes until I close the form. At other times it displays only one value then stops. If I change TabPages it will almost certainly stop but not always. Just once I ...Show All

• SQL Server Remove "CONSTRAINED" flag on Paramaters using Graphical Interface

  I'm using MS Report Designer 2005. When I create a parameter using the checkbox in the graphical design mode's filter pane, Report Designer automatically sets the constrained flag, eg: STRTOMEMBER(@ToWorkItemSystemId, CONSTRAINED ) How do I remove this I can't do it in the generated text query because the program only let you edit mdx queries graphically or textually EXCLUSIVELY Once you switch to MDX mode, you cannot go back to Designer mode. Or, rather, if you do, your manual changes will be nuked because the designer doesn't support reverse-engineering manual changes. I am curious though, why would you want to remove the CONSTRAINED flag ...Show All

• Visual Studio Team System Build script

  Hi! I have VSTS4DBPRO project (and bunch of other projects - SSIS, SSAS, C# - in my solution). And i need to create sql script wich should create database using my custom installation tool and supplied (by user of that tool) database server name, database name, physical layout (database files names and paths) options (assume that database has finite filegroups). Any workarounds how I must build my solution to achive desired result How could I get this by VSTS4DBPRO Seems that it coukld be a right decision, BUT there is no dbproj at deployment (installation) time, so there is no possibility to rebuild project with database name supplied by end-user. I'm sure I do not want to supply whole databa ...Show All

• Visual Studio Sandcastle: Is it possible to get rid of fully qualified type names?

  When I generate html pages using the vs2005 styles, I've noticed that it seems that all links to types are named with a fully qualified name. It's one thing that the text talks about, say System.Random instead of just Random, but some of my types have 4 or even 6-part namespaces, and that's really destroying readability. Is there a switch where I can change this behavior, so that links will only display the type name, and no namespace information Interestingly, when methods are displayed, they are displayed using just the type name and no namespace, but here, the method name would have sufficed (created better readability). Since no answered has yet been posted, it seems that I should maybe elaborate a bit: This problem occu ...Show All

• Visual Studio Team System WebTest showing no errors, but results missing DB changes

  I've just been introduced to the WebTest features of VS2005 to crack a problem we've been having with its use on our company's ecommerce store. It seems that recording a complete purchase life-cycle, from entry page to check-out summary, everything appears all green when I re-play the recording. But when I check the database, only the recording session actually gets recorded in the database. None of the play-backs actually result in an insert of data into our database. Reading through the technotes I have found so far, I see a lot of suggestions for when you get errors on the play-back, referring to client-side JavaScript redirects, dynamic data and various things like that. But in this case, the pages coming back are different than ...Show All

• SQL Server SQL Query

  Hi, Does anybody of you unterstand the following SQL Command SELECT Configurations.AlarmId, Configurations.Mode, Configurations.Activated, Configurations.Empty, Configurations.UserName, Configurations.datetime, (SELECT * FROM ConfigurationsTanques WHERE ConfigurationsTanques.ConfigurationId = Configurations.ConfigurationId) FROM Configurations INNER JOIN Controllers ON Configurations.ConfigurationId = Controllers.ActiveConfig INNER JOIN Tanques ON Controllers.ControllerId = Tanques.ControllerId WHERE (Tanques.TanqueId = 1) If yes, how would you explain it to the sql server Thanks for your help! OK... Another question: ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Direction vector from a matrix or quaternion

  Hi all, A have a matrix and I need to specify a direction vector from it... How can I do Thanks Aurelien So, let be a position vector (10, 20, 30) and a quaternion Q (0.33, 0.33, 0.33, 2) In witch order have I to build the final matrix I mean should I convert the original position in my coords system, and convert the original quaternion, and build the final matrix Or build the original matrix and convert it to get the final matrix Can you show me the code to build this final matrix from the original position and oriantation Thanks very very much :) ...Show All

• Visual Studio Team System Team Project Creation failed...

  Hi, I am using 180 day trial version of Visual Studio Team Suite. When I try to create a new team project, it is throwing the following error. Error: TF30170: The plugin Microsoft.ProjectCreationWizard.WorkItemTracking failed during task WITs from group WorkItemTracking, Explanation: Plugin error text: "Input string was not in a correct format." Can any one please help me what could be the reason Thanks in advance. I checked the same and there is nothing wrong with the text that is inserted. The same template was working fine earlier. But one of the admin guy installed active perl on the TFS server, then it started giving problems and I was not sure whether that caused this issue. ...Show All

• Visual C# scrollbar in panel

  hi, I want to put a linklabel over a panel. linklabel text keep growing and eventually I need to scroll to see it, is there a way to add scrollbar to panel For somereason there isn't scrollbar property available in my panel. I am using .Net 2005. My panel is inside a tablecontrol spanning 3 raws. Is that a problem Sameep I figured it out. Basically with dock property set the scrollbar don't work. So For label set the dock property to none. and for panel set the autoscroll property to true would fix the problem ...Show All

• Visual Studio 2008 (Pre-release) Problem with NTLM on IIS

  Hi everyone! I began to investigate different security option of the WCF and found this problem: WCF is hosting on IIS. So I have no problems while there was Anonymous access. Then I restrict access only with integrated Windows security and since this i wasn't able to make my service work. So first time it responded with such error: The HTTP request is unauthorized with client authentication scheme 'Anonymous'. The authentication header received from the server was 'Negotiate,NTLM'. The problem seems to be clear: In Service and Client config's i set clientcredentialtype to Windows, then IIS responded generally the same error: The HTTP request is unauthorized with client authentication scheme 'Negotiate'. The authentication header receive ...Show All