Martin Thwaites's Q&A profile

• SQL Server OpenRowset to SSAS

  Hi, I am trying to execute the following command SELECT a .* FROM OPENROWSET ( 'MSOLAP' , 'DATASOURCE=mpdata; Initial Catalog=[OLAP - Retail Wholesale];' , 'select [Measures].[Nett Sales Value] on columns, Relative Week Dimension].[RelativeWeek].[Relative Week]on rows from [Retail Summary OLAP]' ) as a This generates the following error OLE DB provider "MSOLAP" for linked server "(null)" returned message "Cannot connect to the server 'mpdata'. The server is either not started or too busy.". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "MSOLAP" for linked server "(null)". Any advice on what to do ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Making games forward-compatible with Content Pipeline?

  Hello, I was wondering if there is any documentation explaining how the Content Pipeline API will work. I want to make sure my code will be as forward-compatible as possible when it's finally released. Thanks, Tom Given the nature of DOM it tends to be pretty slow traversing the tree and it can incour significant overhead with large models. The implementations that you do. Is that in C# or is it closer to native code Just wondering since this could lead to needing to find other ways of implementing model reading. ...Show All

• Visual C++ Platform SDK for GDI+

  Hi All, I am having the Problem with executing GDIPlus Supported methods.I had gdiplus.dll in my apllication folder.But surely the application needs gdiplus.h and gdi.lib. i couldn't download it anywhere.Can anybody give me the route to proceed further OS I am using is : Windows 2000 pro . This is the application i wish to execute . #define UNICODE #include <windows.h> #include <gdiplus.h> using namespace Gdiplus; VOID OnPaint(HDC hdc) { Graphics graphics(hdc); Pen pen(Color(255, 0, 0, 255)); graphics.DrawLine(&pen, 0, 0, 200, 100); } LRESULT CALLBACK WndProc(HWND, UINT, WPARAM, LPARAM); INT WINAPI WinMain(HINSTANCE hInstance, HINSTANCE, PSTR, INT iCmdShow) { HWND hWnd; MSG msg; W ...Show All

• SQL Server Difficult times deploying a few packages to SQL Server and running as a job

  Hi Guys! I have created a big list of packages, some calling others. They all work fine from my computer using Visual Studio. When I try to deploy them (building them with deployment turned on and running them either directly from Management Studio or as a job) I get the errors with the password of connection strings. From what I read so far its the encryption process that kills it. I have tried to add a password to some packages, but it still didnt work (only when run directly on my computer in management studio after deploying to SQL Server, but not as a job). I have tried to change ProtectionLevel to SecurityStorage, wouldnt let me save in Visual Studio (I understand it is ot allowed in VS because you are saving to File Syst ...Show All

• SQL Server SET NEW_BROKER statement hangs system

  SQL Version - SQL Server 2005 Standard Edition, SP 1 I have a database which is Broker Enabled. We use Query notification extensively and the application is in testing stage. Both Testing and development database is on the same server. When I create database for testing I used to do Backup-restore method. When i restore a borker enabled database, the restored database and the source database will have same GUID for Broker. So by default the restored database will not be broker enabled. So what I do is , i run Alter database somedatabase SET NEW_BROKER. This statement will generate new GUID for this database and then we can enable the Broker by SET ENABLE_BROKER statement. Till last week this process was working fine. When I did the same ...Show All

• Visual C++ How to set WS_CLIPSIBLINGS on an edit control?

  How can one specify WS_CLIPSIBLINGS for controls in a dialog in VS2005 The Dialog Editor doesn't seem to have these as options for controls such as edit controls. Hi, Are u able to set the WS_CLIPSIBLINGS on an edit control If u r, could u please post how did u do that Thanx in advance. Ch.T.Gopi Kumar. ...Show All

• SQL Server Inserting XML with SSIS - VERY URGENT!!!

  Hello everybody, I have a problem. I need to insert an unknown number of xml files in a database (all files are always in the same folder), in different tables, each file has the same name that the corresponding table. For example: Files Tables user.xml user purchase.xml purchase ...and so but the number of files is not always the same, I mean, it can be 6 one day and only 4 the next day. Can I insert the data in the xml files into the tables with a Foreach Loop Container or any other way If it's possible, how Thanks in advance for your help, Radamante71 You might want to post your question at SQL Server Integration Services forum at http://forums.microsoft.com/MSDN/ShowForum.asp ...Show All

• Silverlight (formerly WPF/E) Changing Storyboard.TargetName on the fly

  Is it possible to change a storyboard target through Javascript var storyboard = target.findName("storyboardID"); storyboard["Storyboard.TargetName"] = objectID; actually overwrites the targetname, but the storyboard still renders on the object first assigned thanks! ps: if the above worked, I could ideally go as far as creating only ONE storyboard, and applying that to any object/property I choose at runtime. that'd be really nice. ...Show All

• SharePoint Products and Technologies MOSS 3.0 vs. Sharepoint 2007

  Can someone explain the major differences between the two Thanks First off, it's MOSS 2007 and WSS 3.0. SharePoint is often used to generically talk about both, but there is no such thing as SharePoint 2007. Here's a link to an Excel spreadsheet that does a feature-by-feature differentiation between the two technologies: http://download.microsoft.com/download/1/d/c/1dc632e8-71e1-466f-8a2f-c940f1438e0a/SharePointProductsComparison.xls ...Show All

• SQL Server want <cr><lf> terminated output of a sql data table

  I tried using fixedwidth as output format , but i dont get any line terminators. i.e <cr><lf> How can one control the width of output columns . Book references will do..., Please.... How you are performing the export And in which version of SQL Server In this case DTS would take care of all these line terminators etc. Fyi, you can use Row delimiter Specify that each row in the file is separated from the next with a character sequence. Click one of the following: {CR} (carriage return); {LF} ( line feed ); Semicolon ; Comma ; Tab ; Vertical Bar . You also can type in a character to use as the row delimiter. You can also click < none > if the file is a fixed field file. ...Show All

• SQL Server Cannot Find SQL Server Profiler 2005

  Hi, I have installed SQL Server 2005 WorkGroup Edition but cannot find SQL Profiler anywhere. Can anyone tell me what I need to install to be able to see this Thanks, Paul. Hi Paul, have a look here: http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx Profiler is not shipped with SQL Server Workgroup edition, though it can be profiled fromanother computer having profiler installed. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• SQL Server Category and Subcategory Problem

  Hi everyone, I am having trouble with a particular problem with SQL. I have a table that defines product categories like so: Id (int) Text varchar(50) ParentId (int) It holds all our categories, with subcategories having the appropriate ParentId relating to the above category. I am trying to write a stored procedure that takes in a single Id, and finds out all the related subcategories and subcategories all the way down the tree. I need to produce a resultset with a single column of Id's of all the subcategories etc For example if the table had the following records: 8 - General - 1 9 - Academic - 1 10 - Science - 1 11 - History - 8 12 - Maths - 8 13 - English - 9 14 - Spanish - 9 15 - England - 13 So if I was to feed i ...Show All

• Visual C# Get total size of directory?

  Is there a way to return the total size of a directory. I have this so far: if (FBD_Files.ShowDialog() == DialogResult .OK) { int files = Directory .GetFiles(FBD_Files.SelectedPath, "*.*" , SearchOption .AllDirectories).Length; lblSyncFiles_SelectedPath.Text = string .Format( "{0} ({1} Files)" , FBD_Files.SelectedPath, files); } I just need the size of the folder and I'll be all set. ...Show All

• Audio and Video Development Sound

  hi..a rooki bothering u guys...i didnt know where to make this post.. got a little problem...i cant but my surround sound system on..i used soundstorm but even that doesent work :( I'm not sure where you should put this post either... maybe try the general Windows Media newsgroup and see if you have any luck there http://www.microsoft.com/windows/windowsmedia/community/newsgroups/WindowsMedia/default.mspx dg=microsoft.public.windowsmedia&lang=en&cr=US This forum is for developers interested in the Media Foundation multimedia platform on Windows Vista. ...Show All

• Visual Studio MSBuild behavior differences between 2 build machines

  I've installed VS 2005 on two build machines (both are Win2003, one is a virtual server) using the same installation. On machine A, the MSBuild is working fine; on machine B, the first VCBuild in the build XML fails because it can't find include files even though the files are in the correct include folder. (We set the INCLUDE environment variable.) I've tried passing the /useenv switch as posted on MSDN but that doesn't help. The cl.exe files are the same. In the help-about for VS 2005 I see that machine A has this version of C#, C++, etc.: 77626-009-0000007-41360 and machine B has: 77626-009-0000007-41198, although I have no idea why they're different. Any suggestions of what to check Thanks for y ...Show All