kangalert's Q&A profile

• SQL Server Custom Rendering Extension for HTML Fields

  I am using RS 2005, a "comments" field in a database contains HTML content.  When rendering the field on the report it displays raw HTML. Does anybody knows about a custom rendering extension that will render HTML content Thanks Fernando Has anyone resolved this   I am facing a similar issue.  My website has form that takes comments via FreeTextBox.  It is probably similar to what is used on this FORUM!  The FreeTextBox control returns text with HTML tags throughout.  I need to display the same data via Reporting Services.  Currently using SQL Server 2000 ...Show All

• Windows Forms Click once - When running install only getting .application xml in IE

  Hello, After I publish my application to a web site and then I try to install it using the publish.htm page all I get is the applicationname.application xml displayed in the browser. Is this a problem with my internet host or am I missing something simple I tried a 1 form project to make sure it was not anything to do with my current project and got the same results. Thanks for your help! JR You need to add some custom mime types for clickonce to work... .application      application/x-ms-application .deploy        &n ...Show All

• Microsoft ISV Community Center Forums [URGENT] Need Help for "Error 1004: SaveAs Failed"

  I run my VBA macro in a excel file which shown the message "Error 1004: SaveAs Failed". Then I have found that the possible reason(s) for occuring this error: 1. The command "Application.DisplayAlerts = False" failed to run 2. The command "ActiveWorkbook.SaveAs Filename:=sOFnp, FileFormat:=xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, CreateBackup:=False" can run but it's still show the error message (when sOFnp is the completed path) I need uregnt help to debug, please reply if everybody knows. I'm waiting yours, Thank you very much. Office Version: MS Office 2000 File Path: Y:\MY_DOC\ED\YICK0002-2 ...Show All

• SQL Server Lookup and OLEDB Command components programming

  I need some help on SSIS programming. Can anybody give me a short example or tutorial how to write a code, which will show me use of "Lookup" and "OLEDB Command" components Here's an example of using a Lookup (amongst other things): http://www.sqlis.com/default.aspx 311 The SCD Wizard produces a data-flow with an OLE DB Command in it so you could look at that! -Jamie ...Show All

• .NET Development button click

  I am trying to get a button to automatically click at regular intervals. Can anyone help Hi, Yep, button1.PerformClick() is indeed the right method that you should call if you want to simply emulate clicking. But, Call Button1_Click(sender, e)  method is also useful. Specially if you want to know on who's clicking the button. Either the Timer or its a user that generated the call to the Button_Click function... OR you could directly Handle the Timer.Tick Event in your button handler... Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Cl ...Show All

• Visual Studio Tools for Office Adding Smart Tag interferes with ActionsPane layout

  Hi, I am experiencing the following weird behavior. I create a user control that has nothing but a button right in the middle of it. The button is anchored LEFT + TOP + RIGHT, so as the user control's width changes, so does the buttons. I then add the user control to the ActionsPane. The following is a picture of how the ActionsPane so far http://pic.atpic.com/154853/0/jtfgimzxcdylugbmebyq Clicking on the button adds a Smart Tag to the document. The code for adding the Smart Tag works and throws no exceptions. It's a Smart Tag for dates, the dates are successfully recognized in the document and all the custom actions appear ...Show All

• Visual Studio Excute a task once per solution.

  If I have a solution with multiple projects in it, and I call (from the command line): MSBuild xxx.sln I know that it will start building each of projects in the solution. My question is: is there a way to make a task run only once, say with the first project keep in mind that I do not know which is the first one, meaning it has to dynamic. Hi, Is this a custom task or a task which shipps with MSBuild Thanks Jay ...Show All

• SQL Server using package variables as parameters in Execute Sql Task

  Hi, I need to run an SQL command, in which one of the fields is based on the current time, represented as a string in a specific format. I used a script task to create the string from the current time, and store it in a package variable named "newDate". Later, in the execute sql task, I have the following update statement: "update table_1 set field_1 = " (OLE DB connection is used) and in the parameters mapping I set parameter 0 to the string package variable "newDate". The problem is that on runtime, the sql executes with the default value of the variable - i.e. it doesn't take the new value. I c ...Show All

• Visual Studio Visual SourceSafe & Access 2003

  I am using VSS6.0 for my Access database. I downloaded the Access 2003 Plug-in for Visual SourceSafe and created my VSS project. I created the working folder. Every thing looked good; that I checked out a module modified it and checked it back. All of my objects have the lock icon indicating that they are in VSS Project. e.t.c.. My problem is when I closed my Access database and re-open it, I looses the connection to VSS Project. All the objects in my Access database do not have the lock icons. I can modify them without checking them out. To re-connect to VSS Project, I had to go to Tools menu and select the "Create Data ...Show All

• SQL Server Does not have permission to register endpoint

  I came across with the problem that I cannot create an endpoint on Windows Server 2003 (SP1). It's said: Msg 7850, Level 16, State 1, Line 2 The user 'yyyyy\xxxx' does not have permission to register endpoint 'zzzzzz' on the specified URL. Please ensure the URL refers to a namespace that is reserved for listening by SQL. Msg 7807, Level 16, State 1, Line 2 An error ('0x80070005') occurred while attempting to register the endpoint 'SecurityServices'. My code looks loke this: IF EXISTS ( SELECT name from sys.http_endpoints WHERE name = 'zzzzzz' ) DROP ENDPOINT zzzzzz GO CREATE ENDPOINT zzzzzz STATE = START ...Show All

• Visual Studio Express Editions "Microsoft SQL Server" choice missing in Data Source Configuration Wizard

  I'm a newbie trying to learn VB using VB Express Edition, so I bought the ADO.NET 2.0 Step-by-Step book from Microsoft Press and installed the sample databases, etc. The very first lesson involves using the Data Source Configuration Wizard. In the "Choose Data Source" form, the book shows five possible selections. My system only shows "Microsoft Access Database File" and "Microsoft SQL Database File". I need "Microsoft SQL Server", which is not in the list on my system. I've verified that I have .NET Framework 1.1 and 2.0 installed. I also downloaded and installed the Microsoft SQL Server Native ...Show All

• Smart Device Development ngen on CF

  can we use ngen by any way in CF APPs Hi, No NGEN is not supported for the CF. The reason for this is size. The JIT Compiler produces native code that is larger than the managed code. Having both on your device would take up too much space. Regards, Vikram ...Show All

• Visual C# Using Delegates

  Hi How can I execute a delegate asynchronously by passing a parameter into it It could be of great help if I get a detailed coding. Thanks, I believe this gives you what you are looking for: http://msdn.microsoft.com/library/default.asp url=/library/en-us/cpguide/html/cpovrasynchronousprogrammingoverview.asp ...Show All

• Visual Studio Team System Custom Reports using DataSet Extension Problem...

  We are deploying a custom DataSet extension for Reporting Services.   Our assemblies use the VSTS extensibility API’s.   When running the code on development we are able to connect to a VSTS server and pull data without any problem. When running the code on the Reporting Services server we get the following message when trying to connect to VSTS:   Could not load file or assembly 'Microsoft.VisualStudio.Currituck.Proxies.DataServices, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.   I’ve found the assembly in the GAC ...Show All

• .NET Development Very slow data loading into DataTable from Oracle

  I'm a newbie to VS2005 and .NET and trying to load about 20,000 records from an Oracle table into a datatable. I've tried the design-time methods like TableAdapters and it is so slooww. I've also tried a couple of programmatic methods like OracleDataAdapters and and OracleDataReaders. The result is the same - about 10-12 seconds to load 20,000 records. That can't be right, surely As a comparison I tried the same function within a Delphi 2005 IDE using ADO.NET. It's about ten times faster to load records into a memory resident component - 1-2 seconds. So it's not my connection, and not .NET as far as I can see. So I must be missing some ...Show All