ProblemQueen's Q&A profile

• SQL Server Sizing a Reporting Services Installation

  I am converting an old Crystal Reports environment to 2005 Reporting Services. I've seen the basic memory requirements for the SSRS programs themselves, but I was wondering if there are any other guides available that will help me size the H/W based on anticipated users and reports. Thanks! BI, Here's a link that I reference when I started my report service little over 6 mos. ago. It has help me a lot. http://msdn2.microsoft.com/en-us/library/aa179363(SQL.80).aspx Ham ...Show All

• Visual FoxPro CursorAdapters and UDF in FoxPro 9

  Hi, I like to know if is possible to create a Cursoradapter (ADO) with a select CMD using a function. For example if I have a function concat(par1,par2) that returns par1+par2. I like to use as select command something like select concat(lastname,firstname) as name from personal Thanks Ivan It all depends on the provider. If function is a VFP function (either built-in or UDF, SP etc) then VFPOLEDB provider would understand it. Otherwise another provider wouldn't know what that concat() is. IOW if you're using say SQL server provider then you should pass anything in MSSQL's language (T-SQL). ...Show All

• Software Development for Windows Vista WWF 2.2 Hanging on simple app

  Attempting to run the simplest helloworld-like application using a sequential wf. Basically just following the MSDN Docs, and when running the app, it never gets to the breakpoint. It hangs, causing the processor to peg at 100% for the HelloworldWorkflow.exe app. My app is as simple as it can get. using System; using System.ComponentModel; using System.ComponentModel.Design; using System.Collections; using System.Drawing; using System.Workflow.ComponentModel.Compiler; using System.Workflow.ComponentModel.Serialization; using System.Workflow.ComponentModel; using System.Workflow.ComponentModel.Design; using System.Workflow.Runtime; using System.Workflow.Activities; using System.Workflow.Activities.Rules; namespace HelloWorldWorkflow { pu ...Show All

• SQL Server SSIS Excel source read problem

  I have a problem with reading data from an Excel file in SSIS. I'm trying to read a column that mostly consists of decimal values, but there are couple places where column entry is 2 numbers separated by a slash (e.g. "100/6.0"). SSIS tries to be smart and identifies the column data type as decimal and when it reads the cell with the slash in it, it reads as NULL. I tried to make my excel source reader component to read that cell as a string, but it gives me an error. If anybody has come across something like this, I would highly appreciate some help -Erlan It seems like adding IMEX = 1 to the Excel connection string's extended properties solves this problem. For more information read http:// ...Show All

• Visual Studio Team System TFS Project & Report Server ERrors

  When I create a new TFS Project, the Reporting Services component that retrieves "Remaining Work" and "Bug RAtes", etc errors with a message The path of the item "//Sites/MyTracker/Remaining Work" is not valid. The path must be less than 260 characters long and must start with slash. Other restrictions apply. (rsInvalidItemPath) The path of the item "//Sites/MyTracker/Bug Rates" is not valid. The path must be less than 260 characters long and must start with slash. Other restrictions apply. (rsInvalidItemPath) What can I do to fix this Hi Randy, The steps below are to verify that the base URL to the reporting server is correct in TFS. - Log ...Show All

• SQL Server Email subscriptions: changing "from" address for different subscriptions on same server

  I doubt this is possible, but can someone think of a way to change the email address used for sending report subscriptions based on the report or subscription It's a need that I've heard from a number of different clients. Scenario: a company has one reporting services server with reports running from numerous departments. Report subscriptions are sent to internal and external email addresses and there's a business need to use different "from" addresses based on the report (or audience). Unfortunately this isn't really possible without doing some messing around. You can make a call to the RS WMI provider to change the SenderEmailAddress value, but you would have to synchronize the code making ...Show All

• Visual C++ mangled name

  Is there any API to retrieve the address of a method (private/public) using the mangled name. the method is supposed to be a class member. we can know the mangled name from the .map file in VC++ 6.0 Please also suggest a method of using this in GCC. Holger Grund wrote: That explains some of it. However, undname returns the unmangled name. And that will be somthing like "public: void __thiscall ...". Certainly not a valid export name. I'm aware of that. For some reason got tangled up in two different scenarios, one where he wanted to get the address of a function he already had the header for (forgetting the fact that it was private), and a second where the name was mangled, and he wanted to k ...Show All

• SQL Server using sqlcmd to create sql script

  In SSMS, we can use the generate SQL Server Script wizard to generate "Create" and "Drop" statement for all the datatables in a database. How can I use sqlcmd or any other command line tool to achieve the same task Thanks. As far as I know you can not do this through sqlcmd or osql. SSMS uses SMO COM API to script object definition which is quite complicated. One thing you may do is to write an extended stored proc to call SMO to generate script, then call your extended sp in sqlcmd session. Not sure if anyone has any alternatives, please share if you have. I'm moving this thread to SMO alias. Thanks, Zhiqiang Feng ...Show All

• Windows Forms Multithreading Function Call With Invoke Does Not Work

  Please help! I have a Windows Form named EDI835Main that starts a long running process (defined in EDI835.cs) on a different thread by calling MethodInvoker. That works fine. Name of method is EDI835.ReadDetail(). Within EDI835.cs I have defined a event to show progress. EDI835, the form is registered to capture this event. This works fine too. In Main Form: edi835.ProgressEvent += new EDIX12.EDI835.ProgressIndicatorHandler(edi835_ProgressEvent); In the main form, If the progress is shown directly (without using Invoke) it works fine. (see code below) protected void edi835_ProgressEvent( int currentRow, int totalRows, string msg) {progBar.Minimum = 0; progBar.Maximum = totalRows; progBar.Value = currentRow;} M ...Show All

• SQL Server LDAP vs ADSI parameter problem Part III

  Dear friends, In LDAP query inside SQL Server, How can I return more than 1000 rows It's a limitation in this type of queries... Someone know to return more than 1000 rows Thanks! ...Show All

• Windows Forms Need webBrowser to execute while app waits??

  I have an app that waits for an event (enter captcha text) upon submitting ,it goes to another page (user agreement) where i need to sendKeys yet to another submit button... my problem is the final line of code is executing before the next page loads ... I tried Thread.Sleep, but it siezes the whole app! webBrowser included.. I have no clue what to do... any ideas private void button2_Click( object sender, EventArgs e) { HtmlDocument doc = this .webBrowser1.Document; doc.GetElementById( "verificationWord" ).Focus(); SendKeys .Send(CAPTCHA.Text); SendKeys .Flush(); doc.GetElementById( "finishForm" ).Focus(); SendKeys .Send( "{ENTER}" ); SendKeys .Flush(); ...Show All

• Visual Studio Express Editions Simple program to test RS232

  Hi Guys! I'm really new on this... I heard about visual basic but to be honest this is my first time in programming. Well I decided to download and install Microsoft Visual Basic 2005 Express Edition and I have some questions: This version of VB is free to use (visual basic 2005 express edition), can I create alot programs Other question, is a good program for beginners Last question: I download and installed Visual Basic 2005 Express Edition to learn about programming and to create a simple program to test RS232 with my printer controller...I want to know if it is possible to do this with visual basic 2005 express edition. This is what I'm planning to do... I'm looking for a simple program to test RS232 with my printer controllers. He i ...Show All

• Visual Studio Express Editions Media Player

  Hi all, I got this code for media player and it comes with a playlist but it only plays MP3's only. I would like to add many other media formats to it (like mpeg, wav, & All Files) what changes in the code do i have to make And would it be best to add a Open file dialog instead of a folder browser dialog (Code for media player only plays MP3's) Imports System.IO Public Class Form1 Private filesArray As ArrayList Private Playlist As WMPLib.IWMPPlaylist = Nothing Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim sasa As String filesArray = New ArrayList Playlist = AxWindowsMediaPlayer1.newPlaylist( & ...Show All

• Visual Studio Express Editions Visual Studio 2003 C++ Compile Problem

  I am a student just starting to learn C++, I do have a few years experience in Java and I've run into a problem with Visual Studio 2003 that I downloaded from MSDN Academic Alliance. I've installed Visual Studio 2003 on my home computer and it seems to work fine. I can start and open projects, enter code in, etc. The problem lies in that there is no Compile option available where my professor says there should be, another problem is that when I build my project, it tells me that it finished building without any errors, even though I inserted code purposely full of errors to see if it would catch it. Also when I tell it to build, no .exe files are created, nothing is done except a buildlog.html file that tells me my project is "up-t ...Show All

• SQL Server Service Broker SQL 2005

  Hi, Wat is Service broker wat is the use of service broker How to use it with SQL 2005 Thanks & Regards, Mani Basically Service Broker provides communication infrastructure for building distributed applications. Some good reads: - The BOL introduction to the Broker: http://msdn2.microsoft.com/en-us/library/ms166104.aspx - Rushi's blog: http://rushi.desai.name/Blog/tabid/54/Default.aspx (the older articles cover 'what is Service Broker') - My blog: http://blogs.msdn.com/remusrusanu/ - Roger's blog: http://blogs.msdn.com/rogerwolterblog/ HTH, ~ Remus ...Show All