robinjam's Q&A profile

• SQL Server Installing SQL Server 2005 Express

  I am working on Win2K Pro & had SQL Server 2005 Express & SQL Server Management Studio installed. The SQL Server name was Merver\SQLEXPRESS . Due to some unavoidable reasons, I had to repair (& not re-install) Win2K but after doing so, I found that I am not able to connect to the database server. I uninstalled all the components related to SQL Server 2005 Express (like Management Studio, Support Files, BOL etc.) from my m/c & then restarted my m/c. After doing so, I first re-installed SQL Server 2005 Express & other related components (I intended to install SQL Server 2005 Management Studio after installing SQL Server 2005 Express). While installing SQL Server 2005 Express, all the steps get executed successfully ex ...Show All

• Visual C# Column span changing after build for listbox in table layout panel

  I have a table layout panel with 5 columns and 3 rows, the 5 columns are 20%, 20%, abs 20, 30%, 30% with the rows at abs 20, 100%, abs 30. I have a listbox in column 0, row 1 for a column span of 2 and a 2nd list box in column 3, row 1 for a column span of 2 also. I build the project but right after the build is complete, something modifies the the designed code (with the designer reflecting the changes) with both column span going back to 1 and the file having an asterisk (modified) next to it. The build builds the unmodified (ie column span of 2) ok, but then I have to edit them back again before doing the next build. any ideas running with SP1 on visual studio and Net 3.0 installed Bernie ...Show All

• SQL Server sp_cycle_agent_errorlog fails/SSMS recycle Agent log fails

  Hi, The sp_cycle_agent_errorlog stored procedure fails on our primary SQL Server 2005 server; the SSMS context menu option (right click Error Logs under SQL Server Agent in object explorer) to recycle the agent log also fails. If we run the SP then we get the following: Msg 22022, Level 16, State 1, Line 0 SQLServerAgent Error: 32. If we try the SSMS option we get this (in a nice dialog): Cycle agent error log failed for JobServer 'UKSQL04'. (Microsoft.SqlServer.Smo) Additional information: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) SQLServerAgent Error: 32. (Microsoft SQL Server, Error: 22022) We are running SQL Server 2005 x86 Enterprise E ...Show All

• Windows Forms Where should I put the global variables?

  Hi all, First step, I created a simple "Windows Form" Form1 project. There is Form1.h, and I have many functions like click(), paint(), buttom_down()...in it. How to pass the variables between these functions Should I use global variables or they are not recommanded For example: The program tries to get the screen size and pass into image display function I will have scr_width, scr_height, img_src_width, img_src_height, img_scr_width, img_scr_height, Bitmap^ img... What is the good way to set up them And the second step will be, I separate the buttoms and display area, should I use two Forms If so, how do I pass these variables between so many functions in two Forms Thanks! ...Show All

• Windows Forms How does the designer locate an assembly ?

  I can see the topic about locating assemblies at run-time. My question is how the VS 2005 IDE and the Windows Form Designer locates an assembly a design time. I have my own assemblies of components, which I am testing and which therefore do not have strong names and are therefore not in the GAC. I was able to add my assembly's components as Toolbox Items through the Choose Toolbox Items... dialog and by browsing to the directory where the assembles are located. When I create a .Net application and use the Toolbox it appears that the IDE will always know where my assembly is at design time because the full path to the assembly is in the Choose Toolbox Items... dialog. Is this all that is needed at design time to locate an assembly for the d ...Show All

• Software Development for Windows Vista Protected Registry key access under Vista.

  Well I see the /basic./ problem. On 2k/xp the local administrator has the right to alter the permission of the registry keys in question from regedit (as well as by using the above code). On Vista the same operation in regedit itself returns an Access Denied error. So the default permissions HAVE changed on certain registry keys and/or the local admins ACL. It seems that write permission or the ability to change access at all is now only allowed by the SYSTEM account. Would I also be right in thinking that there is no way that a program run under an administrator account possibly impersonate a SYSTEM user Has the ability to add data to this key now just been made compeltely impossible via code or account access Specifically: H ...Show All

• Windows Forms Notifying a progressbar

  Hi I have a class in a seperate file. The class is responsable for manipulating thousands of records. Is there any possibility to drive a progressbar in a form that's using the class so one can follow the progress of the action Thanks a lot Hi, this looks promising: http://samples.gotdotnet.com/quickstart/util/srcview.aspx path=/quickstart/winforms/Samples/ControlReference/ProgressBarCtl/ProgressBarCtl.src&file=CS\ProgressBarCtl.cs&font=3 Mark. ...Show All

• Microsoft ISV Community Center Forums Generating Documentation

  Is there any way to generate documentation for a VBA script Basically, I would like to get a list of variables, functions and subroutines for each page that I am writing. I could create it, no problem but is there a way to autogenerate it Hi Yeah this is possible as you can parse the VBProject. Here is a link that has information on what your looking for. About half way down there is a section on how to list all modules in a workbook and one to list all procedures in a module. http://www.cpearson.com/excel/vbe.htm ...Show All

• SQL Server (Newbie) Trying to get rid of NonEmptyCrossJoin

  Hi everyone, As I have said before, I am new to MDX.  Any help much appreciated. I am trying to substitute the Exists() function for the NonEmptyCrossJoin() function, but Exists is not producing the results that I would expect.  The test query that I am running is: SELECT {[Measures].[Value]} ON COLUMNS , NonEmpty({[Fact].[Name].[All]. CHILDREN }) ON ROWS FROM [AS Test1] WHERE NonEmptyCrossJoin ({[Start Date].[Month Hierarchy].[2006-01-01 00:00:00]:[Start Date].[Month Hierarchy].[2006-06-02 00:00:00]}, {[End Date].[Month Hierarchy].[2006-06-15 00:00:00]:[End Date].[Month Hierarchy].[2006-12-31 00:00:00]}) This is not ideal code, but performs correctly, only listing members with start and end ...Show All

• Visual Studio 2008 (Pre-release) enums - to use [DataContract] or not to use?

  Hi, I'm currently wondering what the implications of adding or leaving out the DataContract attribute on enumerations. I've tried googling and reading but haven't found any definitive answer, but so far it seems that - enums are serialized implicitly without DataContract - IF I add DataContract, I also have to add EnumMember to all members - If I just want to skip a member, then I can either apply [NonSerialized] to that particular member, or add [DataContract] to the enum and [EnumMember] to all members except the ones to ignore. - If I want to have another namespace than http://schemas.datacontract.org/2004/07/Server (WTF! !) then I have to use [DataContract(Namespace=...)] - If I want to rename some member over the wire, then I have to ...Show All

• SQL Server JavaScript Error when deleting user from report

  Hello, Have a problem here needs urgent help. We are on SQL Server 2005, just recently installed SP2. Not sure if the problem is related to that but just now I tried to delete a user from a report (Properties > Security > Delete) I got a JavaScript error exclaimation mark at the bottom of my browser, when I clicked on it, it showed javascript error: 'return' statement outside of function. The delete user function worked well all along until today, our IT installed SQL 2005 SP2 last week, not sure if it is related. Any solution (uninstalling SP2 is not an option). and all other javascript functions worked well except the remove user in the security setting..I have no idea what is wrong.. Please advise!! HELP!!!!! Thanks in ...Show All

• Visual C# Strange behavior in catching COMException

  Hello, Recently I got some strange behavior about handling COMException.Pseudo codes as follows: if (condition) { if (condition) { try { new a COM object; calling methods in COM object and other .NET assembly; } catch (COMException ce) { write message to a WinForm Message Console; //1* some other operation; //2* } catch (Exception e) { write other message to a WinForm Message Console; //3* some other operation; //4* } finally { some code here; //5* } } try { operations here using .NET assembly, including writing message to WinForm; } catch (VariousException) { doing exception handling; } finally { dong fina ...Show All

• Visual Studio Express Editions Program to launch programs :)

  Hey, I am looking to make a program that will be able to launch two other programs simultaneuosly. Can someone show me some code please Im pretty stuck :( Ok, so I figured out how to use the Process class, but I am having trouble specifying where my programs are. Any tips And for the .bat, I totally forgot that they are executable by themselves...but once again it didn't do anything when I launched it. I am sure I am putting the full adress to the programs but still no-go. ...Show All

• Internet Explorer Development Where is the best place to put settings button in IE 7?

  I'm developing BHO add-on for IE 7 and I need to have settings dialog for my app. I'm not sure what will be the best place to put button which will open the dialog. In IE 6 I would probably add button to the menu, but in IE 7 menu is hidden by default, so I don't want put my button there. Right now I can see only one place where I can put this button, it's "Tools" Dropdown button (on the right side of Tab control). Is it right place to put it If so, does anybody has example how to put buttons there Is it possible from BHO Thank. Thanks a lot Rob. Usually after a sucessful Addon installation you take your users to a web page with instructions on how to add their new Button to th ...Show All

• Visual Studio 2008 (Pre-release) BitmapFrame to stream conversion

  Can someone point me to the correct way to convert a Bitmapframe to a byte buffer to save an image in sqlserver Thanks, John I think you could do something like this: if (bitmapFrame != null ) { PngBitmapEncoder png = new PngBitmapEncoder (); png.Frames.Add(bitmapFrame); using ( MemoryStream mem = new MemoryStream ()) { png.Save(mem); byte [] imgBytes = mem.ToArray(); // and use the imgBytes array in your SQL operation } } ...Show All