dave6901's Q&A profile

• SQL Server Urgent: Problem with the unknown member property of the dimension

  Hi, I want to specify the unknown member property as "none" , but then i get an error The 'KeyColumns' #0 has NullProcessing set to 'UnknownMember', but the dimension doesn't have UnknownMember set to 'Visible' or 'Hidden'. but the key columns has the nullprocessing property set to "automatic".. "hidden" or "visible" do not give me any error nor the result i need. Please if someone can help me solve this problem , it would be a great help. Ridhi. Hi Ridhi, Based on the MSDN paper below, I think that you need to set the KeyErrorAction (Default=ConvertToUnknown) to DiscardRecord in your processing options, since you apparently want to discard ...Show All

• SQL Server Report Viewer Horizontal Scrollbar

  Hi, Is there a report viewer property that needs to be set to enable the horizontal scroll bar. My reports are being cut off at the end of the iframe. I have several other reports that do show the horizontal scroll bar, but for some reason all my reports in the newly created project do not allow horizontal scrolling. Vertical scrolling is still available. Thanks Umer It seems that the scroll bar appears when I make the width of a subreport wide. This prevents the report from being cut off, but this also mean tat reports that arent as wide will still show a horizontal scroll bar. So heres a question, how do I specify the width of a report to increase and decrease based on the size of the report ...Show All

• Visual Studio 2008 (Pre-release) Contract first development using WCF

  Hi, I am trying to build a service contract first using the WCF. None of the suggested commands however seem to be producing anything feasible. svcutil Little.wsdl generates the client side code which isn't what i need. I have also tried svcutil /dconly Little.wsdl but this fails with the following message Microsoft (R) Service Model Metadata Tool [Microsoft (R) Windows (R) Communication Foundation, Version 3.0.4506.3] Copyright (c) Microsoft Corporation. All rights reserved. Error: Type 'echoStringElement' in namespace 'http://www.w3.org/2002/ws/databind ing/examples/6/09/' cannot be imported. Ref to element 'stringElement' in 'http: //www.w3.org/2002/ws/databinding/examples/6/09/' namespace is not supported. Eit h ...Show All

• Visual Basic Inherit from FileDialog to get Windows XP File and Directory sub controls?

  I just started a project where I want to have a file and folder selection screen in a wizard that the user can select the files or folders that they want to work with. I'm using Visual Studio 2005 and a split container to divide up my two areas. The left side is going to be used to display the hard drive list and the files/folders on the local computer, probably in a treeview control. The right side I will be displaying the files/folders the user has already selected, probably in a listview control. I want them to be able to drag files/folders from the treeview control onto the listview control. My question is, how do I create a hard drive combobox and a treeview control like the Windows XP version In the combobox, I want the icons on ...Show All

• SQL Server Defrag for SQL Servers inside a Virtual Machine?

  sorry for asking here, since there's no forum for Virtual Server My question is We have 2 SQL Server instances on 2 Virtual Machine/Servers (say VM1 and VM2), which resides on a real physical machine (say A) Is there point in defragging VM1 or VM2's hard drive at all or should I just defrag on the physical machine A that's what I thought anyway, first time I defragged without shutting VMs down, I got a blue screen on 1 VM second time I defragged still without shutting VMs down, everything went smoothly I guess it's safer to shut down the VMs anyway Thanks for the answer ...Show All

• SQL Server Write logg to a textfile and send that file as attachment - problem

  I would like to use logging to be able to view information about the package execution afterwards, especially to be able to find out which task that failed and why it failed. Something similar to this: ----------------------------------------------------------------------------- The execution of the following DTS Package succeeded: Package Name: XXX Package Description: YYY Package ID: {5ADDA98B-1F27-404B-8EC4-3568FA4523F6} Package Version: {0DAA5592-D123-4936-94FC-717DDC581866} Package Execution Lineage: {4D353C5F-444E-4870-8A4F-B35B635F3646} Executed On: ServerName Executed By: XXX Execution Started: 2005-06-22 07:14:27 Execution Completed: 2005-06-22 07:40:17 Total Execution Time: 1550,422 seconds Package Steps execution inform ...Show All

• Visual Studio Express Editions pass by reference

  Hi I have a question regarding the pass by reference. I have a function trying to find the selected's node parents For Example, we have a TreeNodes link as A-->B-->C-->D. When the selected Node is D, the function below will find us all the parents node till root node. private void findNodeChain(TreeNode tmpNode, int i) { if (tmpNode.Parent != null) { i++; MessageBox("Parent is "+tmpNode.Parent); tmpNode = tmpNode.Parent; findNodeChain(tmpNode, i); } return; } in the main i call as below MessageBox.Show("Selected Node " + this.selectedNode.Text); //MessageBox Show " Selected Node D " findNodeChain(this.selectedNode, 0); MessageBox.Show ...Show All

• Visual Basic Windows registry user permission in VB.NET

  Hi!!! I'm developing a windows application using the Windows Registry to save important information... this information can be changed... the problem is that when i create the registry entry using VB.NET, the restrict user can't modify this entry... this problem limit my software only to Administrator users... I'd like to know that is possible (using vb.net code) change the permissions to restrict users adding full access to the registry entry that I created... thanks so much Ok ahmedilyas... so the way is store this in a configuration file... the problem is that i'd like to share this in somewhere that the user don't find the file... and this file can not be removed even the software be desinstalle ...Show All

• SQL Server Server Registration Issues

  Hi All, I have a very critical question. It is very important for to me to go on my disaster recovery test. I have a production machine that resides in a different geographic location and I have another machine that resides on with me. When I try to register the production machine from my side there is no problem, I can do it however when I try to connect from my remote machine to the machine that is with me then the production machine is able to register the machine that I have but cannot connect to the database. The error that I am getting is: " A connection could not be established to 'IP Number' Reason: SQL Server does not exist or access denied ConnectionOpen(Connect())... Please verify SQL Server is running ...Show All

• Software Development for Windows Vista Cannot install June CTP Windows SDK

  I have downloaded the *.img file contning Image of the DVD with June CTP Windows SDK I followed all the instructions to uninstall May CTP SDK & WinFX I Installed Net 3.0 June and here's the problem: While trying to install Windows SDK I get this error : "Error 1330 A file that is required cannot be installed because the cabinet file F:\Setup\WinSDK-SDK_MDAC_BIN_common.0.cab as an invalid digital signature This may indicate the cabinet file is corrupt" I checked this file (Size is 2 438 462 / 2 439 168 on disc) - and this file does not contain the digital signature (neither have all the files named starting with WinSDK-SDK_MDAC*.*) I tryed to install MDAC2.8 SDK separetly so that Windows SDK Installer won't inst ...Show All

• Visual C++ VC.Net. Linker Error

  Hello I am getting this error app.obj : error LNK2019: unresolved external symbol "public: __thiscall Array<float>::~Array<float>(void)" ( 1 $Array@M@@QAE@XZ) referenced in function _main app.obj : error LNK2019: unresolved external symbol "public: __thiscall Array<float>::Array<float>(unsigned int,unsigned int)" ( 0 $Array@M@@QAE@II@Z) referenced in function _main my class implementation is undernerh, when i am using whole code in a one cpp file, its works fine, but when i break my class into .h and .cpp and then calling my Array class in the main routine of seperate cpp file, i got the baove liker errors, while compiliation is successfull. So pleaz advice me to fix this issue, i ...Show All

• .NET Development ADO.NET2.0-SqlConnection,SqlCommand and DataReader used in VBExpress:Unable to cast object of type 'System.Decimal' to String

  Hi all, In my SQL Server Management Studio Express, I have a database "ssmsExpressDB" with a table "Table-dbo.LabTests" that has the following columns:         ID(Int)   AnalyteID(Int)  AnalyteName(nvarchar)  CasNumber(nvarchar)  Result(decimal) Unit(nvarchar) LabQualier(nvarchar)..... I created a project in Visual Basic 2005 Express and had the following code: ////////--Form1.vb---////////// mports System.Data Imports System.Data.SqlClient Public Class Form1 Private Sub Form1_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load Dim mySqlConnection As SqlConnection Dim mySqlCommand As ...Show All

• Visual C++ Odd syntax error on compile, known good code

  I'm using Visual C++ 2005 Express Edition to edit, and Visual C++ 2003 Toolkit to compile, using a makefile. The code I'm working on is from publicly released SDK for a game (Firaxis' Civilization IV). The code was written in Visual C++ 2003, thus the workaround. I've done a great deal of editing and have sucessfully compiled over 100 .dll's - just last night I produced a build, tested it in-game, and hit the sack. Now this morning using the SAME code I get a compile error: g:\Civ Downloads\Mod SDK\CvGameCoreDLL\CvUnit.h(741) : error C2061: syntax error : identifier 'BattleUnitTypes' Next I created a new project using the original source code, as a control test. Same error exactly. I'm using the same procedure that I have used ...Show All

• Software Development for Windows Vista Suggestion for Samples

  As a new user trying to grasp WWF, it seems that the examples are not targeted for gradual development. I look at it this way, most every user will need a way to ogin users and start some process once a user is verified. I cannot find any example of using WWF to login a user. It seems that it would be a logical first step after "Helo World". Have a State for "WaitingForLogin", add an even to the next state, "ValidatingUser", add events and states for "LoginFailed", "UseLoggedIn", and "Logout. Ya know ... "something" along those lines. "something" that has a demo using a web form, and a winform, and WPF "something" that includes persistence ...Show All

• Visual Studio 2008 (Pre-release) dynamic query and data shaping

  Using Nortwind I am able to build a dynamic query thanks to code I found on the Wayward weblog as follows: IQueryable< MyProduct > baseQuery = from e in db.Products select e; var expression = baseQuery.Expression; ParameterExpression p = Expression.Parameter( typeof ( Product ), "e" ); Expression body = Expression.EQ(Expression.Property(p, typeof ( Product ).GetProperty( " ProductName " )),Expression.Constant( "Tarte au sucre" )); LambdaExpression predicate = QueryExpression.Lambda(body, p); Expression where = QueryExpression.Where(baseQuery.Expression, predicate); However I also want to do some shaping and as soon as I change the query to : IQueryable< MyProduct > baseQuery = from e in db. ...Show All