Tvercel's Q&A profile

• SQL Server Persistant variables

  Greetings SSIS friends. Is it possible to create a persistant variable in an SSIS package dreameR.78 wrote: Greetings SSIS friends. Is it possible to create a persistant variable in an SSIS package Meaning what, exactly ...Show All

• Software Development for Windows Vista backward compatability of xls files created by office2007

  Hi, I have created a xls file in Office 2007 but couldn't open the same in office2003 , i have also tried in reverse way also it is not working. Can any one please give me information on making it compatible. Thanks in advance for your suggestions. to be able to save, into a legacy verion of office (2003,xp,2000,97...) you have to go to save as...look at the right hand side of the box and it will say something to the effect of "save word document in legacy format" ...Show All

• SQL Server Three daily schedules for a single report

  Hi, I have been trying to figure this out for a while. I have a report that should run at 9AM, 12 Noon and 2PM every weekday. Due to the complexity of the report, I'm using snapshots. Since the lowest gap is 2 hours, I currently have it configured to create the snapshot every two hours. Since this is running all day, my servers are taking a lot of strain. In the report manager help, it suggests creating three daily schedules for the report. I cannot find a way to create more than one schedule for a report. Please let me know how I can do this. Any help will be highly appreciated. Thanks, Anand What you can do, and I have done in the past, is to go into the job that is created in your SQL Server A ...Show All

• Smart Device Development serial port multi thread issue

  I have a serial port app that works on a laptop but seems to freeze on the pocketpc. The incoming communication is a constant stream at 9600 baud and it looks like the "comport data received" function doesn't quit even though it is called using "me.invoke". So my question is, why does this work on the laptop and not on the Dell Axim x51 Here is the code: Public Class Form1 Public comport As New SerialPort() Private Sub Form1_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load Try AddHandler comport.DataReceived, AddressOf OnSerialDataReceived comport.DataBits = 8 comport.StopBits = StopBits.One ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Can anyone replicate this Generic List and Component problem I am having

  Hi, I belive this is a problem with XNA Game Studio because of the discussion I have had on the Winform thread http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=766386&SiteID=1&mode=1 [Problem with List<T> and TypeConverter] I have a GameComponent that contains a Generic list of my custom class called Background Layer. This Background Layer has a custom type converter called LayerConverter. The problem I am having is that when I edit the collection via the designer the collection property editor is wrong. The properties that I can see are under an expansion box called "Value", changing this value doesn't work it keeps reverting back. I have traced it to the fact that whatever calls the type converter calls ...Show All

• .NET Development .NET Remoting not working on different version of VS 2005 and .NET framework

  Hi , I have installed the following Microsoft Visual Studio 2005 Version 8.0.50727.42 (RTM.050727-4200) Microsoft .NET Framework Version 2.0.50727 Installed Edition: Professional Microsoft Visual Basic 2005 77626-009-0000007-41566 Microsoft Visual Basic 2005 Microsoft Visual C# 2005 77626-009-0000007-41566 Microsoft Visual C# 2005 Microsoft Visual C++ 2005 77626-009-0000007-41566 Microsoft Visual C++ 2005 Microsoft Visual J# 2005 77626-009-0000007-41566 Microsoft Visual J# 2005 Microsoft Visual Web Developer 2005 77626-009-0000007-41566 Microsoft Visual Web Developer 2005 Crystal Reports AAC60-G0CSA4B-V7000AY Crystal Reports for Visual Studio 2005 ...Show All

• .NET Development xml validation

  hi, i have to validate xml document in different scenarios. 1) when xml document changes into message 2) when message changes into xml document 3) when xml document loads into database 4) when xml document comes from database i learnt there are two options 1)validating it at the time of loading into the object 2) after loading of xml into object in this link http://msdn2.microsoft.com/en-us/library/ms998559.aspx using xmltextreader to validate xml document is better than using xmlvalidation reader mentioned. how it is possible One link that is very related to your problem: http://msdn2.microsoft.com/en-us/library/system.xml.schema.xmlschemaval ...Show All

• Visual Studio 2008 (Pre-release) Explicitly requesting security tokens from a STS

  Hello. I’m trying to write some code to explicitly request a SAML security token from a STS. I’ve tried unsuccessfully the following 3 approaches: Approach #1 1. Create and set a IssuedSecurityTokenParameters object 2. Create a SecurityTokenRequirement from the IssueSecurityTokenParameters 3. Create and set a ClientCredentials object 4. Get a token manager from the ClientCredentials 5. Get a token provider from the token manager, using the SecurityTokenRequirement as parameter · Problem: there doesn’t seems to be a public way to convert from a IssueSecurityTokenParameters to a SecurityTokenRequirement Approach #2 1. C ...Show All

• Visual C++ How to use C# DLL in VC++.NET's Win32 Console Application?

  Hi, I wrote a function in AsmL.NET and then generated C# code and then compiled it to a DLL. Now I want use the DLL in VC++.NET's project type "Win32 Console Application". The DLL works in VC++.NET's project type "Console Application (.NET)", But does not work in project type "Win32 Console Application", Can any one help please Many thanks for the reply! I set the /clr option and also made Use Managed Extention Property to 'Yes'. After that, Using 'Add Reference', I added the DLL and from the object viewer window, I was able to see the Namespace, Class, and Methods in the DLL. But, When I tryed to call the method from the Code, I got error. In the DLL (func.dll), ther ...Show All

• SQL Server Deploying multiple projects

  Is it possible to deploy multiple Analysis Services projects into one OLAP database, or you have to create all cubes into same project Thanks from answers! Peter Hello. The problem is that you will overwrite the existing cubes and other objects with the latest project that you deploy to an existing database. I think the answere is no. Regards Thomas Ivarsson ...Show All

• .NET Development FTP Client problem (Passive mode error)

  here's my code (from MSDN Library but i changed thr uri and the FTP account information i got this error "The remote server returned an error: 227 Entering Passive Mode (207,150,179,70,73,197) ." using System; using System.Net; using System.Threading; using System.IO; namespace Examples.System.Net { public class tryFTP { private ManualResetEvent wait; private FtpWebRequest request; private string fileName; private Exception operationException = null ; string status; public tryFTP() { wait = new ManualResetEvent ( false ); } public ManualResetEvent OperationComplete { get { return wait; } } public FtpWebRequest R ...Show All

• SQL Server Problems using RSClientPrint

  We are using VB.NET 2005 to develop a WinForms application that uses SQL Server 2005 Reporting Services to produce reports. We want to print a large report programmatically without preview. RSClientPrint looked like a good solution but it produces an error when we try to use it. Details... I added Interop.RSClientPrintLib.dll Version 1.0.0.0 to my application and used the code sample I found at: http: / / msdn2. microsoft. com/ en- us/ library/ ms159195. aspx The call to print looks like: RSClientPrint.Print(" http: / / ourServer/ reportserver ", strReportPathParameters, "Report_name") This call generates an error message: "An error occured during printing. (0x80004002)" and throws an exceptio ...Show All

• .NET Development Why is Console in the backgroud?

  When I create an empty project with Express Visual C++ and make a windows form on the fly, I get the console in the background with the title C:\Windows\System32\cmd.exe. Why is that This feature did not exist in 2003 VC++.Net. Is it a part of Express Edition of VC++.Net What can I do not to display the console in the background Regards Modeller. As a matter of fact, I have 8 projects in the same solution and all of them are displaying Console in the background. Just to make sure that I was doing right, I created a new solution and started a new empty project with CLR->Emptyproject. It also gave a console in the background. I have been using VC++ since 2003 this is the first time that I have e ...Show All

• Visual Studio 2008 (Pre-release) Text Areas

  hi is there a component in wpf, that can accept several lines of code such as the text area in HTML thx thx anyways i managed to find out private string GetText(RichTextBox richTextBox) { // use a TextRange to fish out the Text from the Document TextRange textRange = new TextRange(richTextBox.Document.ContentStart, richTextBox.Document.ContentEnd); return textRange.Text; } = new TextRange(richTextBox.Document.ContentStart, richTextBox.Document.ContentEnd); return textRange.Text; } http://blogs.msdn.com/jfoscoding/archive/2006/01/14/512825.aspx incase it is of help to you ...Show All

• SQL Server SQL2000 JOB calling SQL2005 JOB - Best Practice?

  Hi, We have two systems, one working on SQL2000 and other working on SQL2005. In SQL2000, there is JOB which needs to execute a JOB in SQL2005, get feedback based (success or failure) and proceed accordingly. I am not sure the best practice to call SQL2005 job from SQL2000 job. Both the server's run undersame domain account. please help, thanks atul You can call a stored procedure: http://www.microsoft.com/technet/prodtechnol/sql/2005/newsqlagent.mspx ...Show All