hrd2hndl67's Q&A profile

• SQL Server Cache calculated member

  hi, i have several calculated mebers in my cube that take a long time to be evaluated. so i would like to evaluate the the calculation during processing my cube and store it directly in the cube. So far i only found the "CACHE" statement that would fulfill my needs but i dont get it to work correctly my calculated members looke like this; CREATE MEMBER CURRENTCUBE.[MEASURES].[Kaufpreis je Wohnflaeche m2 Max] AS MAX({descendants([Immobilien].[Geographie].currentmember, [Immobilien].[Geographie].[Immobilie], self)},[Measures].[Kaufpreis]), VISIBLE = 1; the [Immobilien].[Geographie]-Hierachie looks like this: Immobilien Land PLZ Immobilien Immobilie what would the CACHE-Statement look like to cache this calculated m ...Show All

• Audio and Video Development How to use a specific media source component

  Hi All! I am looking for a way of using a specific media source component. When I try to play back a WAVE file on the BasicPlayBack sample, SourceResolver loads WavSource.dll in order to create a MediaSource component. 【Question 1】 In order to create a MediaSource component, how does SourceResolver choose which media source dll to be loaded 【Question 2】 Is there any way for our app to specify a media source dll to use Is there any way not to make other apps use such as MERIT_DO_NOT_USE of DShow filter My best regards. Thanks. A1. The appropriate DLL, at DllRegisterServer (regsvr32) time, will have put an entry in the registry to associate itself with the extension in question (".wa ...Show All

• SQL Server SQL Server Session State - using a 1.1 database schema for 2.0 session state storage

  The 2.0 version of ASPSTATE is slightly different than the 1.1 version in that one table has one additional column and another table uses a different data type and size for the key. The 2.0 version also has a couple additional stored procedures. We'd like to manage just one session state database if possible so we're trying to figure out if Microsoft supports using the new schema for 1.1 session state access (it seems to work, but our testing has been very light). Is there any official support line on this If not, can anyone comment on whether or not you'd expect it to work and why Thanks. You can use the 2.0 ASPState database schema for both 2.0 and 1.1 ASP.NET applications. "Some o ...Show All

• Visual Basic Inheritance run amuck!!!

  I use CodeDom classes and VBCodeProvider to generate code and create assemblies. After the upgrade to Visual Studio 2005 Beta 2, I started getting the following error. Class '[ class name ]' must either be declared 'MustInherit' or override the following inherited 'MustOverride' member(s): Note that there is no member name following the error message. If I create a project and add the generated files to the project, it compiles fine. Is this a possible bug Please help. Thanks... I'm now having the same problem as well. I've started with a class derived from UserControl and marked as MustInherit, called BaseUserControl. I then have another derived from BaseUserControl that is also marked as MustInher ...Show All

• Software Development for Windows Vista Close, Minimize and Maximize buttons

  Hi, I have a strange but not so strange request. Why the close, minimize and maximize buttons on the caption are all together on the right side Sometime I close a window while I was wanting to minimize it. Wouldn't it be a nice idea to put the minimize and maximize buttons on the left corner and leave the close one on the right I know that this would have a deep impact on Windows but: this solution is more ergonomic Vista has a new user experience so it's the right moment to do this change What do you think Thanks Diego ...Show All

• .NET Development Why doesn't my C# form show the contents of the database?

  Hi All, I'm using VC2005 in C# trying to create a windows app that displays the contents of the tutorial northwind.mdb. I've followed the tutorials and created a dataset and dragged the customers column onto the form and it all compiles and runs fine but none of the elements on the form get filled in with the contents of the database, also the BindingNavigator has no items to navigate. What am I doing wrong and how do you make the app automatically load in the northwind database and display the contents on the form I've just tried and experiment as I forgot to mention my OS is XP 64 and is proving a right pain in the ***. On the odbc data sources none of the user DSN options work and all give errors when you try and c ...Show All

• SQL Server SELECT with INSERT

  Hi. I have 3 tables: Table1: AccountInfo AccountInfoID bigint <-- primary key AccountNumber char PostingDate datetime TransactionReferenceNumber char SequenceNumber numeric Table2: LodgingSummary LodgingSummaryID bigint AccountInfoID bigint <-- foreign key LoadTransactionCode tinyint NoShowIndicator decimal CheckInDate datetime DailyRoomRate decimal TotalOtherCharges decimal Table3: Load_LodgingSummary LodgingSummaryID bigint LoadTransactionCode tinyint AccountNumber varchar PostingDate datetime TransactionReferenceNumber varchar SequenceNumber numeric NoShowIndicator numeric CheckInDate datetime DailyRoomRate numeric TotalOtherCharges numeric I need to insert the AccountInfoID from AccountInfo along with ...Show All

• Visual C++ "{466940} normal block at" display after application closes in output window.

  hello there, i have a problem. i have a direct3d mfc app.. its working perfectly everything works just gr8. however when i close my app. the window disappears and i can see in visual studio output tab i can see 10 of thounsands lines of: " Data: < > 00 00 80 3F 00 00 00 00 00 00 00 00 00 00 00 00 {466940} normal block at 0x033CA1E8, 64 bytes long." repeatedly. what could that be it stays for more than 3 mins displaying them, once my one! i ran my app and closed it, and i opened my ie to write this post, logged in, and typed this out, and it is still displaying them. what could be the problem ok just a quick question befor ei test ur last message. u said eariler that i have to put the: _Cr ...Show All

• Visual C# adding new reference location but still show old path

  Hello, I have a solution with several projects. I try to add to a project a reference at its new location but on its properties, it's still showing me its old path. I try many combinations to remove and add the reference but still facing the same problem. any suggestion thank you Check all reference paths of your project, and if you find old assembly there remove it, or if don't need reference path(s) where old assembly is, remove that path, or replace it with new one. ...Show All

• SQL Server SQl 2005 Server Not accesible through ASP.Net 1.1 Code

  I am trying to connect a production SQL Server 2005 which is under firewall through an Application written in ASP.Net 1.1 and I get error "SQL Server not available or Access Denied". I am able to connect to the Server through SQL Mgr also using the same Code and Web.Config file I am able to Connect to the SErver using ASP.Net 2.0. I am able to run the application for a SQL Server 05 which is in the same domain as of the Application Server. My Application is not working only when I use ASP.Net 1.1 code for the Remote SQL Server 05 which is under Firewall. But for the same Server ASP.Net 2.0 works fine. I have searched a lot for the problem and port No, DBNETLIB update is also tried. Please let me know if anyone has ...Show All

• Visual Studio Express Editions RichTextBox - two questions.

  Hi I am using 3rd party dll to receive string messages and displying them in RichTextBox. How can I limit the amount of lines to be in specific number (let's say 100) and in case 101 message arrived delete the first one and insert the new message at the bottom How can I autoscroll the scrollbar in the RichTextBox to the last message that arrived (on every message that arrived the cursor move to the first line). Thanks in advance Asaf. Example of a scrolling richtextbox with alternating colors....caret always stays at top of rtb: Private Sub Button1_Click ( ByVal sender As Object , ByVal e As System . EventArgs ) Handles Button1 . Click Static x As Intege ...Show All

• SQL Server sp_executesql performance

  Hi All, The following is cut from SQL profiler, database is SQL 2000 SP4. Query 1 takes almost zero time and 26 reads. Query 2 takes 16 millsecs and 2862 reads and the only difference is that Query2 has parameters. I have run the query's multiple times and in different order and the results are the same. My reading of the documentation says that Query 2 should be faster due to not having to recreate the execution plan. If the execution plan is a bad one and is cached how do I remove it. Is there anyway to force a recompile or am I know in stored procedure territory. Can anyone give me an explanation as it looks like we should be changing our code to use literal's where ever possible rather than parameter substitution. TIA SQL: ...Show All

• SQL Server How To? Instant Data File Initialization

  I haven't been able to find much information about how to enable Instant Data File Initialization. "Instant file initialization is only available if the SQL Server (MSSQLSERVER) service account has been granted SE_MANAGE_VOLUME_NAME. Members of the Windows Administrator group have this right and can grant it to other users by adding them to the Perform Volume Maintenance Tasks security policy. For more information about assigning user rights, see the Windows documentation." Does anyone have a script or instructions on how to do this Any suggestions or recommendations are greatly appreciated. Thanks in advance, Aaron ...Show All

• Visual C# DefaultValue Attribute for property of type Color

  I've tried about 100 different ways of specifying a default value for a Color property to be displayed in a PropertyGrid. None of them have worked. How do you specify a default value for a Color property using the [DefaultValue()]attribute Use the encoded hex value: [ DefaultValue ( typeof ( Color ), "0x808080" )] The above value will set the default to gray. Basically you can pass any string to this attribute that can be converted to the target type. Internally it uses the types TypeConverter to convert the string to the value. If that works then the default value will be set. For Color you can use strings containing decimal values, octals, &H hex values, etc. in addition to nam ...Show All

• Windows Forms ActiveX control with RegFree

  Hi, I am using Click Once deployment to deploy my test application which has a browser control on a Winform. The browser control points to a asp page served from the server which in turn downloads an active X control. I have included all the typelibs for the activeX control which the web page will download in my clickonce deployment and I use RegFree COM (Isolated = true) for the typelibs. When I try to run the application, under a minimum privilege user account, it gives an error saying that the "Page provides potentially unsafe information to the activeX control". If I enable the IE security to allow scripting and initializing activeX controls which are not safe, everything works fine. Thanks ...Show All