Daniel Cabra's Q&A profile

• SQL Server Run report without Login

  Is there any way to run a report via a URL without having the user login Could I provide special parameters on the url or define a user/password in the report itself We do NOT use active directory. Thanks. You can store the credentials needed for the data source access on the report server. Check this BOL link: http://msdn2.microsoft.com/en-us/library/ms160330(SQL.90).aspx Also check the links at the bottom of that page which describe how to manage data source credential settings via Report Manager and Management Studio. -- Robert ...Show All

• SQL Server DTS 2000 Designer Components

  After installing the DTS 2000 designer components from the feature packI get the following error message when trying to open a package: ---------- SQL Server 2000 DTS Designer components are required to edit DTS packages. Install the special Web download, "SQL Server 2000 DTS Designer Components" to use this feature. (Microsoft.SqlServer.DtsObjectExplorerUI) --------- The thing is that I have installed them!! so what's going on here, is there a registry key I need to remove or something , I've uninstalled and re-installed them, rebooted the server numerous times but still no joy, SQL Server just tells me that they're no ...Show All

• Visual Studio Team System Querystring parameters in recorded WebTest?

  I have a multi-page webtest that creates a new company. When the registration page is submitted, it ultimately navigates to an address validation page passing the newly created companyId as a querystring parameter. It actually visits this page twice, once for mailto and once for billto addresses. The recorded webtest includes the querystring parameter (both times), apparently hard-coded to the value passed when the test was recorded. When I re-run the test, a new companyId will be generated and needs to be passed on to the address validation page. The correct value is passed for the first visit to the address validation page, but it is ...Show All

• SQL Server Deploy with assembly error

  Hello, I have a reports with assembly. While I try to deploy the report to my server I'm getting this error message: Error 10 Error while loading code module: ‘Test.Common, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null’. Details: Could not load file or assembly 'Test.Common, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified. I copy the dells using the assembly to the C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\bin folder. Thanks Idan Hi, this could be a problem with fil ...Show All

• Windows Forms data format

  Hi, I am beginner in Visual C# and I have a question;  I make a data form with wizard and I want change the data format in textbox : exemple : 0.19 I want to show 19%  the number is from access database thank you  If you uses Data binding then use Binding.Format(and Parse) events. For details see MSDN on Binding.Format. ...Show All

• Visual Studio Team System requirements management

  hi, I'm trying to determine how VS 2005 handles Requirements Management. I've read that VS provides a means for managing requirement traceability, and will produce a REquirements Traceability matrix. Has anyone used this functionality in VS 2005 I've used Requisite Pro in the past and have been very happy with it, if anyone can compare VS 2005 to Req Pro in terms of Requirements Management, that would be great! thanks, Ryan Interesting, I thought that 3rd party tool integration with VSTS would be two-fold. They would need to be integrated into the IDE and also utilize the same data store. ...Show All

• Visual C# Validation Philosophy

  I am working with a Winform in VS 2005. I have been reading some books lately that say that using the error provider and checking it when you save or exit a form is a better, (less intrusive) way of doing validation than putting up dialog boxes. I see the wisdom to it but I wonder what should happen when you have many records in a form That is, lets say I have a winform with the Standard menu and toolbar on it that VS creates automatically, but lets also say that this form (a detail form) has many rows. With regard to validation, how should it be handled Should I wait until save or exit is selected If so, telling the user that there a ...Show All

• .NET Development Error:Retrieving the COM class factory for component with CLSID {} failed due to the following error: 8007000e

  Hi, I am trying to take screenshots of any open Internet Explorer. I have writen the code and it works fine when I run the site in debug mode. Once the site is published I get the following error: Retrieving the COM class factory for component with CLSID {9BA05972-F6A8-11CF-A442-00A0C90A8F39} failed due to the following error: 8007000e. This error is shown for the following line: SHDocVw.ShellWindows shellWindows = new SHDocVw.ShellWindows(); I have given permission to various files for aspnet user. I have looked up most of the forum but to no avail. Any help would be greatly appreciated. Thanks, ...Show All

• SQL Server Fulltext Search with Sql 2005, how to highlight hits in text

  Hello This is my first post... and between christmas and New year day, so I hope someone is still reading... I'm using the thesaurus functionality  in sql server 2005. I need to highlight in a UI the hits which were found by the fulltext-search-queries. My question is : How can I retrieve the hits which the database engine found within a searched fields(exact positions, length and so on) Is there a built-in functionality to do this or do I have to implement (or try to implement...) the same code as the sql server have Many thanks & happy new year  Nello ...Show All

• SQL Server I want write a Trigger that make a 3nd table that contain all the record

  Hi I want to write Trigger tha do this: I have 2 table main table & sub main table that have data like this for example I have Bank (code 001 ) in main table and visa(code 0001 ) & mastercard(code 0002 ) in submain table. or I have BMW(code 101 ) in main table and X5(code 0001 ) & X3(code 0001 ) in sub main table. I want write a Trigger that make a 3nd table that contain all the record of that two table like this: NAME                     CODE Bank         &nb ...Show All

• Software Development for Windows Vista Active Directory connection from Win 98

  I have a .NET 2.0 winforms app that is having problems on a Windows 98 computer. The app attempts to connect to Active Directory for authentication. I try to create a new DirectoryEntry and get the following exception from this constructor: new DirectoryEntry(string path, string username, string password) ActiveDirectoryOperationException: Unknown error (0x80070078) A hotfix that once fixed this was installed on the computer from http://support.microsoft.com/default.aspx scid=kb;en-us;323455 we just reinstalled a new version of the winforms app and now get the error. Any ideas not sure why this got ...Show All

• Visual C# How to read any office document

  Hi! I'd want to know if there's any class or library to open office documents and then read them. With the conventional method, creating a StreamReader and so, sometimes strange characters are read, for example if the document contains tables or images. What I want to do is, for example, open an existing file (.doc, .xls, .pub, .ppt etc., even .pdf) , read the whole document and then count how many times appears each word. Is this possible How I found a library called iTextSharp which allows me to create documents but I'm not sure if I can read them, and if so I don't know how because there's no documentation. Thank you very much, I hope ...Show All

• SQL Server Introduce Domain functionality to UDDT

  As so rightly stated in http://www.microsoft.com/technet/prodtechnol/sql/70/books/inside6.mspx "Currently, UDDTs don't support the notion of subtyping or inheritance, nor do they allow a DEFAULT value or CHECK constraint to be declared as part of the UDDT itself. These powerful object-oriented concepts will likely make their way into future versions of SQL Server. These limitations not withstanding, UDDT functionality is a dynamic and often underused feature of SQL Server." There's no point bothering with using a UDDT in T-SQL if you can't apply constraints to the UDDT! 1 vote for the introduction of the mentioned features int ...Show All

• Visual C# Add registry values in setup project

  Hi, I’m making a setup project, and I want to add a value in the registry. It has to be the application folder where the project has been installed, but i don’t find how to do it. I can only write some fixed text, and i don’t want that. Thanks in advance. Yes you can add values to the registry using by 1. Right Click on the Poject Name in the Solution Explorer. 2. Click View 3. Click Registry Here you can add New Key in any of the folders. ...Show All

• Visual C++ Repedative Syntax error : missing '=' and ')' and ';'

  I wrote this section of code here today and everything went bad and i dont have a flipin clue why! More than likely i am simply missing a very minuet error probably from staring at the same lines of code for the past 7 hours. these are the error messages i get ONLY in the section that i just wrote: in_camera.cpp(453) : error C2143: syntax error : missing ';' before ')' in_camera.cpp(454) : error C2143: syntax error : missing ';' before '{' in_camera.cpp(454) : error C2059: syntax error : '=' in_camera.cpp(454) : error C2143: syntax error : missing ')' before ';' in_camera.cpp(454) : error C2143: syntax error : missing ...Show All