MrDewMan's Q&A profile

• SQL Server Newbie: what kind of "cube" is this?

  1. In sql 2005 Analysis services how can I tell what kind of "cube" I'm viewing -- ROLAP, HOLAP, or MOLAP 2. During cube creation where do I specify the type of "cube" I want to create TIA, Barkingdog The cube wizard will not ask you for the storage settings that you want to use. After you have run the wizard and created the cube, go to the "Partitions" tab of the cube editor. You will then see information for your partitions. You can click on a partition and then click on the "Storage Settings..." link to specify MOLAP, HOLAP or ROLAP. HTH, - ...Show All

• .NET Development Storing/Retrieving Various File Formats in DB Application

  Hi, I hope someone can point me to the right direction. The application I am working on is a database program where I use SQL Server 2005 and multiple Windows Forms based clients that connect to it to store/retrieve data. The data includes attachments (same as email, any kind of file(s)). From other posts, I can see that, overall, saving the files on a disk and the links to the files on SQL Server is a better approach. My trouble is with the actual storing and serving those files to the clients in an efficient manner. Which is better/possible: Doing storing and retrieving of files with SQLCLR. In this case, how can I read t ...Show All

• .NET Development Problems loading executables on Media Center 2005

  Hi, I'm running Media Center 2005, and when I try to run certain exes, I get a common language runtime error, preventing me from loading them. This is getting extremely frustrating. The errors are: ehshell.exe Process id=0xb10 (2832), Thread id-0xb20 (2848) WinSSUI.exe Process id=0xf30 (3888), Thread id=0xa18 (2584) SL4F.tmp Process id=0xdac (3500), Thread id=0xd48 (3400) Can anyone please help me with this It means I can't even run the Media Center software - that's the whole point of having Media Center! I've tried reinstalling Media Center, and tried reinstalling .net framework 2.0. I can't get .net framework 1.1 sp1 (or what ...Show All

• Visual Studio VS 2003 with VSS 6.0d after installing Beta 2.0 of VS 2005

  I previously was developing with VS 2003 and VSS 6.0d, then I tried installing Beta 2.0.  I realized that my VS 2003 is now using VSS 2005 (integrated with it) and as a result, I am having a number of problems with my previous project under source control.  Show differences produces a number of exceptions which I have found in the newsgroups (for previous versions of VSS) is a result of having 2 versions. What should I do to revert the configuration of my VS2003 to use VSS 6.0d instead   I couldn't find any options from VS 2003 menus.  Or should I continously use VSS2005 and just have to do something Thats ...Show All

• Visual C# program crashes when other users run...

  Ok, I created a simple program the other day with nothing complex. I have already been using it for a week or so and now another user wants to run this application. That is when the program crashes. The error I get when debugging is: An unhandled exception of type 'System.ComponentModel.Win32Exception' occurred in System.dll It works normally when I (Administrator) run it but when I run it as another user (both Guest and Limited) the program crashes. I tested to see if something the priviliges were correct so i made this program 100% trust and therefore should be available to do anything, but still it comes. Could this be a conflict be ...Show All

• Visual C# Multiline strings?

  My second question of the morning ;-) I have a snippet of code that I'm using to create a .sln file for a bunch of .csproj files. The snippet works well enough but it strikes me as being rather clumsy. Is there a better way to create a multiline string than to use an array and string.Join Regards, Angus string[] slnTemplateArray = { "Microsoft Visual Studio Solution File, Format Version 9.00", "# Visual Studio 2005", "{0}", "Global", " GlobalSection(SolutionConfigurationPlatforms) = preSolution", " Debug|Any CPU = Debug|Any CPU", " Relea ...Show All

• SQL Server SQL 2005 Express (view database data)

  How do I view the data stored within SQL Express What programs do I need to view the database information You can use SQL 2005 Management Studio if you have it, or you can even use the SQL 2000 client tools if you like...I'd recommend Management Studio, which you can install from any of the other versions of SQL 2005, just perform a client tools only install. If you don't have a copy of any of the other SQL 2005 editions, you can use the SQL Server Management Studio Express CTP free tool, located here: http://www.microsoft.com/downloads/details.aspx familyid=82afbd59-57a4-455e-a2d6-1d4c98d40f6e&displaylang=en HTH ...Show All

• Visual C# First C# Project - Can I attach an Imagelist to a Menustrip?

  Can I attach an Imagelist to a Menustrip MenuStrip doesn't expose any property or method to attach ImageList with it. So traditionally u can't. But If you modify the MenuStrip then u can. ...Show All

• SQL Server Restricting Access to a database

  Hi I wish to setup a database that can be viewed only by a few users. How do I stop other users and the general public from seeing the database and its structures. Cheers Al There is sometime a misunderstanding in authentication and autorization. Unless you don’t autorize a user which is created at server level to access the database, he even won’t be able just to change to that database because he will see something like: Server user <Username> is not a valid user in database <SomeDatabase>. So perhaps if your current users ARE able to change to the database they are probably par ...Show All

• Visual Studio Express Editions Error when calling function on VB activeX dll from C#

  Hello can sombody help in solving a problem I am having a problem when trying to call the function of VB ActiveX dll from C# and I am getting the error show at the end. The VB Function is Public Function GetStatistics(ByRef varStats() As Variant, Optional ByVal stStatType As e_STAT_TYPE = e_stCLIENT_STATS) As Long And the RCW has created the function as follows (when adding ref from Visual studio) int GetStatistics( ref Array varStats, e_STAT_TYPE stStatType); The problem is we cannot create the object of Array class as its abstrac ...Show All

• Windows Forms How to control border style of Datagridview?

  How to control border style of Datagridview   As I cannot find property to change the color of the border. Thanks I'm afraid not.  I'm not saying that it would be a bad thing to have, but there are several reasons this wasn't included: 1) It's not a common customer request.  It doesn't look like lots of people are looking to do this, and in order to do it right, we'd have to expose quite a few properties and events (so that you could adjust the size of each of the borders, colors, custom painting, etc). 2) Development and test cost.  We try to include the right set of features in our controls.  There are some fe ...Show All

• Visual C++ increment in C++

  #include<iostream.h> void main(){  int a=5;  cout<<++a<<a;  cout<<"\n";  cout<<a;  cout<<"\n"; } the above code generates the following output: 65 6 but as per me the output should be as follows: 66 6 why does the incement doen't show up the second time I think that the simple answer is complexity. This is really a language level diagnostic but the tool that would best be able to diagnose this issue would be the optimizer (you can imagine a case in which inlining a function causes mutiple reads/writes) but the optimizer doesn't usually deal w ...Show All

• Visual Studio Team System Web Cache Control Headers - and documentation

  I couldn't see if cache control headers are being processed correctly. I set up a test against a web site that had the stylesheet (Used in all pages) cache control header set to a max-age value (So it should not be refetched from the server - for max-age seconds). However test run shows the stylesheet repeatedly being fetched from the server (within the session). Should this be working Also I am finding the documentation difficult, I am trying to read through the online help (The only authoritive source of VS2005 Tester documentation ) but it is not an easy read in that format - I would prefer a document as a word document that I coul ...Show All

• SQL Server triggercontext.columncount returns wrong values

  Anyone seen wrong values returned from a CLR update trigger when using the columncount property I have a 6-column table that I was experimenting on, and the isupdatedcolumn property was not returning true on the one column I was updating (I verfied the trigger was firing). So, I returned the columncount property in a pipe.send, and was surprised to see the value of 11. When I looped through each column's isupdatedcolumn property, the only column that returned true was column 9. Then I remembered this table used to have more columns, so I conducted the following experiment: Added a new column to the table (bringing the total numbe ...Show All

• Visual Studio Team System Report Server Windows Service login failed

  Hello all, I am trying to install TFS application tier and it keeps failing because of "cannot connect to report server database" I have dual server setup and TFS database installed fine on sql server. I tried couple of times with different accounts and it still keeps failing and saying that it cannot connect to report server database. During the installation setup I get the following error message: Error 29105. Team Foundation Report Server Configuration: The Report Server databases were not created. Common reasons for this are that the current user does not have permission to create the databases on the Tea, Foundation ...Show All