ChinaTiger's Q&A profile

• SQL Server Drillthrough results conditionning

  Hi, I would like to be able to set a condition to define the results of my drillthrough in AS 2005. Let's use an example to explain what I am trying to do : We got a Cube with 2 dimensions ( Time, Products ) and a measure ( Sales Amount). In our cube we have stored detailed informations about our vendors, customers and stores. The following statement should return all rows from the columns Customers, Vendors and Stores names. DRILLTHROUGH SELECT {[Time].[Time hierachy].} on Columns, {[Products].[Product.hierarchy]} on Rows FROM My_Cube WHERE ([Measures].[Sales Amount] RETURN [Fact].[Sales Amount] ,[$Vendor].[Vendors name] ,[$Customer].[Customers name] ,[$Stores].[Stores name] I wonder if it is possible to set a conditi ...Show All

• .NET Development Asp / Ado databinding to Sql database

  I am trying to build our web applications in a VB Website with .asp I am using Visual Studios 2005. I have no clue where to start. Can someone point me in the right direction. I have books and been looking around on the web I can't find anything possible. Ray, Have a look on MSDN topic http://msdn.microsoft.com/library/default.asp url=/library/en-us/ado270/htm/mdconusingconnectionobj.asp which applies for ADO 2.8. If you are planning to use ADO.Net, then take a look at http://msdn2.microsoft.com/en-us/library/ms254507.aspx . Both articles have sample code that shows how to connect to a SQL Server. Jimmy ...Show All

• SQL Server Data mining cube with 0-value facts

  I'm defining a mining structure against an OLAP dimension. The continuous value that I'm using both as input and for forecasting represents the time to complete a certain process. There's something that strikes me as if it could be a problem, but I'm not sure. Our fact table has multiple columns (with multiple correponding measures in the cube). The "time-to-complete" measure is only populated on some of the fact rows - the rows that represent completion information. Other rows represent other information, and the "time-to-complete" value is set to 0. This works fine for cumulative time-to-complete and average time-to-complete, but it seems like it could mess up data mining. Will those 0-value facts skew the mining res ...Show All

• Visual Basic Web Reference Error

  I am using Visual Basic 2005 Express Edition 8.0.50727.42 (RTM.050727-4200) and .NET Framework Version 2.0.50727. I am trying to add a Web Reference in my Project, the reference is an Amazon Web Service titled Amazon E-Commerce Service. The WSDL page in XML is http://webservices.amazon.com/AWSECommerceService/AWSECommerceService.wsdl . When I try to add the above web service using Project -> Add Web Reference and type the above URL, I get the following error: There was an error downloading 'http://webservices.amazon.com/AWSECommerceService/AWSECommerceService.wsdl'. The underlying connection was closed: An unexpected error occurred on a receive. Unable to read data from the transport connection: A system call that should ...Show All

• SQL Server NT AUTHORITY\ANONYMOUS LOGON'

  I read a lot of artical but didn;t find a solutio to this problem. I have Windows 2003 SP1 install Reporting services 2005 I have other Windows 2003 SP1 server with SQL 2005 database. I set kerberos delegetion control on the server in the AD I also run the command cscript adsutil.vbs set w3svc/1/root/NTAuthenticationProviders "Negotiate,NTLM" on reporting services server but still getting this error message. Any help w3wp!processing!7!8/30/2006-00:00:01:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'MyDB'., ; Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection t ...Show All

• Visual Studio 2008 (Pre-release) How to setting Background Property to a LocalResource

  MyControl.Background = SystemColors.ControlBrush; I want the change the above line to reference a LinearGradient brush I created. < LinearGradientBrush EndPoint = " 1,0.5 " StartPoint = " 0,0.5 " x:Key = " OrangeGradBrush " > < GradientStop Color = " #FFD29A48 " Offset = " 0 " /> < GradientStop Color = " #FFFFFFFF " Offset = " 1 " /> </ LinearGradientBrush > How would I do that in the C# code behind file I see how to do it in the XAML but I need to add it to the code behind since the background color is dynamic depending on some business logic. Thanks! Not clear from yo ...Show All

• Visual Basic Recording Sound (internally)

  I wish to 'record' sound into a wma,wav,midi or mp3 file, not external sound say from a microphone etc but sound played through the computer speakers on your own system however I don't know of any COM components that allows this. Is there any way to do this Thanks Liam.notnettoday There is a native C++ sample for doing this using the DirectSound api's that ships with the DirectX SDK. Unforutnately, I'm not ware of any samples on how to do this from managed code. If you are comfortable working with native code then you can check out the DirectX SDK here: http://msdn.microsoft.com/directx/ Writing somehting like this in VB will probably involve a large amount of interop. -Scott Wisniewski ...Show All

• .NET Development Check if object implements generic interface

  I have some object. I need to know, implements this object IEnumerable<T> interface, and if so, get type of T. Have any one ideas on how to do that has found one way to do that: object o; foreach (Type t in o.GetType().GetInterfaces()) { if (t.IsGenericType) { if (t.GetGenericTypeDefinition() == typeof(IEnumerable<>)) { // o implements IEnumerable<T> foreach (Type tt in t.GetGenericArguments()) { // tt is Type parameter } } } } may be is there more regular way ...Show All

• SQL Server Changes related to PDF in SQL Server 2005 Reporting Services

  Hi All, I am working on SQL Server 2005 reporting services. In reports I am required to make changes related to exporting report to PDF. Following are those changes: 1) Change PDF export page format to letter from legal 2) Fix page break to ensure that all details related to a specific issue are viewable on the same page In reports exporting is done through the control given by services itself. So can any one please guide me regarding how this changes can be done. Please help me ASAP... Thanks.... For (1), it seems like you should be able to just change the page size of the report. Or do you need to change the size just for PDF If you are using URL access or SOAP, you can specify page siz ...Show All

• SQL Server Error installing SQL Server 2005 SP1 - Reporting Services - log excerpt included

  Hello, any information about this issue would certainly be appreciated! I've been trying to install SP1 for my SQL Server 2005. There is a failure for the reporting services which appears in the following text from the log: -------------------------------------------------------------------------------------------------- MSI (s) (7C:38) [13:43:05:402]: Note: 1: 2360 MSI (s) (7C:38) [13:43:05:402]: Note: 1: 2360 MSI (s) (7C:38) [13:43:05:402]: Note: 1: 2360 MSI (s) (7C:38) [13:43:05:402]: Note: 1: 2360 MSI (s) (7C:38) [13:43:05:417]: Note: 1: 2360 MSI (s) (7C:38) [13:43:05:417]: Executing op: CacheBaselineFile(Baseline=0,FileKey=RSWebUserInterface.dll.B7E12617_911F_413B_9E42_083AE8682587,FilePath=C:\Program Files\Microsoft SQL Server\ ...Show All

• Visual C++ Errors when compiling a VC6 project in VC2005

  Hi All, I try to compile a project built several years using VC++6 in VC++ 2005 and got following errors when trying to build the project after clearing out all the other errors in *.CPP file: error C2248: 'CObject::CObject': cannot access private member declared in class 'CObject' file afxwin.h line#1814 The line#1814 in afxwin.h is the end of class definition for CCmdTarget. This is a GUI interfaced application. I read somewhere that this might be caused by some private constructor in CObject. But the problem is the error did not even show me which .cpp file has the problem just pointing to the afxwin.h file and I have close to 100 .cpp file in this project. Any help is appreciated. Are ...Show All

• SharePoint Products and Technologies Is anyone using visual studio extensions for wss?

  I can't seem to find docs on how it works. I recently posted asking how to get another assembly added to the solution that vsewss creates, but got no responses. There have got to be people somewhere that know about this, right You can check the WSS v3 SDK regarding solution files. Some short points: the DDF (Diamond Definition File) determines what files are added to WSP file (really just a CAB) and where they are placed in WSP. The Manifest.xml tells STSADM.EXE where to place the files contained in the WSP file on the server (/bin, GAC, controltemplates etc) hth AndersR ...Show All

• Visual Studio Express Editions embedding .swf to vb.net forms

  can someone give me the codes needed to embed an swf file ( a flash animation for the banner) in a window form.. thanks.. im using the version 8, macromedia pro... thanks. Put your swf file in My Documents. Rename it sample.swf. Open notepad. Type <html> <body> <OBJECT CLASSID="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" CODEBASE="http://active.macromedia.com/flash5/cabs/swflash.cab#version=5,0,0,0"> <PARAM NAME="MOVIE" VALUE=" sample.swf "> <PARAM NAME="PLAY" VALUE=" true "> <PARAM NAME="QUALITY" VALUE=" best "> <PARAM NAME="LOOP" VALUE=" true "> <EMBED SRC=" sample.swf " WIDTH=& ...Show All

• Smart Device Development Sync data between desktop and pocket pc

  I have a pocket pc application for pocket pc 2003 developed usign Vb .NET.It uses a Sql Mobile database (.sdb). I have desktop version of the same application using an access database. I need to transfer the data between the desktop and the pocket pc app.(ex. update the access database based on entires in the mobile database and vice versa). replication and migration are not an option since I do not use Sql server 2000 on the desktop side. Any help appreciated Thanks, Andrea, Any chance you could summarize the "other options" besides ActiveSync I'd ultimately like to offer a synchronization options that avoids using ActiveSync and Exchange Server but am not clear how to proceed. Robert W. ...Show All

• SQL Server Difficult Query. Is it possible?

  Hi, I am looking for a type of aggregate function for a string. Instead of finding a Max value or the average of a column, I would like to build one string value holding the aggregate. Example: Source data RecordID PersonID Name Course Score 1 1 Fred Maths 70 2 1 Fred Science 78 3 2 Mary Maths 65 4 2 Mary Science 60 5 2 Mary History 85 I would like my query to return the following resultset: Name Scores Fred 70; 78 Mary 65; ...Show All