Malcolm McCaffery's Q&A profile

• SQL Server OLAP server or SQL Analysis Service

  Hi I am new to SQL Server and not quite understand the difference between OLAP server or SQL Analysis Service. Are they referring to the same thing An user asked me to confirm that the OLAP server is active on a server running SQL Server 2005, what do I need to check. The Analysis service is up and running, does it mean it is OK Please advise. Thanks. OLAP (Online Analytical Processing) is a generic term for the process of analyzing stored data. SQL Server Analysis Services is a product which performs the Analytical Processing for you. If Analysis Services is up and running then you're OK. ...Show All

• Visual Studio Tools for Office ClickOnce deployment of VSTO2005 Outlook Add-In

  Is this possible We do not have a true ClickOnce deployment of VSTO2005 Outlook Add-in. However it can be deployed using the publish wizard. You can read about it in the following white papers VSTO Deployment · Overview http://msdn.microsoft.com/office/default.aspx pull=/library/en-us/odc_vsto2005_ta/html/officevstowindowsinstalleroverview.asp · Walkthrough http://msdn.microsoft.com/office/default.aspx pull=/library/en-us/odc_vsto2005_ta/html/officevstowindowsinstallerwalkthrough.asp Thanks, Pallavi ...Show All

• SQL Server Incorrect PageAudit Property

  Hello, after a fatal server crash (with no backups!!) I have tried to re-attach a database but I get the following message; " Msg 5172, Level 16, State 15, Line 1 The header for file 'E:\Database.mdf' is not a valid database file header. The PageAudit property is incorrect." The database files ( both mdf & ldf ) where recovered from a file system copy which was made while SQL Server 2005 was still running. The files where copied with Symantec Backup Exec (10d). Is there any way that the database can be recovered from these files (I have tried a few 3rd party tools ie, Apex SQL Log & Recovery for SQL Server, but none of these where successful ) Would Miscorsoft Product Support be able to recover any dat ...Show All

• Windows Forms drag&drop doesn't work at first try

  Hi I wrote a little application and i need to drag&drop the contents of a cell of a datagridview to other applications. I looked at the msdn examples and came up with the following code: private void dataGridResults_CellMouseDown(object sender, DataGridViewCellMouseEventArgs e) { if (e.ColumnIndex >= 0 && e.RowIndex >= 0) { Size dragSize = SystemInformation.DragSize; dragBoxFromMouseDown = new Rectangle(new Point(e.X - (dragSize.Width / 2), e.Y - (dragSize.Height / 2)), dragSize); } else dragBoxFromMouseDown = Rectangle.Empty; } private void dataGridResults_CellMouseUp(object sender, DataGridViewCellMouseEventArgs e) { dragBoxFromMouseDown = Rect ...Show All

• SQL Server Where is Query Analyzer in SQL Express?

  I know that SQL Express includes a similar tool like Query Analyzer in the SQL Management Tool but I just can't find it. Would anyone kindly point it out please When you open Management Studio Express you can create a New Query a number of different ways. New Query is akin to Query Analyzer. Regards, Mike Wachal SQL Express team ---- Mark the best posts as Answers! ...Show All

• Visual Studio 2008 (Pre-release) UserControl call window method

  I need a UserControl to call a method on its parent window. What are my options Can I bind a method on the usercontrol to the parent Or is there some other way Brian I'm not sure if I understand your scenario. Do you mean that you have a UserControl that is shown in a Window. Lets call this window as Window2. Window2 has an owner Window, Window1. Now, from the UserControl, you want to call an API on Window1 ...Show All

• Visual Studio 2008 (Pre-release) Value Converter Question

  I am displaying displaying data in a combo box. This data is being retrieved from a web service. The service returns a customer name and a customer ID. I want to display the customer name in the combo box, and be able to retrieve the associated customer ID. I have been told that I can accomplish this using a Value Converter, but I can't find any good examples of how to do so. Any feedback, or, better yet, and example, would be greatly appreciated. Thanks! depending on how your collection is you can setup the combobox so that Displaymemberpath will be name and selectedvaluepath will be ID. you can get the selectedvalue property will have the ID of the customer selected. you dont need converter ...Show All

• Visual C# adding SQL db

  i have created a web app at www.syscpupower.com , I would like the results of the required feild to be saved to a sql database along with a date and time stamp. i have only created a sql database, do i need to create a table and how do i get the info from the feild into the database If you would like to see the code behind please reply to the post... any assistance would be great! Thanks Danny G Guillory Jr Hi Danny, A database can be looked at as a collection of tables and other objects (like views, indexes, ...). The database itself is just a name for the entire group of objects. The actual data is stored in tables. So, you do need to have at least one table, to store your data. To store your data into the table, ...Show All

• Windows Forms UserControl with ComboBox

  My aplication needs a usercontrol consisting a combobox. So I have to provide the commonly used propertiesfor the comboBox for this usercontrol as well. I build this UserControl DLL and using in some other Windows Forms, but then some problems arises. I have few problems in that: 1. There is a property called "FormatString", I have attached the editor "FormatStringEditor" also with this while declaring this property. But when I try to use this property in the "property-pane" I am getting an error Object Reference not set to an instance of an object" 2. I have also exposed the property for "Text" and "Items" and attached these properties to the ComboBox corresponding prop ...Show All

• SQL Server Help me remind me why I never run a package from a package

  Hi, For some reason, I stay away from executing a package from a package. I guess that this is because I have experienced issues with this in the past and because I have read some articles in that forum that pin point specific issues when you do this. So far I try very hard to either combine all I need in one package or I break it down in multiple packages and use SQL Agent to drive the package chaining. Does anyone has a better experience with SP2 as far as running child package from parent package is concerned Any bugs remaining out there Thanks, Philippe Running SP2 here, no problems at all with parent-child package operation. The key factor is using a package configuration for s ...Show All

• Visual C++ header problems

  hi, I'm a new visual studio programmer... I installed the boost library, I set the BOOSTPATH I have a poject with sources files and headre files, (that use boost) I have added $(BOOSTPATH) in the Additionnal Include Directories of the Project Property Pages. Fisrt : that BOOSTPATH does not spread in all sources files... I got the message error : "fatal error C1083: Cannot open include file: 'boost/bind.hpp': No such file or directory" and this for all the source files including a boost header file. Second: How do i do (what option , what field ) to include a header file in an another one message error : in header_file.h "Cannot open include file: 'directory1/directory2/header_file2.h': No such file or directory" thank ...Show All

• Visual Studio MDAC Mismatch after installing VS 2005 SP1

  Help. I am trying to run a VB6 application on my computer and I am getting a run time error 3706 - Provider Cannot be found. It may not be properly installed. I have installed this application on other computers in the office and it runs fine. Mine is the only one with VS 2005. I installed the VS2005 SP1 a few days ago. I downloaded the MDAC component checker, it is showing a mismatch in components (I have included the results below). I tried to run the latest version of MDAC_TYP.EXE. It informed me that I cannot run it on my version of the OS (XP SP2). Furhter research on MSDN tells me that the only way I can install it is to install SP2 (which I did a while back). Re-installing a service pack at this time scares me. Is there ...Show All

• Visual Studio changing frames into iframe in index.html

  When you want drop frame from index.html and substitute with iframes with splitter, contact me. Thanks.  I got the information.  By the way, my e-mail address is also in the footer of each page in the help file too in case you need to contact me directly. Eric   ...Show All

• .NET Development C# Asynchronous Socket. How to reject unwanted connection?

  Hi all, I am a newbie on C# socket programming. Can anyone teach me how to reject an unwanted connection based on the IP This is my code (it does capture that the IP is not the wanted IP, but then after rejecting this, the main socket won't listen anymore): Socket tempSocket = m_mainSocket.EndAccept(asyn); string cIP = ((IPEndPoint)tempSocket.RemoteEndPoint).Address.ToString(); // I want it to only accept connection from 202.103.212.32 if (cIP != "202.103.212.32") { tempSocket.Close(); Console.WriteLine("Rejected connection from " + cIP); m_mainSocket.BeginAccept(new AsyncCallback ( OnClientConnect ),null); } else { m_workerSocket[m_clientCount] = tempSocket; tempSocket.Close(); } Please help, as I've been ...Show All

• Visual Studio Team System Excel datasource problem - number format

  I have a web test that binds some Post Parameters to an Excel spreadsheet. I notice that some of the values read from the spreadsheet are set to "" (empty string) even though they have a value in the spreadsheet. Debugging the web test and looking at the spreadsheet it appears that the cells that are being read as "" are those with leading zeros. For example, here are 2 rows from my spreadsheet, the first row, second column will be read as "" (empty string) even though it has a value ( 0692189409). All other cells are read correctly. 106500804887 0692189409 81005 106500062973 5520163826 49255 It appears that the formatting of the cells is having some effect ...Show All