xypher21's Q&A profile

• .NET Development analysis services 2005 tutorial

  I am working through the tutorial and have designed a cube in the Visual Studio for BI. while trying to access the browser in the analysis services cube design. It states a conneciton can not be made and to ensure the server is running which it is. A click on the detailed error information and it gives me the following: TITLE: Microsoft Visual Studio ------------------------------ A connection cannot be made. Ensure that the server is running. ------------------------------ ADDITIONAL INFORMATION: No connection could be made because the target machine actively refused it (System) ------------------------------ BUTTONS: OK ------------------------------ Any ideas,suggestions, tips ...Show All

• Visual Studio dynamic column header depending upon the value of column

  Hi, dear developers We have a table in which there are 50 fields. Some fields can be empty or zero in all rows. We want to eliminate such rows ( zeros for all the rows) dynamically, when the report is generated. That means we want to put column header and column value for all the rows only if the sum of that column > 0 in the table. So that in report the area should be blank when respective field are (zero /empty) It should adjust the fields automatically, with non empty or non zero fields only duriing run time . How this can be done incombination with crystal report 9.0 and vb 6.0 This is very urgent please help Thanx for the help in advance ...Show All

• Smart Device Development Who has a PPC-6700 Sprint AudioVox Mobile 5 (Can I use GPS?)

  I have the Sprint AudioVox PPC-6700 and I know that it has the built in GPS chipset but everywhere that I search I can not find out how to actually access the API. There are a few of the GPS API references throughout msdn & msdn2 but none have an actual walk through. It is very easy to access the phone API's and contact lists/appointments and whatnot but the GPS is not to be found. As far as the GPS is conserned one could argue that it isn't ment to be programmed or something but the fact is that in all documentation it says that e911 can use the gps and also applications that need your location (such as movie times or resteraunts in your location). I really need to find out how to manage this out even with just a simple quord ...Show All

• SQL Server How to list all tables ordered by their size within a SQL Server 2005 database?

  Hi, all, Would please any expert here give me any guidance and advices for how to list all tables sorted by their size within a SQL Server 2005 database Thanks a lot in advance for that. With best regards, Yours sincerely, Hi, A similar kind of query I've seen on a site. In the example given by the author of the query, he used Dynamic Management Views. You can find the original query from here http://www.extremeexperts.com/SQL/Scripts/FindSizeOfTable.aspx As per your requirement, I have made some changes to the query. Here it is WITH table_space_usage ( schema_name , table_name , used , reserved , ind_rows , tbl_rows ) AS ( SELECT s . Name , o . Name , p . used_page_count * 8 , ...Show All

• Visual Studio 2008 (Pre-release) No master page?

  It seems that there is no mater page in WPF. And someone has advised to use Frame. But now I am developing several pages. These pages share a list of properties(These properties just belong to the pages, so I don't want to store them in Application Properties). When I extract them to a BasePage, and make those pages inherited from the BasePage, I get an error "Partial declarations of 'Page1' must not specify different base classes " I am afraid this can't not be solved use Frame. So, do I get a wrong way How to do that Thank you. Dear LeoXue, Try using ControlTemplates if you do not want frames. HTH, Suprotim Agarwal ...Show All

• Visual C++ Win 32 Wrapper Class

  I was looking around for a while on different forums and sites and couldn't find any help to my problem. I'm trying to make a windows wrapper class. I'm using VS 2005 and doing it in visual C++. I'm declaring my handle as a private variable inside the class. private : hWnd; Then in my functions I have HRESULT cWindows::WinCreate() { hWnd = CreateWindow( "wndName" , "" , WS_OVERLAPPED, 0, 0, 600, 480, NULL, NULL, hInst, NULL); if (!hWnd) {return E_FAIL;} return S_OK; } hInst is a variable that I keep stored in the privates of my class and pass it in through the constructor. The WNDCLASS is registering itself fine, but whenever I try to create the window, I keep getting a a NULL ...Show All

• SQL Server hosting SSIS packages where?

  After i create a SSIS package, where can i put it or store it in the SQL SERVER 2005 so that i can execute it later on Hi, The option to do this is available once you have built you're project and you have done this whilst the CreateDeploymentUtility is True. All you then have to do is go to the deployment folder (usually in the bin directory) and run the .SSISDeploymentManifest file. This will give you all deployment options including where to store your package. This link gves some info on how to execute the packages programmatically: http://msdn2.microsoft.com/en-us/library/ms403355.aspx Hope this is of use to you. Cheers, Grant ...Show All

• Visual Studio Express Editions Stocks Program

  Please, I’m trying to create a program to manage my stocks. Yahoo provides CSV files for day and historical informations, that can be downloaded. For exemple, I took PETROBRAS stock ( http://br.financas.yahoo.com/q/hp s=PETR4.SA ). The historical data can be downloaded from: http://au.rd.yahoo.com/finance/quotes/internal/historical/download/*http://ichart.finance.yahoo.com/table.csv s=PETR4.SA&a=0&b=3&c=2000&d=10&e=23&f=2006&g=d&ignore=.csv were a is the initial month, b the initial date, c the initial year, d the end month, e end day, and f the final year. But it only gets 200 days max. So, if you like to have all historical data, you should do splited downloads, and compare if the informatio ...Show All

• SQL Server Problem of unicity constraint in a data flow

  Hi, I'm trying to import data from an xml file into a table in my database and I have a problem of unicity constraint in my table. Here is an example of the data flow in my file : CITY LOCATION_ID CATALOG_SAISON PARIS 12 S06 PARIS 12 S07 NEW YORK 15 S06 BERLIN 14 S08 The primary key in my destination table is the two first fields CITY/LOCATION_ID, so I would like to have only one CATALOG_SEASON per CITY/LOCATION_ID. That's why I want insert the following flow in my destination table: CITY LOCATION_ID CATALOG_SAISON PARIS 12 S06 NEW YORK 15 S06 BERLIN 14 S08 In T ...Show All

• Visual Studio Express Editions One Form part of another form

  i have two forms. One only contains the menu bar and the other performs databse modifications. how can i get the 2nd form to be a part of the other form...itz like having the 2nd form inside the 1st form... for example...here's the code in my menustrip Private Sub XLToolStripMenuItem1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles XLToolStripMenuItem1.Click MenuStrip1.Enabled = False F_NEW.Show() End Sub This code will show 2 forms...i want the F_NEW form to be inside the 1st form...how can i do that help please...thank you Sounds like you need the first form to be an MDI container and the second form to be an MDI child form. Set the IsMDIContainer property to ...Show All

• SQL Server Schedule backup SQL Server 2000

  Hi all, How can I schedule backup in SQL Server 2000 for ALL databases With SQL Server 2005 I can create maintenance plan to do this, but in the 2000 version I don’t know. thanks!!!! Have you tried one of the many different online backup solutions for sql server there's one from 4backuponline.com that works with sql server and it has been working beatiful for me for that last couple of months. You set it up once and you can forget about it. ...Show All

• Visual C++ "Expand All" Out of control??

  I have a pretty large solution, with something like 75 projects, containing hundreds (maybe thousands of folders), which collectively contain thousands of source files. Lately, I have become INCREDIBLY annoyed at what appears to be a rogue "feature" of VS2005. Sometimes it happens when I just close a document, sometimes it happens if I click on the output window... but it just arbitrarily decides to expand everything in the solution explorer, which locks up the IDE for several seconds while it performs the operation. Right this second, I have an unresolved external symbol linker error in my output window. If I click on that line, it does this. Beyond that, I haven't been able to pin down exactly what causes it. It always happens ...Show All

• Visual C# NullReferenceException

  System.NullReferenceException: Object reference not set to an instance of an object. at article.article.addarticle() ASPX file: void add(Object Sender, EventArgs E) {  if (butimage.PostedFile != null)  {   strTemp = DateTime.Now.ToString();   strTemp = strTemp.Replace(":","");   strTemp = strTemp.Replace(" ","");   strTemp = strTemp.Replace("-","");   strImage = "D:/c/upload/" + Session["name"].ToString() + strTemp + ".jpg";   butimage.PostedFile.SaveAs(strImage);  }   article art = new article();  string temp_subject;  temp_subject = Server.HtmlEncode(subject.Text);  temp_subject = temp_subject.Replace("'","`");  art.subject = ...Show All

• Visual Basic How can I mute Wave Sound Without Muting System Sound ?

  HI Friends !! I am able to Record Sound in VB 6.0 and also can play a sound. But now i want to Mute this sound without Making My Sytem Mute ! Means, that sound shuould be muted but my system sound must not be. Please Help Me!! Emersion T hese forums are for VB.NET and there are better places to find answers for older versions of VB. Maybe the VB6 newgroups - http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.vb.general.discussion&lang=en&cr=US Or perhaps the VB6 resource center http://msdn.microsoft.com/vbrun/ or perhaps www.vbcity.com may be useful places to search for answers on VB6 related questions. Hopefully this helps. ...Show All

• SQL Server Closed conversation endpoints not being purged

  We have been having a problem with service broker for quite a while now and searching on these forums and more generally on the web has not yielded any kind of answer... Our application utilises service broker within a single database (there is no cross database, cross instance or cross server communication). There are approximately 12 queues which are used to varying degrees. A few of the queues have a throughput rate in the order of up to 100s per minute at peak periods. In some scenarios we are able to make use of persistent conversations but the majority of messages are sent on their own conversation or in small batches on their own conversation. Some time ago we found that the database was growing in size more than expected d ...Show All