BarrySumpter's Q&A profile

• Visual Basic Refactor! 2.0.4 installation fails on Windows Vista RC1 with Internal Error 2739

  Hi all, I have just downloaded the latest version of the Refactor! tool from DevExpress (the free one) on a Windows Vista RC1 installation with VS 2005 Team Suite Trial edition. The installation fails with the following error message: "Internal Error 2739" The error window is titled "DXCore for Visual Studio .NET" I don't have any other versions of Refactor! installed on this OS. The error pops up before any files are copied, while the "Please wait while Windows configures DXCore for Visual Studio .NET" install is running. SA. NewWorldMan wrote: Just went to my subscriber login area for Refactor! Pro 2.0.4 on the DevExpress site and ...Show All

• SQL Server The annoying WMI configuration error

  I'm recieving the following error: The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine 'machine information' Error: 2147749896 (0x80041008). I've researched the error and found out some people were running batch scripts to reinstall wmi, but none of them worked for me. One of them I gave up on after thirty minutes and it wasn't doing anything. Please give some suggestions on how I can resolve this issue. I am having the same issue. I found this link http://sqljunkies.com/Forums/ShowPost.aspx PostID=85 I have not tried any of the suggestions yet, but there are quite a few ideas to try, so after I have tried some I will let you know how it goes. ...Show All

• SQL Server reading partitions when a dimension is being queried

  Hi, something I am not able to understand, I have a dimension which contains about half a million records and about 25 attributes, no hierarchies and all attributes are related to the key (have to change this). The dimension key is pointing to a fact table which is partitioned with one partition per day in the cube. in BI studio browser, if I drag and drop only one attribute of the dimension to the row field, and check the profiler it displays the following: MDSCHEMA_SETS: <RestrictionList xmlns="urn:schemas-microsoft-com:xml-analysis"> <CUBE_NAME>abccube</CUBE_NAME> <CUBE_SOURCE>3</CUBE_SOURCE> </RestrictionList> MDXQUERY: Drop visual totals for [abccube] MDXQUE ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Bouncing Sprites Demo

  Hi Folks, I have written a program that extends the bouncing sprite demo that is shown in the MSDN - XNA help library. The program by default will randomly position 50 sprites on the screen and move them. When the sprites collide, they will bounce off in another direction. If they hit the edge of window, they will bounce off the wall as well. The code shows the usage of the BoundingBox Interacts function. Firstly is used to randomly position the sprites on the screen without overlapping each other. Secondly its used for the collision detection of the sprites. You can adjust the number of sprites by altering just one constant value in the code. It seems to run smoothly even if you've got 100 sprites on the screen. You can downlo ...Show All

• Visual Studio Team System XML Schema definition

  I have tried to access the XML schema definiton so I can make changes to my template and I am getting a "not found" error for http://schemas.microsoft.com/VisualStudio/2005/workitemtracking/typedef What's up Kathir is correct. You can also go to this help topic and download all the process template schema files: http://msdn2.microsoft.com/en-us/library/ms194967(VS.80).aspx Thanks, Allison [MSFT] ...Show All

• SQL Server Interactive sort changes time field values to 0

  Hello all, I have a report which connects to a Pervasive database via an ODBC connection on the reporting server (RS2005). When I initially bring the report up, a time field (OdbcType.Time) shows the correct format: hh:mm:ss. When I sort any of the sortable columns on the report, the time field (which is not sortable) values all change to 0. Backing out of the report and re-running it restores the correct time values. Any ideas Thanks, Ken This issue could be related to the data type of the field. There is a fixed set of data types RS supports: string, boolean, numeric, datetime, timespan. When you sort, we have to use the data we temporarily store (so that we don't have to query the data source) to proces ...Show All

• .NET Development VS Math.Round

  Hello all, Did you know that Math.Round doesn't use the normal rounding.  The values are slightly incorrect according the the typical 'school' rounding that we learn.  When I say 'school' rounding i mean Asymmetric Arithmetic.  this is the normal rounding of 1.4 = 1, 1.5 = 2, 1.6 = 2   Math.Round uses a type of rounding called 'Bankers' rounding - check it out if you want an explination.  Anyway just use the following code to fix it: Public Shared Function aaRound( ByVal val As Double , ByVal decimals As Integer ) As Double If decimals < 0 Then Throw New ArgumentException( " Number of decimal places must be 0 or greater" , "Val" ) End If Dim ...Show All

• Visual Studio Anything special about items returned from custom tasks ?

  I am using the MS Tigris XmlRead Task to read the list of Targets in a .target file. I cannot batch over the item retrurned from the task. The behavior is the same even if I read the value returned by the task into a Property and then create an Item. I would appreciate your help. The proj file <Project DefaultTargets="list" xmlns="http://schemas.microsoft.com/developer/msbuild/2003"> <Import Project="$(MSBuildExtensionsPath)\MSBuildCommunityTasks\MSBuild.Community.Tasks.Targets"/> <Target Name="list"> <XmlRead Prefix="n" Namespace="http://schemas.microsoft.com/developer/msbuild/2003" XPath="/n:Project/n:Target/@Name" XmlFileName="$(MSBuildProjectFile)"> <!-- I could read the Value property of the ...Show All

• SQL Server Using shared dataSource while deploying a report.

  Hi, I am writing a script which will deploy a report on the report server. The dataSource used for the report is a shared one and which is already deployed on the report server. What code should be added in the rss script to specify that the report uses the shared dataSource When I searched on net I found an article : http://blogs.solidhouse.com/david.woods/CategoryView,category,SQL%20Reporting%20Services.aspx which specifies a example for using shared datasources. It tries to execute a method setReportDataSources() on a instance variable rs which should be type ReportingService (the variable is not declared). But when the script is executed a rs variable is already declared to be of type : Microsoft.SqlServer.ReportingServ ...Show All

• Visual Studio Team System Download Links for coming Updates to Documentation

  would it be possible to get download links to the current documentation (chm files) for VSTS4DBP as they are updated before RTM Both for VSTS4DBP and API's. I'm on the road quite a bit in the next week(s) and will not have online access much of the time. Since you have indicated there will be several updates before RTM I would like to have access to them offline. Thanks, Alle I wanted to give a quick update. We've got CHM files of our November update, but we're trying to figure out what hurdles we are required to jump in order to make pre-release docs available. Some folks suggested we can't release a version that doesn't have the "Pre-release" tag on all topics, there's ...Show All

• .NET Development DataSet Simple Question

  I am new and i am traing to learn ADO.NET I have seen code like this: DataSet myDS = new DataSet("dataSet") DataTable mytable = new DataTable("tablename") With this your are creating a DataSet to manage one or several tables, and you add to the dataset a table. My question is if you don't need to tell to the dataset what type a table is . I mean a table from access or foxpro or dBase Also i have seen that DataSet can Create Tables and in the code i have not seing the type of table that you want to create. How do you create i foxpro table Ricardo 8a Dataset is generic in terms of table type -- they can hold data taken from any physical format. The physical table ty ...Show All

• SQL Server How to write a query to get following result

  Hello, I have 3 tables, 1. employee (employeeId, employeeName) 2. customer (customerId, customerName) 3. Orders (employeeId, CustomerId, qty_ordered) I need to write a single query which returns list of employee - customer combination who have not worked with each other. You could try something like this: select allcombo . employeeid , allcombo . customerid from ( select employeeid , customerid from employee full outer join customer on 1 = 1 ) as allcombo Left Join Orders on allcombo . employeeid = orders . employeeid and allcombo . customerid = orders . customerid where orders . employeeid is null and orders . customerid is null The subque ...Show All

• Windows Forms programmatically associating file extension to an application in c# .net

  Hello everybody can anybody help me how to programmatically associate file extension to an application in c# .net i.e at the time of installation. thanks in advance, Ramana kumar. See Command-Line arugments of Main funtions of your application, You'll be getting some file name there that who invoked this command, When you have the file name from there you can open it yourself. Best Regards, ...Show All

• .NET Development RPC server error

  I'm creating a program that is converting word docs to text files for a sorting algorithm. I am usingthe MS.interop.word namespace and system.runtime.interopservices. Dim rtfread As New StreamReader("C:\Documents and Settings\QAInsp\Desktop\File Lists\RTF 2 TXT List.txt") Dim txtread As String Dim rtb As RichTextBox txtread = rtfread.ReadLine While txtread <> ""      word.Documents.Open(filename:= CObj (txtread)) 'opens a document The error occurs here at the word.docs.open(....) The error message reads "The RPC server is unavailable."  The call is to the local machine. There is no server calls or relationships here, just a fetch from the C:\ (hard drive).   ...Show All

• Windows Forms Preservation of contents of the form in a database

  Help! Such problem: it is necessary to keep all contained (an arrangement controls...) forms in a database. How it is better for making Can eat any framework (for CMS, for the client) for such work. Are you trying to store the properties for all of the controls of your form in a database Then I would suggest the following: Forms table that contains a unique FormID, name, etc. Controls table that contains the list of controls for all of the forms. It would have a ControlID, FormID (foreign key to Forms table), control name, etc. Properties table that contains the property values for each control. It would have a PropertyID, ControlID (foreign key to Controls table), property name and property ...Show All