mohdtmn's Q&A profile
SQL Server Problem with OPENQUERY
Hello, I've got a problem with OPENQUERY. When I use SQL Server Management Studio, I don't have any errors (I'm logged as Admin via Windows Auth.). When I try to use Adomd via ASP.NET (user - ASPNET with admin role, which is set in Man. Studio), I've got an error: Errors in the high-level relational engine. A connection could not be made to the data source specified in the query. Any idea Other querries work fine (i mean that querries which don't use OPENQUERY statement). SELECT t.[Name], [DecisionTreeModel].[Party], PredictProbability([Party]) From [DecisionTreeModel] PREDICTION JOIN OPENQUERY([VotingRecordsRDS], 'SELECT [Name], [Permanent Tax Cuts], [Campaign Finance Overhaul] FROM [dbo].[VotingRecords] ') AS t ON ...Show All
Windows Forms how to debug a control as it's loaded into control/resource/forms editor
I have a control with a number of other controls on it, as well as a tab control with 2 pages. I can drop this control from the Toolbox onto a new form, and it shows up and "runs" in the designer with no problem. However, I am not able to see or edit the control in the forms designer when I right-click on the file in Solution Explorer and choose "View Designer". VS simply hangs there, and task manager shows that it is taking almost all the CPU time while it hangs. I know that reflection is at work here, and perhaps it's just overwhelmed with the amount of work it has to do (other controls and forms open fine on my system.) But I'd like to get to the bottom of why this is happening. I have attached the d ...Show All
Visual C# question about break
I am confused of using "break".... if i have this 2 cases... case 1 while() { if() { break } } case 2 case xx if () { break } case yy In above two condition, if it meet "break", it will jump out of the if function and continue execute in the while loop or case, or if it meet "break" it will jump out the while and case HopeDreamsComeTrue wrote: I am confused of using "break".... if i have this 2 cases... case 1 while() { if() { break } } case 2 case xx if () { break } case yy In above two condition, if it meet "break", it will jump out of the if function and continue execute in the while loop or case, ...Show All
SQL Server Cell Drillthrough in Reporting Services 2005
Hi, I’ve build a report in reporting services 2005, based on a MOLAP cube (Analysis Services 2005). In the cube I’ve enabled drillthrough. I know that we can define drillthrough in the report by clicking on one of the members of the dimension hierarchy, but that’s not what I want. I want to be able to drillthrough on a cell. Is there any way how to do that in Reporting Services 2005 Thanks, Abdel Please note the the original question was asking about a drillthrough action in the cube. If you just want the user to drilll through to another report, you can use the SSRS navigation feature. To do so, right-click on the textbox which will be use for drillthrough and choose Pro ...Show All
Visual Studio Tools for Office VSTO SE Runtime install failed
Hi there - I've got vsto 2005. When I try to install SE the installation of the runtime fails. I've looked through the installer log and the only thing that looks remotely suspicious is the following: ExpressUI: ISetupManager::GetGlobalCustomProperty() failed to find global prop in CProgressPage::RunningComponent() ExpressUI: {4F8791EE-486F-44B5-952B-F28F9FD58BD0} This entry shows up multiple times throughout the log. The final message is: Visual Studio 2005 Tools for Office Second Edition: CRootComponent::Install(): Setup Failed; MSIInstallProduct return value either ERROR_INSTALL_FAILURE or default. I haven't found any references to the issue on msdn. Does anyone have any ideas how I might go about rectifying this problem ...Show All
Visual Studio Get Latest Version(Recursive)
hi Can anione kindly tell why this option works only when the file/project is checked out and what is the main purpose of this option.. Regards, Hisan Your file/project does not have to be checked out to call the "Get Latest Version(Recursive)" command. When you call the command, you will get the latest version of the file/projects only if the VSS store has a version that is newer than what you have locally on your desktop. An example: If you have a C# project containing one file (file1.cs) on your computer and later you have another developer that adds another new file (file2.cs) to that project on his computer. Then when you look at your C# project, you will not see the newly added file since your C# projec ...Show All
Windows Forms Disable design time support for child controls
Hi, I have a usercontrol, which is a panel, containing several radiobuttons. I have a customer designer for the control. I want the control to be designed as a whole, not individually for every child controls. That means if user clicks on one of the radiobuttons, the properygrid shouldn't show the properties of radiobutton, I would like it stay for the whole control. Is there any way to do this Thanks in advance! You can turn the ContainerControl flag on and of with the SetStyle methode. Use it in your constructor like this: Public Sub New () MyBase .New() SetStyle(ControlStyles.ContainerControl, False ) InitializeComponent() End Sub ...Show All
SQL Server Problems with using filter in cube browser
Hello everybody! I'm a freshman in creating cubes with Analysis Services. My problem is the following: I designed a cube for analysis on accounting. I've got a time dimension with a hierarchy (Year, Half-Year, Quarter, Month) and a measure showing the balance of each period. Additionally I created a calculated member which should show the balance of the previous year to campare it with the current balance. Therefore I used the PARALLELPERIOD-function. As I don't use the filter in the cube browser everything works fine. But if I filter a certain year, no value will be shown for the previous year balance. The problem is that the other years 'disappear', so that the PARALLELPERIOD-function can't access them anymore. Does anybody k ...Show All
Visual C# Unmanaged to managed code
I have funtion wich was written in C++ and has the signature like this : "DWORD XPTO(BYTE **aux)" I want to use it within C# code but the function has to be declared like: static extern xpto( aux )), I dont know how to translate it!!! Can Anyone help Thanks a lot! Barbara BYTE **aux returns a byte value, whereas BYTE aux** is a pointer to a pointer that points to a byte array. um..No. "BYTE **aux" is a pointer to a pointer to a byte. The stars attach to the BYTE, not to the aux. Hence aux is a pointer. Later, when I use the value aux, then the stars attach to aux: BYTE** ppByte = aux; BYTE* pByte = *aux; // aux poin ...Show All
Visual Studio Team System Unreferenced component WebtestFramework
Warning 1 The referenced component 'Microsoft.VisualStudio.QualityTools.WebTestFramework' could not be found. I have tried re-installing VSTS, but am seeing this when I try to build a project with a web test plug-in. While this worked at one time, I cannot say when it started failing. Thanks, Tom Uninstalling VSTS and .Net 2.0 framework, then re-installing them did not work. I tried manually re-installing into the GAC (see below) but they still do not work. It lists the assembly in VSTS when I try add refernce .Net, but it then shows up under references with a yellow alert, and when I try to build I get the same error. C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PublicAssemb ...Show All
Visual C++ Namespace issue with IMPLEMENT_DYNAMIC macro
I have a problem in using IMPLEMENT_DYNAMIC macro. My base class dialogs are placed under a name space. So that when I give IMPLEMENT_DYNAMIC( CMyDailog, CDialogEx ); Take as it is defined inside UICommon name space. When I’m putting the dialog outside the namespace, it’s working fine. The error message was follows error C2039: 'classCDialogEx' : is not a member of 'CDialogEx' How can I resolve this issue Adding line using namespace UICommon; to the dialog cpp file seems to solves the problem (VC++ 8.0 version). Without this line, IMPLEMENT_DYNAMIC with CMyDailog::UICommon is not compiled. It looks like macro tricks are not working with namespace. If you d ...Show All
Visual Basic side-by-side interop assemblies to support QA/Pilot/testing?
Will this toolkit allow me to do side-by-side COM Environment: Windows 2000, Citrix. Thus, side-by-side COM natively supported in Win2k3/vista/XP (reg free com) is out. And, the old-school COM redirection (.local files) seems very very messy. Need: I need to have multiple versions of my winForms assemblies on the same citrix box... Why Testing mostly... We may need to pilot a new release... or the QA group may need to compare/contrast several versions, etc, etc. With .NET it's easy... I just copy the DLLs into a new folder and launch the app from there. With COM, side-by-side is difficult, and I don't care to get into interface messes. I just want to compile, xcopy, and go! So... side-by-side COM interop... Does this toolkit h ...Show All
.NET Development Convert MySqlQuery to OleDB??
Hello, I have this MySQL query below that I want to convert to a format that OLEDB will like, I've tried may permutation but none work. Any hints as to what needs to get done to convert this so OleDB stops yelling at me :) Also, are there any VS add on's out there that can help in this SELECT ABCXXX FROM `aTable` WHERE targetDb = 'xxx' and MatchPercentNo=100 AND delFlag =0 LIMIT 0,1;”; Thanks in advance!! LIMIT isn't supported in SQL Server. To get similar results, change the query like this (I formatted it a bit for clarity): SELECT TOP 1 ABCXXX FROM aTable WHERE targetDb = 'xxx' AND MatchPercentNo=100 AND delFlag=0 ...Show All
Visual C++ Error C2894
Hello. I am writing simple pakcet sniffer and i am using WinPcap. And when i try to compile my project occurs error C2894 "Error 1 error C2894: templates cannot be declared to have 'C' linkage C:\Program Files\Microsoft Visual Studio 8\VC\PlatformSDK\include\wspiapi.h 44 ". Here is the definiton of the template: #ifndef _WSPIAPI_H_ #define _WSPIAPI_H_ #include <stdio.h> // sprintf() #include <stdlib.h> // calloc(), strtoul() #include <malloc.h> // calloc() #include <string.h> // strlen(), strcmp(), strstr() #if defined (__GOT_SECURE_LIB__) && __GOT_SECURE_LIB__ >= 200402L #define _WSPIAPI_STRCPY_S strcpy_s #define _WSPIAPI_STRCAT_S strcat_ ...Show All
SQL Server Dynamic Form Letters
I would like to design a 'mail merge' type of letter, whereby some of the paragraphs will be conditional on parameters. Can anyone direct me to example of mail merger letters using reporting services thanks ken ...Show All
