RhysDavies's Q&A profile

• SQL Server ALTER COLUMN on an XML column type can give error Msg 511 after a few attempts

  Basically I am trying to apply an XML Schema to an XML column after data has been added to the table. I need to do this to generate a computed column for use in an index to improve the access times. While I was playing with the schema getting the format/syntax correct I needed to apply and remove the schema several times and got errors. The following is how the errors can easily be generated rather than how I encountered them initially. Software=Windows 2003 Server, SQL Server 2005 The database table used, without the schema, was... CREATE TABLE [dbo].[EventXML]( [EventID] [INT] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL, [XMLData] [XML] NULL, [msrepl_tran_version] [UNIQUEIDENTIFIER] NOT NULL DEFAULT (newid()) ) The data com ...Show All

• Smart Device Development Failed to open VPC Network driver Vista Enterprise RTM

  Hello, I have just upgraded to Vista Enterprise RTM and now when I try to open WM 5.0 device emulater (Selecting connect) I get the message below. Is there a fix out yet I did install the windows mobile device center, as well as the Virtual Machine Network Driver for Microsoft Device Emulator ( http://www.microsoft.com/downloads/details.aspx FamilyID=dc8332d6-565f-4a57-be8c-1d4718d3af65&displaylang=en ) but it didn't seem to help. Thanks in advance.\ John Message: Failed to open the VPN network driver. Verify that the driver is installed, or install the driver from the web download location at..... Mohit, I have uninstalled the VPC net driver. Rebooted and reinstalled as the admin ...Show All

• Visual Basic Help with setting environment variables

  I'm currently building a vb.net common service's library for interacting with tuxedo middleware. The issue im having is setting environment variables to reference the Path of a few different ocx files I use in my project. I've tried the following.... 1. SetEnvironmentVariable API 2. System.Environment.SetEnvironmentVariable("Var", "Val", EnvironmentVariableTarget.Process/User... 3. Add registry values ex. Registry.CurrentUser.OpenSubKey("Environment", True) Setting the key then calling SendMessageTimeOut(HWND_BROADCAST, WM_WININICHANGE, 0, "Environment", SMTO_ABORTIFHUNG, 5000, resApi) When my codes attempts to create the ocx object it gives a FileNotFoundException "8007007e ...Show All

• Visual Studio Express Editions Validation

  How do i set the textbox feilds enter must be only integer and another alpha onli any code Public Class Form1 Declare Function SetWindowLong Lib "user32" Alias _ "SetWindowLongA" ( ByVal hwnd As Integer , ByVal nIndex As Integer , _ ByVal dwNewLong As Integer ) As Integer Declare Function GetWindowLong Lib "user32" Alias _ "GetWindowLongA" ( ByVal hwnd As Integer , _ ByVal nIndex As Integer ) As Integer Sub NumericEdit( ByVal TheControl As Control) Const ES_NUMBER = &H2000& Const GWL_STYLE = (-16) Dim x As Integer Dim Estyle As Integer Estyle ...Show All

• Visual C# Hide Console Window in C# Console Application

  Hi, How can I hide the console window in my Console Application project You can Pinvoke a call to FindWindow() to get a handle to your window and then call call ShowWindow() to hide the window. Before pasting some code though I’ve got to ask though... if you do not want your window visible, have you considered building your app into a Windows Service that will always be hidden from view ...Show All

• SQL Server Cube Processing through SSIS

  Hi, I am facing a serious issue with Microsoft Analysis Services 2005 and Microsoft Integration Services 2005 and do hope that someone here can help me out. My problem is that I have created a cube in Analysis Services and need to process it through Integration Services. I have followed all the steps mentioned in the documentation and everything runs successfully from the BI Studio when I execute the package; the required data is loaded and cube successfully gets processed. However, when I try to execute the same package after it is deployed, then it gives the following error: "The Dimension with ID XXX does not exist or there are not enough permissions to access it". I have given the "Full Administrative" perm ...Show All

• Visual Studio Express Editions Random Number Generators

  Hello I have the following code : Random random = new Random (); for ( int i = 0; i < 14; i++) { int number = random.Next(0, 10); MessageBox .Show(number.ToString()); } How can I create an Array (or an ArrayList ) in order to display all the numbers in a listbox I also would like to create a seed based on the clock of the computer, thus each time the program would run it would be unique. Is such thing possible Thanks in advance. Nefer-Ra So I saved this arraylist into a listbox ... hod do I retrieve the elements in order to save them to a file I open the dialog box, set filter to .txt, open a file stream and I was thinking something like "this.listbox.Items.S ...Show All

• Visual C++ strange run time error notification (empty pop-up window)

  When a run time error occurs (e.g. an invalid file handle is used) in a console application created in debug mode with C++ Express Edition I get a completely empty pop-up window (title reads "Microsoft Visual C++ Debug Library") with three empty buttons. Clicking on any button terminates the application. 1.) Is this behaviour due to the missing C debug runtime libraries in EE (i.e. is it a "feature") 2.) Running the same .exe in an environment with .net 2002 installed shows the usual window contents and I am able to run the debugger - it points to the bad statement I use /MTd (link runtime lib statically) - how comes the pop-up window is fully working Any help highly appreciated ...Show All

• Visual Studio Team System Any issues using MS Virtual Server to roll out Team System Foundation Server?

  Hello All, I am contemplating the use of MS virtual server as a means for us to initially use the eval copy of Team Foundation Server in order to provide a low impact on our server. The tentative plan is to allocate 1 GB of RAM, 20 GB HD space and a seperate network card for this virtual server instance. I would appreciate any feedback (good or bad) regarding this :) Thanks in advance Sounds like a good plan to me Bob. As a virtual server it will be much easier to move it around until it finds it's permanent home. Any idea how many users you expect to have connected to the virtual server With only 1Gb or memory you probably shouldn't go to far towards 100 users (but it depends on how your server is utilized) ...Show All

• Visual Studio 2008 (Pre-release) Service Execution Location

  I am juststarting with WCF. I have a client and Servcie with the servcie method PerformTask and accepts a DataContext class Task as parameter. When i call the method PerformTask with parameter Task from Client. where will the actual process executes either at the Machine that host Service or Machine that has the Client. If you're hosting your service in IIS then it will run inside of a worker process (aspnet_wp.exe or w3wp.exe). Otherwise if it's self-hosted it will run inside of your server exe. Thanks! Scott ...Show All

• Internet Explorer Development Problem debugging embedded Client Script using IE7

  We are getting an error when trying to debug client script (VBscript and JScript) from the Running Documents window using VS2003.  This only happens when the script is inline on an asp page.  If there is a .js file, there is no problem. Here is the error we get:   "The following breakpoint cannot be set: bla bla bla No executable code is associated with this line." I am about to uninstall IE7 and go back to 6 because I am unable to debug our client-script-heavy applications.  Any help would be appreciated. Thanks, Kevin   We're getting the same issue. Microsoft Visual Studio 2003. View Running Documents - we can see the document source, b ...Show All

• Visual Studio Express Editions Something Wierd...At least for me. Win32 Form Application Project No Where to be Found.

  I recently had to reformat my computer, and well after i installed VC++ 2005 Express Edition, I wanted to create a "test" Win32 Application Project.It's the one that creates a premade form and menu.It has no "visual" form editing however.Unlike Windows Forms Application which i do not want.All I see though in the Win32 category is "Win32 Console Application". And im just wondering.... Is this how its supposed to be Or do i have a glitched version...     Okay... Now something really wierd... the Code from this site.One which worked before my re-format.Does not anymore. The tutorial is from here. http://gameprogrammer.org/main.php page=tutorials&no=25 Here ar ...Show All

• Visual Studio Team System TFS Project Structure creation

  HI Can any one tell me how to create a team project for the above secenrio we are in product development, so we have a product at top level and which in turn has n sub modules projects.The Structure is like this Product Module1-Team A (10 persons are working) Module 2-Team B(20 persons are working) Module 3 -Team C(10 persons are working) ......................................................... .......................................................... Module n-Team N( 10 persons are working) Based up on this scenerio, i want to create a team project where in ,project Lead of a particular Module should have access to his module relating information (it may in the Team expolrer,share point site ...Show All

• Windows Forms Creating a smooth dragging of something similar to a form

  I am using xna, yes, I realize that I may be in the wrong section, but I'm not, because this doesn't only pertain to xna, its pretty much any set of coordinates, because it all acts the same, windows forms, ect. Basically, I need to know how to make a smooth dragging of something, using the mouseposition, and the objects location, but I want it to be much smoother than doing object.location=mouseposition or something, because when you do that to a form, for example, you will see it kind of skip to your mouse position. Windows doesn't do this. I was thinking about taking the mouse position, from when you clicked the object, and minus the object's location, store that in a temporary variable, and then when you goto set the position, have ...Show All

• Visual Studio Express Editions app control

  After I have found the handle of a button i want to control from my aplication with spy++then what do i do with that number or i will have to just fake a mouse click at x position like this person did... I have found the eqivelent to what i am trying to do accept it is in visual basic 6.0 code so i dont know how to do a conversion. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=144808&SiteID=1 tell me if you have any ideas... Average Joe Spotty, You are quoting the wrong poster. That is old VB6 code. Newer code: Option Strict Off Public Class Form1 Private Declare Function GetMessageExtraInfo Lib "user32" () As Integer Private ...Show All