Tazzmann's Q&A profile

• SQL Server Update cube with ADOMD and SSAS 2005 : CellSet value is not refreshed

  Hi, I'm trying to port an existing piece of VB6 code that works fine on SSAS2000 onto SSAS2005. This code uses ADOMD to perform an MDX select statement by opening an ADOMD.CellSet object. It then performs an Update Cube statement on the same data and then displays the CellSet updated value again. Both Select and Update fonctions work fine except that the value in the cellset is not updated. When I close and reopen the connection, I can control that the cube has been correctly updated - the transaction commit works fine - the value is updated but the value in the cellset is not updated. I enclose here a piece of sample close which illustra ...Show All

• .NET Development Is the NET framework 2 the final version or beta?

  Is the NET framework 2 the final version or beta My hosting provider is running NET Framework 1.1 and I hope for an upgrade… It has just been announced that Visual Studio will be released on November 7th: http://www.informationweek.com/story/showArticle.jhtml articleID=164301022&tid=13692 ...Show All

• Visual Studio MSBee cannot find the FW1.1

  Hi Everybody, I've just installed MSBee and as I tried to run it for the very first time I got an error saying that my PC was missing the FW1.1 I checked in c:\windows\Microsoft .NT\Framework\ and I found it! Can you help me Kind regrdas, Giulio Guilio, Could you provide me with the exact error message My guess is you have Framework 1.1 Redist installed but not the Framework 1.1 SDK. You can download the SDK from here . Even if you have it installed, reinstalling might solve the problem. Thanks, Bertan ...Show All

• Visual C++ Checking if a trivial event has any handlers

  How does one check if a trivial eventy has any handlers When I try to say 'if (SomeTrivialEventMember)...' I am given compiler error C3918. This tells me the error can occur trying if I attempt to check a trivial event for null. But of course it does nto tell me how I do check a trivial event for handlers. I hate to think I must change a trivial event to one with specified add, remove, and raise methods just to be able to check and see if it has any event handlers. It is common in mathematical functional programming to pass a function with a return value as an argument. If there is no handler, there is no re ...Show All

• Windows Forms Methods parameters

  Tell me please about methods parameters in C#. How I can transmit parameters by value and by reference. Please, give me a simple examples, if you can. read this post, might help http://addressof.com/blog/archive/2003/05/30/194.aspx ...Show All

• SQL Server Convert UTC time to local time

  Hello, I am new with the reporting services. I am creating a report and I need to display date/time on the report. But the servers stores those date/time in UTC. How can I convert them to the local time in my report.   Thanks for your help.     You need to use System.TimeZone.ToLocalTime(UTCTime). See http://msdn2.microsoft.com/en-us/library/system.timezone.tolocaltime.aspx . You should be able to use TimeZone.CurrentTimeZone if you want to convert using the server time zone. ...Show All

• Visual Studio 2008 (Pre-release) Using Linq on VS2005 RTM with a non-admin user

  I'm not able to use Linq on VS2005 RTM as a non-admin user. Installation was fine and Linq project type show up when I choose a New Project using an a admin user. But it disappear when I use VS2005 with non-admin user. I tried to see what it is doing with FileMon (from Sysinternals) and there are a lot of "not found" messages on some Linq files. Any hint on this Thanks Marco Russo Try to copy all files from "Administrator's Documents Folder\Visual Studio 2005\Templates\ProjectTemplates" to "User's Documents Folder\Visual Studio 2005\Templates\ProjectTemplates". Or try to reinstall LINQ Preview as non-admin user. Hope this he ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Are there any MDX examples of frustrum and occlusion culling about?

  well by examples i'm realy looking for something that uses frustrum followed by occlusion culling in c#. as i'm trying to find out how i would take the result of frustrum then feed it into occlusion culling. inorder to get the final render. i'm also very new to c# and MDX. and here's one on frustum culling from chad http://www.c-unit.com/tutorials/mdirectx/ t=45 In general though frustum and occulsion culling are reasonably advanced topics and just copying code as a beginner will probably cause you more pain that gain. Good luck. ...Show All

• Software Development for Windows Vista Persistence service

  Hello, We have started working with the new framework but few things are still not clear to us. We understand that the persistent service is working in the workflow level , does it mean that every time the workflow is moved to idle and we are using persistence service all the workflow will be saved to database and on Unpersist event all the workflow activities are loaded to the memory again What will happen if my workflow have 100 activities and each activity hold complex object that contain data, will it all be load to memory on unpersist event Appreciate your help Me Hi, The UnloadOnIdle can be specified on the constructor: ...Show All

• SQL Server using rank

  I've written a bunch of code using contains for fts. Then as I was trying to run the sorting, I realized that I have to use containstable in order to sort by rank. Is that correct When I was using contains, I just used it as a where clause so I would have something like... WHERE ((PostedUntil >= '5/22/2006') AND (SiteId=199)) AND (CONTAINS (PositionTitle, '"sales"') OR CONTAINS (Description, '"sales"')) From the examples I've seen, in order to use containstable, I have to join a new dynamic table to the freetext enabled table and it only uses 1 containstable phrase for the new table. In my case, I may have multi ...Show All

• SQL Server Font object saving and retrieving

  Let's say a User selects a Font from a FontDialog, and the selection is assigned to a Font object. How can I save the Font object to a SQL database, and later retrive it restored to a Font object Thanks in advance. Seems more like a question for the .NET forums. Is the Font object serializable If so you could store the xml to SQL Server. ...Show All

• Visual FoxPro similiar fields

  Hi I'm trying to cross reference records from two different databases by first and last name. I can pull most the records (about 1500 out of 1700) on straight forward comparison of (a.firstname = b.firstname) and (a.lastname=b.lastname) as for the rest, is there a way to check if one name is similiar to another (in case of a typo, or mis-spelling of the name) Thanks, Mike Not an easy task as there could be many spellings, punctuation, etc. You could try SOUNDEX() although it only works for English expressions/names and has limited use at that. ...Show All

• SQL Server Looking for simple sample

  Hello I'm looking around for tutorials and samples for Notification Services applications for a while now, but I just can't find something that covers what I want to do. All I want is to check if a value in my Database changes or exceeds a specific value and then send a mail. Does anyone know a good sample that show's me how to do this or can anyone explain it in a couple of words Thanks in advance! This is a fairly common scenario. Use the SQL Server Event Provider to query your database table, looking for new or changed records. In your Subscription Class, have each subscriber specify the thresho ...Show All

• SQL Server SUBREPORT ACCEPTS ONLY FIRST VALUE FROM MULTIVALUE PARAMETER

  Hi everyone, I have a problem passing a multivalue parameter to a subreport. I have a main report that has a chart and a table. I set one of the datafields (a chart's column) on the chart to be clickable to jump to a subreport. I pass two parameters. One of them is a multivalue parameter. It is called 'Name.' I right-clicked the datafield -> properties -> action -> jump to report. I selected my report, then clicked parameters, chose my parameter name. For parameter value I went to expression -> parameters, chose my parameter - Name and this is what is being assigned by default: =Parameters!Name.Value(0) I understand it is ...Show All

• Architecture Spcification of web services you need from third-party company

  I want third-party company to implement bunch of web services. I wonder what it is the best way to specify them. I can create wsdl for them, is it ok Interoperability is very important because services will run on non-windows machine and clients will run on windows boxes. thanks in advance for any info Pawel, Are you saying that you want them to use web services that you have implemented We have toyed with this question ourselves. There are, basically, two avenues of approach: Deploy your wsdl in a public or client-accessible arena, point them to it, and wish them luck. Or, what we have considered, and begun doing, is creat ...Show All