Avhacker's Q&A profile

• SQL Server MDX count customers with turnover over x dollar

  Hello Sirs, the subject might sound weird, sorry for that. Here is the the correct question: I have a Cube "Sales" with various dimensions and measures. To get a distinct count on my customers I added a new cube "DCCustomer" with the same dimensions as "Sales" and a distinct count in the numeric field "CostumerID" as the only measure. After that I combined the two Cubes to a Virtual Cube in Analysis Services 2000 to get both the measures of "Sales" and the distinct count measure "DCCustomer" from "DCCustomer". Now, I would like to have a distinct count of customers that have not only produced turnover but turnover above e.g. 150 $. What would be the MDX-Code ...Show All

• .NET Development Web service to connect Cache Server

  hi all, Anyone have any experience on developing Web Service to connect (insert,edit,delete recrod) to Cache server I am having problem to do connection to cache server. Any special tools required or ODBC driver version Anyone please help -- Masita Masita, What do you mean with Cache server ... a DB Server that stores cached data .... a server with some caching tool .. or what Rgds Rodrigo ...Show All

• SQL Server How to recover from mdf file (SQL Server 2000)

  Hi, My database corrupted because when I was running an update query, there is a power failure. After the computer booted, I cannot open the database anymore, it just not responding. Then I stop the sql server service, and tried to rename the .mdf and .ldf. After that it worked normally, but I need the data from the corrupted mdf file, I tried to attach the database but it just hanged. I even tried to attach without the .ldf file but it didn't work either, so I concluded that the problem is with the mdf file. Is there any way to recover my data Thanks in advance Regards, Edwin Hi, We'd tried that but we got no luck. Attaching the file in it's original name didn't work, the computer just ...Show All

• Visual Studio Express Editions Importing VC++ 6 Project

  I have an AppWizard generated project that was built in Visual C++ 6.0. I recently installed Visual C++ 2005 Express, and have not been able to compile it. It can't find any of the afx*.h files. I noticed that someone posted that MFC is not supported on VC++ 2005 Express. Is this true If so, is that only for the Express edition or is MFC support being dropped entirely If it is true that MFC is not supported, can VC++ 6 and VC++ 2005 co-exist on the same computer I'd like to use 2005 for any new projects but I still need to support the old ones. The differences between the various versions of Visual C++ 2005 are explained here . ...Show All

• Visual Studio 2008 (Pre-release) Why Dependency Properties?

  I've been working with WPF for a while now, studying it, programming with it, blogging about it, etc. Despite all that, there is something which fundamentally bothers and eludes me. I just don't feel comfortable with dependency properties. I've read a lot about them, but none of the explanations have satisfied my curiosity. I'm hoping that someone might explain a few things to me, please... - How do DPs work What is actually involved with the inner workings of a DP What happens when you set a DP What happens when you get the value of one Is this explained/documented anywhere I've read about the precedence rules used during value resolution, but how exactly does that work - How does the value inheritance of DPs work When do inhe ...Show All

• Software Development for Windows Vista Error message - "The memory could not be read" - Help please!

  Hello all I'm new here, so I'm not sure whether I'm posting this in the right forum. I have just bought a Toshiba laptop today. I have been playing around with it (always had Windows XP, so Vista is brand new to me!) and everything had been fine till a few minutes ago. I uninstalled Norton (which was already on there) and installed McAfee instead. Installation was okay etc. So I restarted the machine and after the 'welcome' screen (before you arrive at desktop), a pop up box appeared saying something along the lines of "Instruction at 0xc4e9b825 referenced memory at 0xc4e9b825. The memory could not be read". You close that pop-up box and another one appears saying explorer.exe - application error... and that the machine ...Show All

• SQL Server Changing from dropdowns to datepickers

  Hi guys, just a simple question here: i have some input parameters on my report that are datetimes (i.e. the user gets the date picker to select the date), if i want to use that parameter in a MDX statement what will it look like IOW would today's date look like the string "13/02/07", or would i be expecting a string like this: "2007/02/13 00:00" I am looking to convert some dropdowns that contain dates extracted from a cube heirarchy with the datepickers so i need to know what i have to change in the MDX to accomodate this. I also filter the dates that appear in the current dropdowns, is there a way to do this with the datepickers (maybe by pointing them to a dataset of dates extracted from the cube) Thanks ...Show All

• Gadgets Controlling a browser from a gadget

  This may be a more related to Vista/IE7, but I'm looking for an in-gadget solution so here goes. I need to collect a token by allowing a user to login through a website. The normal way is to open a browser via ActiveX and monitor it until the process is complete. The opening code looks like this: var ie = new ActiveXObject('InternetExplorer.Application'); ie.visible = true; ie.navigate2("https://loginpage.com"); At this point I can monitor the ie.Document.body.outerText until I reach the page and collect the token. But... The sidebar runs in protected mode, which gives me a protected mode IE, which returns a wrapper object instead of the IE handle after the call to navigate2. Any ideas how to accomplish this Can I write a simple ...Show All

• .NET Development Trying to get access to Access DB from VB.Net application

  I am trying to get access to an Access database from within my VB.Net application with the following: Dim oAccess as Access.Application My problem is that Access is not recognized. When I try the above statement I generate the following error "Type 'Access.Application' is not defined." I am using Visual Studio 2005 (VB.Net) and have added the following references in my project: Microsoft Access11.0 Object Library Microsoft ADO Objects 2.5 Microsoft DAO 3.6 Obj Library Microsoft Office 11 Obj Library Microsoft Visual Basic for Applications Extensibility With the above added, I still get the same error. Thanks Hello Christie, I understand why your doing what your doing but I need ...Show All

• Software Development for Windows Vista RTM Vista on ATI rs480/rs482 blank/black screen

  Builds 5270 32bit with ATI drivers for 5270. Build 5308 64bit with included ATI driver. Both end up with a black/blank screen after fully installing. Monitor shows sync but no image (not even cursor). All functionality seems there, mouse clicks and keyboard input cause disk light to flash as would be expected. 5308: XP64 drivers work fine, but without any aeroglass 5270: The included drivers work fine if non-wddm, the included wddm drivers show the yellow exclamation point on the device. The drivers from ATI's site for 5270 do the blank/black screen thing. 5270 with ATI drivers work fine with aeroglass on my turion v2310us laptop (rs482) Device specifics: HP/Compaq SR1750NX with AMD64 3500 and ATI RS480/482( ) There is a sij ...Show All

• Smart Device Development using smartphone 2003 SE emulator to send SMS

  Hi expert, my 1st question: i am using smartphone 2003 SE emulator to develope an application to send SMS. May i know is there any build in C# method that can be used to command a smartphone to send SMS is there any references for me to know more about smoonding a smart phone. my 2nd question i found out that the smartphone 2003 SE emulator is not following the GSM 03.38 SMS standard which is use in my country. may i know what standard this emulator is using. thanks in advance !!! You may want to go through this blog http://blogs.msdn.com/barrybo/archive/2005/09/17/469702.aspx -Thanks, Mohit ...Show All

• Connected Services Framework CCF on the .net framework 2.0 / SQL 2005 / BizTalk 2006??

  Hi Does anyone know when will CCF be released on the .net 2.0 framework What about CAB for the Desktop Agent will it be ported to CAB Any new documentation/Samples coming out soon   Thanks alot, the product is amazing. just needs a little more documentation to help find and understand all the bits and pieces.. Thanks Matt, I was hoping for a better estimated time of release, but I understand the way this works, you can't give a date until its official. regarding the documentation, It's comprehensive when dealing the webservices, but the Agent Desktop's architecture and design is not as clear. Also some diagrams showing the major components, interaction...etc Thanks alot ...Show All

• Visual Studio Express Editions Printing in vb.net

  I am trying to print some string and page. I tried the sample program. Entering the line as follows: AddHandler prn.PrintPage, AddressOf Me. PrintPageHandler An error shows on the PrintPageHandler. Am I doing something wrong Thanks. D.Chin, 1. Please provide me the erroor message on the PrintPageHandler. Actually I don't know exactly what is the PrintPageHandler in your code. 2. Please try the following code for printing: Private Sub Print_PrintPage( ByVal sender As Object , ByVal e _ As System.Drawing.Printing.PrintPageEventArgs) ' Draw a rectangle at the margins. e.Graphics.DrawRectangle(Pens.Black, e.MarginBounds) ' Draw a thick, dashed ...Show All

• SQL Server reference member in user hierarchy

  hi, I have a user hierarchy in my Date Dimension such as [Calendar]->[Years]->[Quarters] And I can access the member by directly call the memeber name, for example: select [Date].[Calendar].[Years].[2006].[Q2] on columns, ................................... The results will be correct. However, if I use reference to call the member, for example: select [Date].[Calendar].[Years].[2006].&[2] on columns, ................................... There will be nothing in my results. Would you please tell me what shall I do to enable the reference call to my hierarchy member Thanks. It can be a problem with key for the Quarter member. Are you using integers like 1,2,3,4 f ...Show All

• Visual Basic Publish Problem with signtool

  I keep getting the following message when attempting to do a publish build of my programme .... Error 2 SignTool reported an error 'Failed to sign bin\Release\WindowsApplication1.publish\\setup.exe. SignTool Error: Signtool requires CAPICOM version 2.1.0.1 or higher. Please copy the latest version of CAPICOM.dll into the directory that contains SignTool.exe. If CAPICOM.dll exists, you may not have proper permissions to install CAPICOM. '. WindowsApplication1 Ive done the obvious as detailed in the error message, but the problem remains. Any ideas Thanks for the tip about registring capicom.dll It was in another directory, but it did the ...Show All