Joshizzle's Q&A profile

• SQL Server Dimension Range

  I have a simple cube based on just 2 DB tables. I have 1 measure and 5 Dimensions. I need to create some ranges out of 2 numeric Dimensions. Can anyone suggest how to go about it. It may be a simple thing- but I am just a learner...I have tried to use DiscretizationMethod but my ranges are very specific so it does not help. Hi. Thomas has a good suggestion (thanks Thomas). I'll give you a little more detail. In the Data Source View (DSV) within BI Studio you can create a "named query". The named query allows you to define any valid SQL statement. Think of it like using a view in the SQL db, but it's part of the project in BI Studio so you're not bothered with maintaining a view in the SQL d ...Show All

• SQL Server Login failed for user '(null)'

  I get the following error in the SQL Logs. What does this error mean and how can I resolve this 18452 : Login failed for user '(null)'. Reason: Not associated with a trusted SQL Se rver connection. Thanks Santhosh How can I resolve this The scenario is... We use a third party backup software. This backup software uses SQL as its database to store session records. Whenever, the tape engine starts it logs on the above message and also during the backups it logs on the above message. While configuring SQL to be as the backup software's database, there is a option to enter SQL Security. When we enter SA as security, we do not get this error. When we use windows security, we get this error. Any help is appreciated. ...Show All

• SQL Server Upgrade an active passive sql server 2000 cluster to 2005

  I have upgraded our test server and on non cluster production machine. My next server is a cluster and I don't have a test cluster server. Do I upgrade the active node and that is all or am I going to need to fail it over and upgrade the other node. Also the prerequesite for the upgrade advisor is .net 2.0 I am going to up that on each server one at a time but I am only going to add the upgrade advisor to one node is that ok. I read the SP1 documentation and it clearly states only patch the active node and do not patch the inactive nodes. When you run the upgrade all nodes will be upgraded, but read the documentation in Setup Help before performing the installation. (You have to run setup, then click the Help button.) Be very ...Show All

• Software Development for Windows Vista Multiple NTVDM.exe

  I work for a corporation(TimeManagement Corporation) that uses a 16 bit application that runs in the virtual dos machine. Two years ago Microsoft released a security patch(MS04-012) that caused each new 16-bit file to open in it's own ntvdm thus not allowing our 16-bit application to communicate with other files that it calls. We contacted Microsoft about this but it was not taken care of until we posted on a forum. They then released a hotfix(KB841559) to fix this issue. We are now having the same problem with MS Windows Vista and would like to know if we can get a fix for this issue to allow our program to be compatable again. We do have a 32-bit enterprise edition. However we have several large contracts ...Show All

• .NET Development Exceptions and Invoke

  Hello, I have found some problems while handling exceptions raised by methods, when the methods where invoked using the ‘Invoke’ method of the Control object. My application is a UI application but some of the UI methods are called from other threads than the thread that handles the UI (cross-thread invoke). For that reason I am using ‘InvokeRequired’ and most of the times Invoke (Synchronous invoke) to call the UI methods. The problem arises when the UI method called this way wants to handle exceptions. If I run the application inside Visual Studio (debug mode) exceptions are caught correctly as expected. If I run the application standalone, exceptions are not caught and the application sho ...Show All

• Visual Studio Tools for Office ClickOnce deployment of VSTO2005 Outlook Add-In

  Is this possible We do not have a true ClickOnce deployment of VSTO2005 Outlook Add-in. However it can be deployed using the publish wizard. You can read about it in the following white papers VSTO Deployment · Overview http://msdn.microsoft.com/office/default.aspx pull=/library/en-us/odc_vsto2005_ta/html/officevstowindowsinstalleroverview.asp · Walkthrough http://msdn.microsoft.com/office/default.aspx pull=/library/en-us/odc_vsto2005_ta/html/officevstowindowsinstallerwalkthrough.asp Thanks, Pallavi ...Show All

• SQL Server "Other" grouping or Row aggregate

  AS 2005, SP1: I have a dimension with 15 members which I can filter the Top N members by measure. What I would like to do is append an additional Row as a group or aggreagate the reads "Other" that reflects the remaining measure value. For example, Top 5 Widgets W5 5000 W9 4000 W2 3000 W11 2000 W7 1000 +Other 6000 The "Other" Row would sum the remaining 10 widgets so the user could see 100% of the totals. I can do the Top N but have no idea how to start this one. Thanks in advance for your help. -Troy Reed Jacobson wrote up the standard solution to this problem on his blog recently: http://sqljunkies.com/WebLog/hitachiconsulting/archive/2006/08/03/22345.aspx I ...Show All

• .NET Development Using Api Function SetNamedSecurityInfo in C#

  I try used with SetNamedSecurityInfo API function in C# and it's not work the function not set the new owner to the file. =================================== Example of my Code public class Test { public Test() { int cbSid = 0; string systemName = null ; string accountName = "SomeUserName"; //System.Environment.UserName; IntPtr Sid = IntPtr.Zero; StringBuilder sb = new StringBuilder(); StringBuilder domainName = null ; string SidString = null ; int cbDomainName = 0; int use = 0; int retValue = LibWrap.LookupAccountName(systemName,accountName,Sid, ref cbSid,domainName, ref cbDomainName, ref use); domainName = new StringBuilder( cbDomainName ); Si ...Show All

• Microsoft ISV Community Center Forums Problems with last 2 parts of code?

  Hi Just testing my almost completed project and have come across two pieces of code that are proving a pain in the butt for me! I wonder if a fresh set of eyes may pick up on something i'm missing... Basically I have to run the macro a number of times before it properly removes all the rows of data I want it to - any ideas Sub cmdRemoveEntries_Click() 'used to automate the removal of exceptions such as Russia, Ukraine Dim x, z As Integer Dim cell As String z = Module1.GlobalCount 'total number of employees to be processed For x = 2 To z cell = "O" & x 'O signifies the Site in which the employee is based 'feel free to add other countries/sites as they become applicable 'MS/NN/WT ...Show All

• SQL Server problem in creating a database diagram in Management Studio

  I am using Management Studio of SQL Server 2005 Standard edition, and try to create a database diagram. Then I got an error which says: "Database Diagram support objects cannot be installed because this database does not have a valid owner. To continue, ..." Then I checked the database, it has a valid owner. I also tried to follow the instruction given, and changed the database owner to a different login such as sa. It just does not solve the problem. Can anyone share some light, ideas, or suggestions Thank you. Chris sometimes i do encounter this problem my workaround is to use the visual studio 2005 create a connection to sql server 2005 via vs20 ...Show All

• Windows Forms MSI run from VS setup.exe is not themed

  We are using the the Visual Studio 2005 bootstrapper to create a setup.exe that will install the .NET Framework 2.0 before installing our application. It works fine, except that the dialogs from our MSI do not display buttons or progress bars using the selected Windows XP theme. Instead, they appear with the Windows 95/98 look. I've experienced this problem using MSI's created with WiX and with VS2005. This isn't a huge deal, but I'd like to fix it if possible. Is this a bug, or is there some setting I need to add/edit Thanks. Sorry for my late reply, it's been rather hectic the past ten days. I thought this was probably just something I'd have to live with. It just seemed wierd that the problem only appe ...Show All

• Visual Studio Team System HELP！After modify WSS,All developer Can't link to VSTSSERVER in IDE,and VSTS website can't open.

  1--I wan't to add alert/notifications email, so I use sharepoint to manage vstsserver web , 2--now in manage virtual webpage ,list three website "default website, http://vstsserver:8080 , http://vstsserver proxy:8081", the version of vstsserver is no install, 3--I click "vstsserver" link , It tell me extend and create content database, I do that. 4--Then the vstsserver website create . 5--Then all developer can't use VSTS!!! 6--All developer can't use VS2005 IDE to link TFS. 7--When open Project Website , It tell "Http 404 error" 8--When add new Project , it tell "TF31001 error" It sounds like you let WSS (SharePoint) extend the TFS web site (the one on port 8080). This breaks all the ...Show All

• Visual Basic how to save a webpage's source code in vb.net?

  Hello there, i have this task to get the source code from a given url e.g. you type a url in a text box, press the button and it goves you the source code in a text file or saves it in a memory. I am sure there is some sort of method in vb.net where you can get that and save it in a memory or text file, however it seems that i am not looking in the right place. If anybody knows, could you please give me some info I use visual studio 2005 and win xp pro. Hi, A lot of web site HTML code is generated automatically and is not hard-coded so basically, unless it is a very simple web-site, you have little chance of getting the original code if the site is database driven using ASP ( active serv ...Show All

• Visual Basic Multiple fontstyles for a font

  Hi, Another simple question i'm sure... I'm trying to create a font with multiple FontStyles... e.g. bold and italic and underlined I've got the basics for a single fontstyle but just can't work out multiple ones. Current Code: Dim fnt as new Font("Times New Roman", 12, FontStyle.Bold) Any help would be greatly appreciated (can't believe i've been writing apps for the last 5 years and never actually come accross this problem before!!!) Thanks OK i've wprked it out, Just me being a bit slow!!! I've created a Font Generating function that returns a font (below) taking the font name, size, and boolean values for Bold, Italic, Strikeout and Underline. Private Function ...Show All

• Windows Forms Problem while Deleting the first band from Infragistics control

  Hi Freinds, I am using the Infragistics UltraWinGrid and UltraDataSource control. I have created three bands in the grid and added child band on each of three bands. I write the following code for this : this .ultraGrid1.DataSource = this .ultraDataSource1; this .ultraDataSource1.Band.Columns.Add( "File" , typeof ( string )); //Adding Band and its child Band. for (int i = 0; i < 3; i++) { UltraDataRow row = this .ultraDataSource1.Rows.Add(); // Set Header cell values. row[0] = "ABC" ; UltraDataBand childBand11 = this .ultraDataSource1.Band.ChildBands.Add( "ChildBandName" + i.ToString() ); for ( int i = 0; i < 5; i++) { childB ...Show All