Claudeb1965's Q&A profile

• SQL Server Deploying CLR Stored Procedures to a client, is there a better way

  I'm developing an application locally, and after I complete major revisitions/bugfixes, I transfer the code/database changes to the client. If I change the code for a CLR stored procedure locally, I can just deploy the project to the local database, which handles everything for me. Transferring to the client's database is more difficult, however. In order to update the CLR procedures, I need to drop my regular stored procedures, drop my functions, drop the CLR procs, and then re-add the CLR procs, functions and stored procedures to avoid errors based on dependencies. The stored procs/functions don't change, and it seems like there should be a way to just insert the new CLR stuff without dealing with the regular stored procedures or use ...Show All

• Visual Studio Express Editions coding help

  Public Class Form1 Dim ans As String Public Sub Form1_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load 'whatever is in here will be executed when you start the program' End Sub Public Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click 'whatever is in here will be executed when you press the button 1' test() 'this gives me "test is type and cannot be used as expression" ans = InputBox( " thats it" ) End Sub Public Sub Button2_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click End Sub End Cla ...Show All

• Visual Basic Converting VB6 Property statements to .NET

  I am attempting to convert a class module written in VB6 to .NET. The main problem is that there are several Property Let procedures that have no analog in .NET. Here is an example: Property Let Root(lProp As RegRoot) ' Don't accept an invalid Root value. Select Case lProp Case HKEY_CLASSES_ROOT, HKEY_CURRENT_USER, _ HKEY_LOCAL_MACHINE ' All is well. Case Else lRoot = HKEY_CURRENT_USER End Select If lProp <> lRoot Then lRoot = lProp If Len(strKeyName) Then GetKeyHandle lRoot, strKeyName End If End If lRoot = lProp End Property How can this be rewritten to work in .NET Thanks I can see it will be much easier to user the registry class in .NET than trying to upda ...Show All

• .NET Development Interop: Deserializing xsi:nil values to System.DateTime

  Hello all together, my .NET-Web-Service gives this response when trying to deserialize a xsi:nil="true" to a DateTime because a System.DateTime class cannot be a null value. Thx, we are still onto .NET 1.1. I dont know if i can use strings because the ws is beeing consumed by an java-client and i had to implement the ws following a wsdl which describes these properties as xsd:dateTime’s. ...Show All

• Audio and Video Development losing color

  Hello, when i navigate fast (holding an arrow button) the button looses color how can i solve this I use: <par> <cue begin="//button[state:focused()=true() and style:backgroundColor()='rgba(206,241,255,255)']" end="//button[state:focused()=false() and style:backgroundColor()='rgba(255,206,210,255)']"> <set style:backgroundColor="rgba(255,206,210,255)" /> </cue> </par> ...Show All

• .NET Development Multiple Managed Debugging Sessions under one ICorDebugInterface

  After I get an ICorDebugInterface can I open more than one debugging session, each in a different thread, with it Or do I need an interface pointer for each session. - Dan. However, I'd strongly suggest that you keep your ICorDebug and ICorDebugProcess objects 1:1. A single ICorDebug instance can handle multiple ICorDebugProcess instances. The ICorDebug interface could have be alternatively "ICorDebugProcessCollection". Reasons to keep it 1:1: - this plays better with the debugger versioning story . - this has nice future-proofing qualities . - it reduces corner cases . Most often, you'll have only have 1:1 for ICorDebug : ICorDebugProcess. If you take advantage of ICorDebug supporting m ...Show All

• SQL Server SQL 2005 upgrade Problem - In place upgrade

  Hi, We are running a test upgrade form sql 2000 standard edition 32 bit to sql 2005 developer edition 32bit. Followed through all the steps and specified the account(SA priveleges and currently used by the 2000 version) and is the local admin on the box for the services and the setup seemed to move fine, except for when it got to the point of installing database services - This is the error message that I got: MSSQLServer could not be started. Verify you have sufficient priveleges to start system services. The was no choice but to hit cancel and then the set up progressed with a final message of 'SEtup failed'. Here is a portion of the error log: Attempting to recover in-doubt distributed transactions involving Micros ...Show All

• Visual Studio 2008 (Pre-release) Cider support for local assembly references?

  Am I doing something wrong Or do i possibly have an bad interaction between Cider and ReSharper (my guess). every time i make a reference to the local namespace in the same assembly... e.g. < Page x:Class = " MyNameSpace .TestPage " xmlns = http://schemas.microsoft.com/winfx/2006/xaml/presentation xmlns:x = http://schemas.microsoft.com/winfx/2006/xaml xmlns:local = " clr-namespace:MyNameSpace " Title = " TestPage " > < Page.Resources > < local:MyConverter x:Key = " myConverter " /> I end up getting all sorts of errors, even though it all compiles fine. In just the snippet i've pasted here, I get three errors: Assembly '' was not found. Th ...Show All

• SQL Server IS service won't start after installing SP1

  I have just installed SP1 and now the IS service will not start at all. I have tried using the LocalSystem account and an account with domain admin rights that I use to run all the other SQL Server services. Before the SP was applied the service was running fine. I have tried starting it from the command prompt, services and configuration manager but none of them work, I get the following error message: "The service did not respond to the start or control request in a timely fashion" This message is also in in the System Event Viewer, but there are no messages in the Application Event Viewer for the IS Service so I am now officially stumped (not to mention frustrated) Please help! ...Show All

• Visual Studio Tools for Office VSTO 2005 Infopath project template missing

  I have installed Visual Studio 2005 Team Edition (release version), Visual Studio Tools for the Microsoft Office 2005 and Office (and Infopath) 2003.  In the "Visual Studio installed Templates" for Office, I have templates for Excel, Outlook, and Word (and they are all working fine), but I do not have a template for Infopath.  Do I need to install something else to get the Infopath templates and be able to create Infopath projects in Visual Studio 2005 The Beta version will not work with the final release. The final release of the toolkit should be available whereever you got VSTO itself (either as a separate download on MSDN, or a separate CD in the box).   Where did you get VSTO I will ...Show All

• Windows Search Technologies Vista: Moved index location, drive died, now not indexing

  >>> Short version: My Windows search configuration is invalid. I would like to set it up cleanly as if I were doing a fresh Vista install. But I do not want to change any other aspect of my current installation. How can I do that Vista Ultimate RTM Indexing Options dialog buttons are disabled >>> Long Version: 1. From a working installation of Windows Vista, I moved the location of the index files from the default to e:\index. 2. Then the E: drive failed. 3. I replaced the E: drive After that, Windows Search no longer worked. The Indexing Options dialog said the indexing service was not running. - I have tried starting the service. At frist, it would not start saying it could not find a particul ...Show All

• SQL Server Change Report Datasource

  I have a c# assembly that uses the reporting services webservice to render reports. Every user accessing this component needs to render this report passing different datasource to it in order to browse data in different databases (es.: test databse server, production database server) Is it possible to create a linked report and change the connection only to it Other suggestions Thanks Hi, you can change the connection string property depending on the user (role or something you want to differentiate with). I don’t know if that is actually a solution for your problem but this is worth a try. using an expression could be something like ="Data Source=" & IIF(SomeExpression,"Tes ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Gaming groups or websites

  I'm looking for a good 2D gaming development group or website. For example, DeviantArt is where artists go to share their work with other artists. Is there a game dev equivalent I'm a 2D, RPG developer typically. If you know of any other great communitys out there (apart from this one, of course), please let me know. Thanx! *jinx Since you're posting on an XNA-related forum, I'll assume you're looking for a similarly focused web site, in which case you might want to check out the one I run: www.threesixbox.com ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. missing Direct3D device???

  Help! I'm working on my first XNA Project: Learning how to work with 2D images/sprites. I follow the directions completely and I get this in the Main() module when it tries to access the Game1 module: Could not find a Direct3D device that has a Direct3D9-level driver and supports pixel shader 1.1 or greater. I tried downloading the Direct3D 9.0 SDK extras package, but it didn't help. I'm stumped. Dan It was required in beta 1, but the minimum was upped in beta 2. That might be why you're having problems. There is a workaround, but it's so problematic (read: you'll probably get frame rates in the single digits) as to be almost worthless. Check here . ...Show All

• Visual Studio Rendering Server Report To Printer

  Having just tested my applications print function with an actual printer and not the Document Imager, I have discovered that using the reportviewer.printdialog provides printouts once in a while when it feels like it, having just posted asking how to suppress the dialog box it seems somewhat ironic that the only way I can actually get the report to the printer is to display it twice per report :) I can render an image to the printer directly and it comes out every time however I am unable to print any pages after the first page. I started by taking the following article and attempting to send a server report. This seems OK however the code sample creates a stream per page, when I render I create 1 stream. Is there an easier way to do ...Show All