toniSQL's Q&A profile

• SQL Server Reference axis(2) members in MDX

  Hello everybody. I've got a little problem: I want to reference axis(2) members in a calculated member, so I can use multiple selection. I've tried: with member [Measures].[Test] as 'settostr(axis(2))' select {[Measures].[Test]} on 0, {[Dim Sales Territory].[Sales Territory Region]. members } on 1 from [Adventure Works DW] where ([Dim Geography].[Country Region Code].&[US], [Dim Geography].[Country Region Code].&[CA] ) However, I get an error. Is there any other way Thanks a lot, Santi You could use the Existing function: >> with member [Measures].[Test] as settostr ( Existing [Geography].[Country].[Country]. Members ) select {[Measures].[Test]} ...Show All

• Visual Studio Workround for Subreport within a subreport??

  I have a main report, whith details of a "work order". Within this report is a subreport, and this details all revisions for that work order. This is a requirement. I've been asked by the users to create a summary report for each of them, and from there allow them to expand into the main report. Doing so obviously then gets rid of my revisions subreport. I've read into using hyperlinks but upon trying this I get the same problem. Is there a way to get around this successfully Will this be an implementation into a later version of CR for .NET (is this a limitation to CR.NET, or is it an issue in all CR products ) Any help would be greatly appriciated. Kind Regards, Luke Actually, it's doable. ...Show All

• Software Development for Windows Vista Stack Trace, help?

  Does anyone know what could be causing this error when starting a workflow Thanks,Mardo[FieldAccessException: System.Workflow.ComponentModel.FaultHandlerActivity.FaultProperty] Mimi.SL.MimiWorkFlow.MerchantPartner.InitializeComponent() in G:\development\com\CurveNorth\Mimi5\SL\MimiWorkFlow\MerchantPartner.Designer.cs:125 Mimi.SL.MimiWorkFlow.MerchantPartner..ctor() in G:\development\com\CurveNorth\Mimi5\SL\MimiWorkFlow\MerchantPartner.cs:22[TargetInvocationException: Exception has been thrown by the target of an invocation.] System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor, Boolean& bNeedSecurityCheck) +0 System.RuntimeType.CreateInsta ...Show All

• .NET Development not quite sure what .NET technology to use for this

  I have been tasked with developing a system similar to trading software that is used by brokers to bid and sell stocks. I have never developed a .NET application so this is to be my first. I have over 3years of programming though, so concepts are not that hard to grasp. I have read on web services, gone through a bit on threading and am not quite sure if it should be client server based. I have chosen c# as a language of choice. In brief, there are people in a room, each on a computer, bidding and selling for certain things. none of those people can see whats going on on the other's computer but each can choose to buy whats on offer, sell what they have or bid for something on sale. I think it is a typical in a stock trading floor. Its not ...Show All

• Visual Studio Tools for Office Type Mismatch error when using Find method in excel

  I know that I had posted this before, but no one responded and I still can't find the answer :(.... Can anyone help me out with this I'm trying to open an existing excel file, search for some text, write some text to the document, and save the document. Here is my code: Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application(); xlApp.Visible = false; String DocumentLink = "whatever.xls"; if (!System.IO.File.Exists(@DocumentLink)) { Console.Write("\t*DOES NOT EXIST*"); } else { Workbook wb = xlApp.Workbooks.Add(@DocumentLink); Worksheet ws = (Worksheet)wb.Worksheets[1]; Microsoft.Office.Interop.Excel.Range RangeOfText = (Range)ws.get_Range(" ...Show All

• SQL Server Linked Server with SQLNCLI and a default database.

  I have a linked server from one 2005 server (server A) to another 2005 server (server B). The linked server is created like this: EXEC sp_addlinkedserver @server = N 'TEST' , @srvproduct = N '' , @provider = N 'SQLNCLI' , @datasrc = N 'twx-webdev' , @catalog = N 'Hornet' This query works fine: SELECT * FROM TEST . Hornet . dbo . NotificationTrigger But, I need to be able to make a query from server A to server B without specifying the database name. I need the default database of the linked server to be used when making the following query: SELECT * FROM TEST ... NotificationTrigger This query does not work. The query returns the following error: Msg 7313 ...Show All

• Visual Studio 2008 (Pre-release) Dynamic UI using style created in XAML

  I've created a style in XAML that is applied to several buttons. I would like to generate some buttons programmatically, but am having trouble assigning the style that was created in XAML to them. Is this possible What is the syntax for this: Dim b As New Button b.Content = "Test Button" b.Name = "Test01" b.Style = Thanks!! b.Style=FindResource("namedStyle") as Style you have to name the style in your XAML (using the x:Key attribute) and it can be accessed from the scope of the object in which it is a resource. So if your style is declared in a <Window> element's resources, the <Window> is what can see it. Hope this helps. ...Show All

• SQL Server Backup MS SQL 2005 -> Restore MS SQL 2000

  hi there i've made a backup from a MS SQL Server 2005 database and i tried to restore this database to a MS SQL Server 2000. Unfortunately, I got following error The backed-up database has on-disk structure version 611. The server supports version 539 and cannot restore or upgrad this database. what can i do is it possible to restore the MS SQL Server 2005 DB on a MS SQL Server 2000 Philipp I faced the same situation many times. The easiest method is to just create an empty database on SQL Server 2000 and use the Export Data wizard from SQL Server 2005 Management Studio to copy your tables and views. For stored procedures you need to create scripts on 2005 and run it on 2000. ...Show All

• .NET Development DAL code generating tools

  I am doing evaluation of different Data access layer code generation tools for dotnet. Many people in the industry do evaluation of t he tools based of many points.3 of those points are not understandable to me. 1. Maintains single identities for objects returned from queries 2.Resolves Circular Identities 3.Business rule Support Can somebody please help me in understanding in laymans language what these means Cheers leo HI , Leohere.. maybe you can have a try at DevExpress express Persistent object framework,if you will the DAL generate code at runtime. compare with other ORM solution with xml maping file ,the XPO using Attributes to Map the Persistent Entity to database ta ...Show All

• Architecture 3-Tier

  Hello, I want to know about 3-Tier Architecture, I know that it has, User Interface Layer Business Logic Layer Database Layer. How can i explain that to somebody in effective and simple way about each layer, and how i can expain about each layer can u guys give me an example please (maybe from your previous development and experience) Guide me Hi; Nice posts Arnon & Diego. Well, I was little confused about 3-tier distribution and 3-tier services application. I think the goal of having Multi-tiered architecture is to de-couple independent modules from each other into a separation of layers. Which promotes extensibility and allow for distributed processing when needed (which I basically call: a way to scale your application). ...Show All

• .NET Development My.Computer.Audio.Play / Fast User Switching

  When using My.Computer.Audio.Play with AudioPlayMode.Background the sounds will play over multiple user account when using Fast User Switching. The Windows Logo programs state that sounds should not be heard over multiple user accounts when using Fast User Switching. This occurs within Windows XP and Windows Vista RC1. Shouldn't this be handled by the .NET Framework What is the best practice when using the .NET Framework 2.0 Do we need to upgrade to the .NET Framework 3.0 to resolve this issue A solution would be greatly appreciated and thank you in advance. MSDN Reference: http://msdn2.microsoft.com/en-us/library/cf1shcah(VS.80).aspx Regards, Luke Audio.Play() just calls the PlaySoun ...Show All

• Visual Studio 2008 (Pre-release) sample service doesn't work on Windows XP 64

  Hello, I tried to make a windows service that hosts a WCF service. Naturally, I've tried the sample first. It crushes raising an error: System.ServiceModel:Incorrect function at System.ServiceModel.Channels.SharedHttpTransportManager.OnOpen() at System.ServiceModel.Channels.TransportManager.Open(TransportChannelListener channelListener) at System.ServiceModel.Channels.TransportManagerContainer.Open(SelectTransportManagersCallback selectTransportManagerCallback) at System.ServiceModel.Channels.HttpChannelListener.OnOpen(TimeSpan timeout) at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout) at System.ServiceModel.Channels.DatagramChannelDemuxer`2.OnOuterListenerOpen(ChannelDemuxerFilter filter, IChannelLi ...Show All

• Windows Forms adding another setup to the installer and adding shortcuts to it

  i am using VS Studio setup project for creating setup, the points i have doubt in are; 1.my application requires directx as prerequist, so i need to add directx runtime setup to it. How can i check condition for directx and then add setup files for its installation to the main installer so that it could be checked and installed before main application. 2.I need to add shrotcut file to the installer project without already adding the file it is referring to. Yes bootstrapper seems good option, but i need DirectX packages to be placed in the the bootstraper/packages folder that follows publish.xml and product.xml, i downloaded some existing package from some site for DirectX 9.0c, but since it is ...Show All

• Visual C# Windows Serial No

  Apologies if this is the wrong forum. I posted on the "Where is the forum.." but no answer yet and I need to push on with this. I can obtain the Windows serial no from WMI (Win32_OperatingSystem.SerialNo) which provides me with the serial number that is diplayed on "My Computer" properties. My question is this: How unique (or not) is this serial number I would hope that this be unique to each copy of Windows. Does anybody know And what about OEM editions of Windows Can any MS guys looking in help me out on this one In case you are wondering I was thinking of using this serial number as part of a computed key. I have discounted using CPUID, MAC, and hard disk serial number, for various reasons. The Win ...Show All

• Visual Studio Unable to debug System.Net.DigestClient throws an exception

  I converted a VS2003 application to a VS2005 application. I have no errors and no warnings when I compile. When I attempt to run I get the error:   Unable to start debugging on the web server. The type initializer for 'System.Net.DigestClinet' threw an exception. Any thoughts on how to fix this I am assuming this is an IIS web application. Is this correct Do you have the same problem for all web applications Do you have the same problem on all computers ...Show All