cwlaualex's Q&A profile

• Visual Studio How to open Source Control (VSS) solution from command line in VS2003 / VS2005?

  Hi, I'm trying to open and run a VS2003 solution file that is in Source Control (VSS). Is there a way to do that using command line I appreciate for any help. Thanks! If I first do a GET of all the needed files from VSS for building C:\foo.vdproj.  Then in the command prompt, when I type 'devenv /build Release /project "C:\foo.vdproj" "C:\foo.sln"', everything builds fine. How can I do the task like below in the command prompt without first getting all the needed files from VSS    example: Opening a solution in the GUI and it will prompt you with a message - "Projects have recently been added to this solution. Do you want to get them from source control ".  Whe ...Show All

• SQL Server rsCredentialsNotSpecified

  Hello guys, I have a report using a drilldown to expand/collapse some information: Region + SE State On preview mode, the report works right, appearing this: Region - SE State SP Campinas When I call this report from a asp.net page, the report works fine, but when I expand this drilldown, the report shows an error: One or more datasource credentials required to run the report have not been specified. (rsCredentialsNotSpecified). I use a shared dataSet using prompt Credentials as its credentials. Pedro ...Show All

• SQL Server Legacy DTS packages

  How can I scheudule a legacy DTS 2000 package if it stored in SQL Server itself I assume the package 'lives' in the msdb database. For what bizarre reason is there no option to schedule legacy packages anyway, why provide the DTS legacy/designer components if the ability to schedule them isn't possible Is this microsoft's subtle way of telling me that I should convert them to SSIS packages ...I just don't have the time to do that...help Thanks You can run your old dts packages using dtsrun as you did earlier. If you upgraded your server, your old jobs which were running your dts packages will continue to run. This is because the dts runtime environment continues to work. You can also ...Show All

• Visual C# Best processors for compiling Multi-Project solutions

  All, I'm working on a Visual Studio 2005 solution that comprises more than 20 projects. It feels like the project is growing faster than the IDE and my computer (P4, 3.4) can cope. It's all a bit slugish, and building and running is taking longer than i would like. My question is whether the compiler's build system would make use of a multi-core processor, especially in a multi-project solution In addition, would a quad core help the building better than a dual core Thanks Pete You want the best mathematical throughput I believe. Check out Tomshardware for speed comparisons... by the way, we split the solution here so that the projects we don't need to be developing with are running off binary reference ...Show All

• Audio and Video Development Basic video encoding help

  i'm going to be doing my first video encoding so forgive the stupid questions... i've noticed that often i'll watch some site's wmv formatted videos that seem to have to wait until the entire file is downloaded before it starts playing and others that start immediately... is this due to a difference in how the file was encoded Try posting your question here: http://www.microsoft.com/windows/windowsmedia/community/newsgroups/WindowsMedia/default.mspx dg=microsoft.public.windowsmedia.encoder&lang=en&cr=US Off the top of my head, though, I would guess that this has more to do with the distribution mechanism for the content -- whether its is being streamed or downloaded, for instance. But try your ...Show All

• SQL Server ADO Recordset from SQL Task issue

  Dear Folks, I have a Foreach Loop that enumerates a set of files from an ADO recordset variable which is populated by a preceding SQL task. The query from the task that populates the recordset returns about 200 rows with one varchar field(a file path). The loop is long running, and so far it errors on the connection string populated by the enumeration variable after about an hour. The timeout for the SQL task is set to zero. Could it be the source recordset variable timing out, or could it be that the recordset is too large Thanks, Chris This is odd. there certainly could be a bug somewhere in the recordset object itself (in the interest of full disclosure, I wrote the code for the ADO Recordset object back in '96 :) ) If you d ...Show All

• SQL Server NAN and Infinity Total ....SPORATICALLY

  Hello! Is there a way to explain WHY I am only getting this sporatically throughout the report Also what can be done at the report level to fix this. Like putting a code over the whole report. I have already tried the Val,Cdbl,and Int functions infront of the expression.....HELP!! Sum(Val(FormatPercent((Fields!ID30_DaysCNT.Value/Fields!TOTAL_UPB_CNT.Value),0))) Is the formula I am using....I believe you were helping me with this issue earlier :) ...Show All

• Windows Forms Print Preview problem(Bug)

  Hey, I have this code in the PrintDocument control under the PrintPage event: private void printDocument_PrintPage( object sender, PrintPageEventArgs e) { RtextboxUC thisrichtextbox = GetCurrentTextBox(); //Start printing text and store last letter... checkPrint = thisrichtextbox.Print(checkPrint, thisrichtextbox.TextBox.TextLength, e); //Check if there should be more pages if (checkPrint < thisrichtextbox.TextBox.TextLength) { e.HasMorePages = true ; } else { e.HasMorePages = false ; } } There are no errors, but when I test it on my program and click print preview...when it opens the PrintPreview dialog It shows the dialog that is telling you how many pages it is det ...Show All

• SQL Server Flat File, Fixed Width import with Nulls always fails

  More SSIS woes. DTS was so much easier. I have a flat file. It's fixed-with with CRLF record delimiters (a.k.a. Ragged Right format). Some fields are null, and represented by the text NULL . I'm trying to import the file into SQL via an OLE DB connection. The target table is a SQL 2000 data table. Two of the fields in the target database are of type smallint. When I run PREVIEW on the data source (Flat File), everything looks good & correct. I added the convert columns task to convert my strings to smallint. This is where things go haywire. After linking everything up, the conversion gives me a "Cannot convert because of a possible loss of data." All of my numbers are < 50, so I know this isn't the case. Ano ...Show All

• Visual Studio 2008 (Pre-release) problem with .config file for XBAP on Server 2003

  i've got an XBAP app using a .config file, and it keeps failing because : + Downloading ....exe.config did not succeed. + The remote server returned an error: (403) Forbidden. another XBAP app (without .config) is on the same Server 2003 and is working fine. and the same app deploys fine on XP ... the problem seems to be specific to the .config file on Server 2003. i tried adding the .* Mime type, but that didn't work. should i be using the Publish wizard and have it append .deploy to all the files i'd actually rather not do this, and just do a standard XCopy to deploy. Thanks, casey ...Show All

• Visual Basic How do I make a variable available to another form?

  How do I make a variable available to another form I am trying to use a variable from one user control on another. Can anyone help declare the variable global (in a module) you can access it every where. or else you can make the variable in the form as public and access it in another form as <form name>.<variable name> or else creating property you can access all the variable in the form. ...Show All

• Gadgets Dashboard Reports as Vista Gadget

  Hi we are trying to develop gadget for Vista side bar which will display the dashboard reports. Any idea on how this can be developed any links will be very useful. Thanks Srikanth try the SideBar forum: http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=1063&SiteID=1 and also the SQL Reporting Services forum: http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=82&SiteID=1 ...Show All

• SQL Server Matrix - How to calculate % of row?

  Hi, I wish to create a matrix with multiple rows in the main data cell and a subtotal at the end of the row. The first row in my matrix main cell is just a count of records, whereas the 2nd row is a % of the value in the 1st row compared to the total of that row. I have 5 columns in the matrix as below (ignore rounding issues): Status A B C D E Total 01/01/2007 Number 9 32 3 13 0 57 % of Total 15% 56% 5% 24% 0.00% 100.00% Can someone advise the best way to calculate the % cells in this example Thanks If ur using the concept of SSAS i.e. if ur datasource is an analysis services data base then i can help ...Show All

• Visual Basic Unload VB.Net ComClass from VB6??

  Anyone know how to unload a vb.net dll that is created in a vb6 exe I am able to create a new instance of the dll and it runs without error... The problem is that I can't seem to figure out how to unload it. I've tried something like "set myVBNETDll = nothing" in the vb6 code, but it doesn't kickoff the finalize() in the vb.net dll. Suggestions Thanks. Thanks Mattias, here is some more detail on what I am trying to accomplish. I'd like to create the .net dll, do some work, unload it, and get an event back from it when it unloads. The VB6 app is a "menu" type application, in that it loads several dlls, does some work, and then unloads the dlls one at a time. Ex:VB6 Exe: ...Show All

• SQL Server SSIS way to "upsert" ?

  I have a requirement that seems like it would be a very common requirement in many ETL scenarions: It has been called "upsert". From wikipedia: The SQL -like UPSERT statement inserts a record to a table in a database if the record does not exist; if the record already exists, an update operation is performed. This is not a standard SQL statement, but it is frequently used to abbreviate the equivalent pseudo-code. The term upsert is a portmanteau of update and insert and is common slang among database hackers. The SQL:2003 defines a MERGE statement that provides similar functionality. Example IF FOUND THEN UPDATE ELSE INSERT; See also merge (SQL) Other ETL tools I am aware of supp ...Show All