Aaron Silverwatch's Q&A profile

• SQL Server Refresh cube after data changed?

  After I created a cube in BI Studio, I added more data to the fact table, modified dimension table, and refreshed DSV. I got Refresh Data Source View message ‘No changes have been found’, but I didn’t see the data that I just added in from cube browser. (Database connecting and database structure didn’t change) My questions: Is refresh DSV only for database structure change Which step I was missing for refreshing cube data Thanks in advance. Thank you very much Dave. It is very helpful information. ...Show All

• Microsoft ISV Community Center Forums Speed up processing time Excel Macro

  I had some questions about Office and performance. I would like to figure out what specifically will affect the runtime of macros in Excel. Currently this user has a Dell Optiplex GX520 with the following specifications: IntelR PentiumR 4 Processor 640 with HT (3.2GHz, 2M, 800MHz FSB) 1.0GB DDR2 Non-ECC SDRAM,533MHz, (2DIMM) 80GB SATA 3.0Gb/s and 8MB DataBurst Office 2000 Pro She is running macros in large Excel spreadsheets (30 - 60MB) that currently take about an hour to complete and make it so she cannot use her computer. I need to find her a computer that will greatly reduce that time and allow her to do something else while it is running. So, I have several questions: Will a later version such as Office 2003 increase the speed Si ...Show All

• Visual Basic !! HELP !! Extracting frames in a video and comparing them THANKS ALOT!

  Hi, I need help in my project here. my project mate did this in C++, which no one else in the grp knows and so i need some help if anyone knows how to convert it to VB, if possible. The program is supposed to pick up a unattended object (like a bomb) and send an alarm (to like SMS or a PC). so it works like that. (what i understand he said, & seeing the C++ code). capture a background start capturing video average frames (eg. 10), so small movement is not picked up (think so) if pixels are the same for too long ( xx frames) - something isn't moving then send alarm he used C++ and open CV http://www.intel.com/technology/computing/opencv/ , http://www.cs.iit.edu/~agam/cs512/lect-notes/opencv-intro/index.html the things needed are a di ...Show All

• Visual C++ This code snippet makes no sense...

  I've come across some code syntax I've never seen. It compiled, but I don't know how, or what it even does! I've been reading a book about DirectX, and in one of the examples, this little piece of code was present: D3DXMATRIX *D3DXMatrixIdentity(D3DXMATRIX *pout); "D3DXMATRIX" is a type, of course. And "D3DXMatrixIdentity" is a function, of course. Now I don't see how this works. Okay, to break it down, first we have a type, which is D3DXMATRIX, then we have the indirection-operator (which I assume is a pointer), and then we have a function (perhaps a call) with a new D3DXMATRIX (pointer) as it's only parameter. How the heck does this work It isn't just a regular function-call. It isn't a function-call that' ...Show All

• SQL Server i really need some help!!!!!!!

  well......im from peru....i dont speak english too well.......but...i have the SQL express edition....but when i open it....i gotta to connect to a server.....but i dont have any server.....what do i should put to in "server name" and "authentication"...to star to use the SQL express edition.... well..if there are some grammathical mistakes....sorry...im learnin` english please answer me is an emergency!!!! Jaime servername AFAIK is usually: (local)\SQLExpress as for authentication as stated, depends on the type of authentication you have set up. If its Windows, then enter your username and password you use for Windows login. If its SQL user account, enter the username and password for the SQL user accou ...Show All

• Windows Forms menu item and AddHandler?

  Ok, new problem. I can not find where I did this before. Dyamically adding menu items: string sql = "Select * From myTable"; OleDbConnection conn = getDb(); conn.Open(); OleDbCommand myCommand = new OleDbCommand(sql, conn); OleDbDataReader myReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection); while (myReader.Read()) { mnuView.MenuItems.Add(myReader[0].ToString()); } myReader.Close(); I need to add a handler to each menu item for a click event. Check/uncheck and other actions I already have written. It's like right on the tip of my mind, but just can't see it... must be late. Thanks, Zath Excellent! Thanks. I didn't have the Menu ...Show All

• Windows Forms Tabcontrol and pages

  hi i am using TabControl with 03 pages and i would like to just show one page of the 03 page when i click in button.can that be realised because i tryes without success and how if that possible sorry to ask that because i am new.is rTab is the handel of the TabControl or what exactely N.B:i am programming with vc++ express ...Show All

• SQL Server Sample Report Deployment

  Hi all, I tried to deploy sample report to http://myserver/reportserver and I got the following error, can someone provide some tips TITLE: Microsoft Report Designer ------------------------------ A connection could not be made to the report server http://lasc06/reportserver . ------------------------------ ADDITIONAL INFORMATION: Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with the error message: -- <html> <head> <title> SQL Server Reporting Services </title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.1399.00" /> <meta name="HTTP Status" content="50 ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Getting codeplex to work with C# Express

  Hello, So, I have VS 2005 with the Team Project used with codeplex.com However VS2005 can not load Windows Game Application So Anyone got an idea on how to use codeplex with XNA and C# Express Regards, Chryso One of the restrictions on the Express products is that they do not have the source control plugins like the larger products, but to use codeplex with the express systems I would suggest using the Team Explorer Client. http://www.codeplex.com/CodePlex/Wiki/View.aspx title=Source%20control%20clients&referringTitle=CodePlex%20FAQ ...Show All

• Visual C++ Serializing Multiple Arrays

  In the following class, everything serializes except array,Level^,1>^ levels. It doesn't matter in which order it is declared:  [Serializable]  public ref class Dictionary  {  public:   int nlevels;   [XmlArray(ElementName="Lexicon",    Namespace="http://www.w3.org/2001/XMLSchema-instance ",IsNullable=true )]         array<Word^,1>^ lexicon; // = gcnew array<Word^,1>(1);   [XmlArray(ElementName="Levels",    Namespace="http://www.w3.org/2001/XMLSchema-instance ",IsNullable=true )]    array<Level^,1>^ levels;  };   In the generated XML file, Levels appears as one line: <Levels ...Show All

• Visual Studio Express Editions ASP in VB express 2005 - is it possible

  //Serious newby question alert!!// I've recently started working in vbe 2005 and I am very impressed. My next (sideline) project involves web-based forms that generate a report sent to my email account. I am jumping between learning PHP and ASP, with an obvious preference for ASP. Can I develop asp or asp.net projects in visual basic express 2005, or is there some other (preferably free) software that will allow me to do this Any other suggestions will also be welcomed. Regards, Nico PS: I have some limited Java experience, but would like to avoid using Java. There is a web application equivalent free edition for download from Microsoft  - MS Web Developer Express Edition&nb ...Show All

• SQL Server Publishing a report to the web error

  Does anyone know how to fix this error -I've tried allowing anonymous access to the site. -I've added it to my trusted sites. Error: The request failed with HTTP status 401: Unauthorized.    Thanks. Hi mr4100 Maybe try this. I believe that integrated security only allows 1 hop to pass credentials. You might want to try one of the following. 1) set the data sources property or the report to "Credentials stored securely in the report server" or "Credentials supplied by the user running the report" or 2) set up a shared use a shared data source with "Credentials stored securely in the report server" or "Credentials supplied by the user running the report" ...Show All

• Windows Search Technologies WDS 3.0 RTW gives error trying to index Outlook Express message store

  When WDS 3.0 RTW tries to index the Outlook Express message store, I am getting the pop-up error: "Outlook Express could not be started. The application was unable to open the Outlook Express message store. Your computer may be out of memory or your disk is full. Contact Microsoft support for further assistance. (0x80004005, 183)" I have plenty of memory and the disk is not full. Does this version index OE Any idea how to resolve this This problem is happening on both my home and work computers so this is not an isolated incident. They are both fully patched Windows XP SP2 machines. I have several email accounts configured in OE, two Hotmail and one IMAP. The indexer will start to process the OE ...Show All

• SQL Server Sql Server Replication

  Hi, I'm curious to find out is it possible to make a Multi Master-Multi Slave replication system with sql server 2005. I'm not very good at db's and I'm a bit lost with mirroring things and some other things. The main problem in my case is that masters are connected each other via internet which I have to prepare a asynchronus replcation system in this. Let me explain what I mean with an example. Let's say we have two servers one at USA and other UK. They are both masters and both slaves. When entering a data in USA, UK becomes the slave and replicate the data from USA and vice versa. I'm curious about to find out is this possible with SQL Server 2005 What are possible problems that can occur in this case (not hardware problems or server o ...Show All

• Visual C++ Error C2440 -- Visual Studio 2005

  I am getting a compile error for the following statement in my code const CString gc_bstrKey = L "rep" ; The error got is as below error C2440: 'initializing' : cannot convert from 'const unsigned short [15]' to 'ATL::CStringT<BaseType,StringTraits>' with [ BaseType=char, StringTraits=StrTraitMFC_DLL<char> ] Constructor for class 'ATL::CStringT<BaseType,StringTraits>' is declared 'explicit' with [ BaseType=char, StringTraits=StrTraitMFC_DLL<char> ] But this code compiles fine in Visual Studio .NET 2003 . Why is this happening Yes I tried it in both VS2005 and VS2003 and it compiled in both. I would suggest that ...Show All