Chris Denslow's Q&A profile

• SQL Server dataset MDX query based on variable dimensions on rows in RS2000

  Hi, I am trying to create a OLAP report in which users can select a dimension and the level they want to see on the rows. The dimensions an levels are in report parameters. The measures always go on the columns. Creating the expression for the query of the dataset is not the problem but showing the data in a table is the tricky part. RS2000 automatically creates the fields based on the queryresults. But the name of the fields is genereated based on hierarchy/level e.g. SalesOrg_Ctry_Dpt_Department and the value is from the database field [SalesOrg].[Ctry_Dpt].[Department].[MEMBER_CAPTION]. When the query changes the name and value of t ...Show All

• Visual Studio Express Editions how connect a Visual Basic express edition application to an Oracle database

  Hi, the title of this message, says quite everything I want to know. I'm developping a human ressource tool and the database I have to use has been developped with Oracle 9i. And I don't know how to connect my application made with visual studio 2005 express edition to Oracle Tkanks everybody -) You can use the System.Data.OracleClient namespace. ...Show All

• SQL Server Updating database

  Can someone please tell me what I am missing... I am trying to update a record with information a user types into a textbox. I am not getting any errors even when in DEBUG mode. But yet the Data is not getting updated. Any Help would be very much appreciated. T CODE: Protected Sub bUpdateSlsNum_Click( ByVal sender As Object , ByVal e As System.EventArgs) Handles bUpdateSlsNum.Click Dim myCommand As SqlCommand Dim myConnection As SqlConnection myConnection = New SqlConnection( "Server=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|CustomerInfo.mdf;Integrated Security=True;User Instance=True&quo ...Show All

• Microsoft ISV Community Center Forums Excel edit mode

  How can i detect "edit mode" in excel macros Thank's for idea(s) Hi, The support engineer needs some additional information before he can research this for you. *** After reviewing the post, I understand that you want to write VBA code to detect if an Excel cell is in "edit mode".   We cannot find related property in Excel object model. The Excel object model reference is in the following link: http://msdn.microsoft.com/library/en-us/vbaxl11/html/Welcome_HV01134775.asp   Could you let me know the detailed scenario in which you want to implement this functionality *** th ...Show All

• SQL Server How to execute SSIS package from stored procedure

  I have deployed a package on my local sql server. How do i write a stored procedure to execute it. I want an application to call the stored procedure which executes this package which in turn returns some results. I have dont this by deploying package on filesys and using dtexec.exe command to execute it. But now I want to do it from a stored procedure. I have a scenario here. I want the service broker to recv request with order details. Service broker executes a procedure to process the message. Now Procedure in turn calls a ssis package which returns a sucess/failure flag. Service broker then sends ...Show All

• Windows Search Technologies Cannot uninstall WDS v2.6.5 (5378) under XP SP2

  Howdy, I am using XP SP2 on a IBM T40 laptop, accessing through two accounts; one with admin privilege and the other under Power User. For daily usuage, I used the latter. The problem is I can't uninstall WDS v02.06.5000.5378. It is because: a) WDS isn't listed in Add/Remove Programs b) the Uninstaller package is not listed in %systemroot%\$NtUninstallkb911993-V2$\spuninst and lastly c) The "Windows Install Clean Up" does not have WDS listed BUT I found instructions to remove the product manually at http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=257994&SiteID=1 , but upon doing so, I found: a) while ...Show All

• Visual Studio Express Editions VBexpress download is the wrong size and incomplete

  I have downloaded several times. It always completes less than the indicated size and the iso always has errors so that SQL server Express cannot be installed from it. I have plenty of disk space. How can I get a full .iso file Moved thread to Installling and Registering VSEE instead. If the connection is unstable and unreliable you might consider using a download manager. These are a couple of free that does not seem to be too bad. http://www.freedownloadmanager.org http://www.freshdevices.com/freshdown.html   ...Show All

• Visual Studio WarnedOldMSSCCIProvider

  Still working on a MSSCCI plugin.  Have currently been using the decrementing WarnedOldMSSCCIProvider registry value while developing.  How do I set everything when I release the final version   From what I understand, I don't need a license key, since I have a plugin rather than a VSPackage.  But I also don't want my users to time out after having opened VS .Net 500 times. Thanks, JD Hi JD, It seems to me your source control provider doesn't implement yet the S CC_CAP_REENTRANT capability. You need to implement this capability and return this flag from SccInitialize() ...Show All

• Windows Forms Unable to receive creatures and unable to load local creatures

  I installed the terrarium client for the 1.1 version of .Net framework on two different computers. The installation went fine on both of them. Both computers, although in different locations and on different networks are behind a NAT router, I have tried every way I can possible configure the NAT to allow port 50000 through, but on both machines everytime&n ...Show All

• Visual C# Rename the App_code.dll generated by .Net framework 2.0 Web Service

  Hi, I have created a new Web service using the VS2005. After publishing the web site I got a assembly with name app_code.dll. I want a meaningful name and thus want to rename it. what is the procedure to change the name. Thanks in advance. Regards, Virendra Hi, Based on my understanding, when you try to publish a WebService in vs.net 2005, you will get precompiled DLL which is named APP_Code.dll. If I misunderstood, please feel free let me know. Based on my research, this is by design. You may make a simple test, by adding a new class into the web service, the IDE will prompt you that the file should be plac ...Show All

• Visual Basic Need script to Identify service account logons

  I would like to query/audit my servers and create a list of service accounts in use, and the user account used to run it. I looked at the wmi tools, Win32_SystemServices but don't see a method to list the user account in use. Can you tell me what objects I need to query Thanks ...Show All

• .NET Development Error deleting a TableAdapter from dataset.xsd

  When I delete or make a change to a TableAdapter the form to which I have this TableAdapter bound displays an error message and does not allow me to get to the form to change the Data Source property. Why is this and how do I make actions like this refactor or where do I change the code to disconnect this property Michael There is no error message - it just leaves all the code it generated when you created the TableAdapter and you need to delete it manually if you can find it. I would think that a good refractoring engine would delete all references to the TableAdapter too. ...Show All

• Visual Basic context menu event handler

  Hi everyone. I'm new to VB.net and I'm trying so hard to get this simple code to work.  I have a context menu and I dynamically added 4 menuitems to it.  My problem lies at the event handler of the menuitems.  In the event handler, I stored the clicked menuitem's text to a variable and displayed it with MsgBox().  It was stored and displayed correctly in the event handler. But when I displayed the variable's content outside the event handler, its not the same as the value I stored to it, as if it wasn't changed at all. But this is what confused me more.  When I placed a MsgBox("delay") before I displayed t ...Show All

• SQL Server deploy Cube to production server?

  Hello, how can I deploy the changes of cubes / dimensions from development to the production server cheers Tobias Hi, You can first archive (export) CAB with cubes from the development server and then restore it on the production server. Remember to process all the cubes before exporting them. You can use the msmdarch.exe program (it is located in the Analysis Services / BIN folder) or do the export/import directly from the Analysis Manager. Hope, this helps Best regards Ewa ...Show All

• Visual Studio XMLDocument to Crystal Report at Runtime

  Hi, I have developed a Windows application. One of the screen queries the data and processes it and creates an XMLDocument at run time. This XMLDocument object is transformed into Tree on the screen. I want to have this XMLDocument object print as a report. I have created XSD and tried mapping the fields on the report. That asks me logon to database specified in XSD. I have searched many sites for some information...but I was not able to get the information. Can any one please help me in generating a report from XMLDocument that is generated at runtime. Thanks & Regards Try this: There's an article on AspAlliance ...Show All