sunny123's Q&A profile

• SQL Server Drives in a cluster environment

  Hi, I have a SAN and configuring a cluster on SQL 2005. I initially created a Quorum drive when setting up the cluster and now added 4 more drives to the physical node but when I try to install SQL that drive cannot be located. Do we need to create all the drives when installing the cluster or what is the way to add the drives later on. Thanks Anup Thanks All. With some troubleshooting and tips from this forums the cluster is up and running with SQL 2005. However I do not understand whi we need a seperate drive for MSDTC cant we share the quorum drive to do this. Can you explain how to size this like perf issues, disks needed etc. Thanks ...Show All

• Visual C++ dll build successful, no dll created

  I'm new to VC8, and I tried to create simple unmanaged DLL using C++. At the end everything compiled and linked without errors, but when I looked into output directory, there were no dll or lib files. Then I tried to compile just code generated with Project wizard - Win32 - DLL. There were no errors but no DLL too. Then I turned back to VC++ 2003 and did the same - my library DLL was created and code from wizard worked too. After all I tried to convert projects from 2003 to 2005 and voila - they compiled in 2005 too. I have searched net for answer, but didn't found one. So I'm asking: What has to be done to make DLL appear after successful linking in VC++ 2005. I believe I'm just dumb and don't see some obvious thing that ha ...Show All

• SQL Server Rich Text field

  I currently have a simple project where we need to store paragraphs for letters that will be automatically printed and then mailed to cusomters. These letters will be created based on certain criteria. I have the SQL database set up with two fields...the paragraphCode (which is the key) and then the paragraph. These paragraphs were originally created in Word and some of these paragraphs contain bulleting and other rich text features. I have built a small utility in ASP (using VB .Net) for our intranet to view / insert / edit these paragraphs. If a user is copying and pasting the paragraph from a Word document, what should this paragraph field's datatype be declare as It is currently NVARCHAR(MAX). Thanks for the information ...Show All

• Windows Forms Best method to Validate windows form field data bound to a dataset datatable?

  I've built a form using the drag and drop method from a dataset. Great, so now I have a form that I can add, edit, and delete details but how do I create field validation to a) Prevent the errors generated from the datatable constraints (No Nulls) b) Put in my own validation like making sure if one tick box is ticked that certain fields are completed I want to validate fields before the user moves to another record (new or existing) or when a user clicks on the save button to save the datatable changes. Ideally validation would only occur if the row of data has changes or is a new row. Any help on this would be appreciated. Thanks for that Bill. Did a search over previous posts and found some ...Show All

• SQL Server problem with panda antivirus and olap cubes

  I have the next problem: i have MS sql server 2005 installed in a server. We have some olap cubes in the server deployed with analysis services 2005. When we try to connect to the analysis server from a client pc using pivot tables we obtain this error: "Errors in network layers. Error code=0XC10D0009, External code=0x00000000" The client pc has panda antivirus (corporate) with true prevent When i unisnstall it, we can connect to the analysis server and to the cube normally and when we install the antivirus again (without true prevent and with the minimun options) the problem starts again and we can't conect to the analysis server. Anybody had a similar problem Anybody knows a solution for it Thanks Jose coormx@yahoo.com.mx ...Show All

• Visual C++ Template Specialization

  I am reading Alexandrescu's generics book entitled "Modern C++ Design." On page 7 he says "Using templates alone, you cannot specialize the structure of a class (its data members). You can specialize only functions" I'm trying to make sense of that comment. ISTM the "specialization" of "functions" he references, pertains to method templates within a class (which can allow for any number of methods to be "added"). In contrast, while data members can be templated, they can't be "added" to a class. Ok, at least I think that is what he means, and if so, then I agree. But is there something I'm missing And should I be asking this question on another forum Which Yes, I th ...Show All

• Visual C++ Acessing vb components (COM) from visual C++

  I look for suggestions how to acess vb components (COM) from Visual C++ (Visual Studio 6.0). Have a look for BSTR ,VARIANT stc in MSDN.and have a look on the Following link for more details .A Step by Step Guide to Programming in Multiple Language http://mattandjess.net/c++/index.html Thanx ...Show All

• Visual Studio 2008 (Pre-release) ORCAS Installation Trouble

  I've installed NET3.0 FX (I had WINFX pre-release, I've uninstalled them). Right now I can't Install ORCAS and everything which use NET3.0 runtime components. what do I have to do to install ORCAS again Dario Did you get this resolved I have the same issue. I installed dotnetfx3setup.exe (WinFx) and then tried to install vsextwfx.msi (Orcas) and I get the following error: Setup has detected that a prerequisite is missing. To use Microsoft Visual Studio Code Name "Orcas" Community Technology Preview- Development Tools for .NET Framework 3.0 you must have the .NET Framework 3.0 runtime installed. Please install the .NET Framework 3.0 runtime and restart setup. I ha ...Show All

• Smart Device Development How to form a bitmap image in compact framework

  hi all... i am developing an appliction in which i am drawing some rectangles & lines along with some text. I am using .NET compact framework. But whatevr application i have developed it is showing some flickering problem. So can anyone tell me how to remove this flickering. If we form a bitmap image from the rectangles, lines & text then i think we can remove this flickering. So can anybody tell me how to form a bitmap image at runtime in .NET compact framework. Thanks, vinay Thanks for your reply.... I also want to avoid flickering which is i think because of "OnPaint" .... so can u tell me how this flickering can be remmoved... Regards, Vinay ...Show All

• Software Development for Windows Vista Transactional persistence of multiple workflow instances: pooled connections maxed out

  I’m trying to poke WF in various ways to make sure we can use it in a large project. The system will largely create the workflows in batches. For example every night we may create 4000 or so workflows. If I’m dealing with a batch of 4000 I don’t think I’ll be creating the workflows and starting them right away like this: WorkflowInstance instance2 = workflowRuntime.CreateWorkflow(typeof(Workflow1)); instance2.Start(); I’m more thinking I’ll be creating all the workflows, getting the WorkflowInstanceID, recording this against an item in the database which the workflow is tied to. This needs to be in a transaction as I need to ensure the workflow is persisted and the WorkflowInstanceID is also recorded against the relative item in the datab ...Show All

• Windows Forms DataGridViewCheckBoxColumn Check Changed

  Is there away to catch a check changed event Itzik I don't quite understand your mean,can DataGridView.CellClick Event help you ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Using xna with windows forms???

  Is it possible to draw with Xna, on my windows form, if so, how because when you have it draw, the normal way, it automatically pops up its' window, also, even if the 1st one is possible, game components are like controls correct Could somebody also point me in the direction of\ tell me how to use them, the basics, otherwise I wouldn't be asking this question, I just started working with Xna. This didn't help me out alot, that Toni Greco's space thing, is just what I need, drawing to a picturebox, but it must be for beta 1, because it has a bunch of compile errors, and I'm not going to use some 3rd part item to get what I need. ...Show All

• SQL Server Performance Improvement in Analysis Services 2005

  Hi, I am new to Analysis Services and was wondering if some one could assist me with the issues I am having. Basically we have one single table on which I need to build a cube so that managemet can view the data in excel and have good perofrmance. I started with AS 2000 but ran into the issue of having more than 64,000 members for a dimension level which were not unique.I tried various suggestions given on the forum but none worked. So I installed AS 2005 and migrated the database from AS 2000 and build the cube. However I am running into major performance issues, What I have are 2 dimensions with hierarchies Products and Time . The lowest dimesion in Products in something called Instrument Id and it is the 4th level in my hier ...Show All

• Windows Forms Exe file size is large!

  I have a WinForm application. The size of the exe was about 200 KB and after I added the .ico file that I created, it's size has changed to 980 KB. I don't know if adding the .ico file has caused this or something else. The application has not changed much and the only significant change that I made was adding the .ico file. The size of the .ico file is only 85 KB. Can anybody tell me what may have caused this Thanks Basani Ah, of course. The designer doesn't let you use a resource for the Icon property; strange oversight. You can however do it yourself in code. Project + properties, Resources tab, click on "Add resource" arrow, Add existing file. Navigate to your .ico file. Give it a m ...Show All

• SQL Server How to create a linked Server using SQL Server Management Studio?

  Does SQL Server Compact Edition support Linked Server I have 2 SDF files and I want to copy data from one to the other I thought Linked Server is the easier to go. No, linked server is not supported by SQL CE. You can try to use the SSMS query analyzer and copy/paste, depending on the amount of data to be copied, or you can code your own "import/export". There are also third party tools available, like http://www.primeworks-mobile.com/Products/DataPortCommand.html ...Show All