fasttrack's Q&A profile

• SQL Server Timers in CLR Stored Procedures

  I was hoping to be able to use a timer (System.Timers.Timer) within a CLR stored procedure. I can build and deploy the code to my SQL Server instance and it will happily run, but the Exlapsed event never fires. Is this possible i have not tested this, but it would be beneficial to my upcoming book. If no one answers this thread, I will evaluate it the next few days. Derek ...Show All

• Visual C++ Initialization of static enum variable fails in template (migr. c++ v6 to visual studio 2005)

  Migrating from visual c++ (version6) to visual studio c++ 2005 recently i've got errors when compiling this code: #include "mave.hpp" template <typename T> class matrix : virtual public mave<T> { public: enum enLineSolver { GAUSS, HOUSEHOLDER, GIVENS, SHOLESKY}; protected: static enLineSolver lineSolver; }; // Initialization of lineSolver: template <typename T> matrix<T>::enLineSolver matrix<T>::lineSolver = matrix<T>::GAUSS; /* With Visual C++ (Version 6) above line is translated correctly without any message. With Visual Studio 2005 compilation fails with these messages: warning C4346: 'matrix::enLineSolver' : dependent name is not a type e:\007-chera\006-mavex3\matrix.hpp 274 err ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Using directx without a soundcard

  I have an application that compresses wav files (voice recordings). The compression method I use does about a 9:1 compression. Saves me a ton of disk. Unfortunately, the 3rd party app loses its mind. And I have to use that 3rd party app. I use DirectX to examine the input file and then compare it with the output file. If the comparison is more than +/- 1 second different, I quit with an error. Microsoft.DirectX.AudioVideoPlayback.Audio aud = new Audio(FileName,false); audtime1 = aud.Duration; This works great on my workstation and the test workstation. Unfortunately, when I deploy the app to the server, it doesn't work because the server doesn't have a sound card. I did install the latest version of directX on the server. Short of buying ...Show All

• Visual Studio 2008 (Pre-release) Problems with UserName Authentication finding the Certificate

  I am trying for the first time to use Certificates with WCF and running into a baffling issue. I've created a test Certificate and loaded it into credential store and when I try to start my host, I get the following error: Error: Cannot find X.509 certificate using search criteria StorName 'My', StoreLocation 'LocalMachine', FindType 'FindBySubjectDistinguishedName', FindValue 'CN = localhost' This is my App.Config < xml version="1.0" encoding="utf-8" > <configuration> <system.serviceModel> <behaviors> <behavior name="NewBehavior"> <serviceCredentials> <clientCertificate> <authentication certificateValidationMode=&q ...Show All

• Visual Studio Team System Work Item assignment on build Unit Test failure

  Hello, I've managed to get my build type assign the build failure Work Item to myself when the build fails, however, it does not create the work item if the sources build OK but the unit tests fail (and therefore the build fails). Does anyone know how to enable this Also check out the following forum post: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=2718118&SiteID=1 ...Show All

• .NET Development "Plus equals" pattern in IL gives incorrect results

  When people claim to have found a bug in the CLR, I am normally the first person to tell them to go back and find the bug in their own code, since that is far more likely than the problem being in the CLR itself, given how stable the runtime has been since its release. However, I believe I have isolated a case where the runtime, or something operating at or below the IL level, is behaving incorrectly. (Note: the problem I describe here only occurs in version 1.1 of the CLR; version 2.0 does not appear to be affected) This case evolved from a bug I was having in a VB.NET app, but after disassembling the app and playing with the IL code, I am confident that the problem has something to do with the IL itself. Basically I am performing a "p ...Show All

• SQL Server Problem in Multiple Publication on Single Table

  Hello Everybody, If any one have solution then please help me. Thanks in Advance. I do the following steps: I have created two publications on my SQL SERVER for merge replication Publication A – which returns all rows from the Table1 Publication B – which returns all rows from the Table1 where the field MANAGER =’ABC’ I have two clients who have MSDE Client 1 is subscribed to Publication A and Client 2 is subscribed to Publication B All works fine till now and I am able to make transfers from the two clients and get all the changed data However, now If I change the filter rules for Publication B and set that it should return all rows from the Table1 where the field MANAGER = ‘DEF’ , SQL Server tells me ...Show All

• .NET Development "Cannot connet to remote server"

  Hello, I am facing a bizarre problem when connection a client application to a server. I am developing a client application which connects to a server, instantiates a remote object (singleton) and makes queries to the server via the remote object. The remote object has a method which instantitates another remote object on the server side (factory remote object using interfaces). The client can successfully instantiate the remote object (using interface), because it can call a method of remote object to instantiate another remote object on the server side. However, as soon as the client uses the second instantiatied remote object (to call its methods), then an exception gets thrown stating that client cannot connect to the remote server. Wh ...Show All

• SQL Server SSIS Expression result limit of 4000 bytes

  I have a package with an input column that is varchar(8000). I want to strip the first byte off of this column and put it in one result column and the remainder of the field I want to go to a second column. If the input column is an empty string, I want to return NULL. Pulling the first byte off works fine, no issues, however putting the remainder of the input column into an output column is giving me a little trouble. If I use this expression: LEN(FLD1) == 0 NULL(DT_WSTR,1) : SUBSTRING(FLD1, 2, LEN(FLD1) - 1)) I get an error that says my expression evaluates to a string of greater than 4000 bytes. If I do this instead: LEN(FLD1) == 0 NULL(DT_WSTR,1) : RTRIM(SUBSTRING(FLD1, 2, 7999)) The expression passes muster but ...Show All

• Visual C# Problems with Generic Collection class.

  Hi I’m working on a system that has 4 different types of client they have mostly the same attributes so I decided to create an interface IClient for them to implement and then just add the differing attributes as needed to each client class. Now I get the Client information from a DB and Load them into a Generic dictionary The class looks like so class Class1 <T> : Dictionary < int , T> where T: IClient { private IndemnityScheme scheme; public Class1( IndemnityScheme scheme) { this .scheme = scheme; } public int Load() { ...Show All

• Visual Basic Mouse right click

  how to disable Mouse right click in textbox control one way would be to set the contextmenu of the textbox to an empty contextmenustrip item. This would pretty much show nothing and is the only option they have of selecting an item from teh list. so drag a ContextMenuStrip to your form select textbox change the ContextMenuStrip to the ContextMenuStrip you just dropped on the form. ...Show All

• Visual Studio Team System postbuild event

  Hi, Would it be possible to add a postbuild event feature to the database project I have a scenario where I would like to run aspnet_regsql.exe utility to install/merge the ASP.NET 2.0 services database into the database that I am building with VSTS-DB. I basically want to avoid creating the ASP.NET services db schema by hand (or even importing .sql files) -- I'd rather run their tool and point it at the database created by the build. The postbuild event could provide some macros (e.g. Target database name, connection string, etc) that I can then use as command-line switches to aspnet_reqsql.exe. Thanks, Vitaly Tilli - I'm having difficulty reproducing the issue that you are encountering. I ...Show All

• SQL Server Corrupt file error when trying to install SQL Express.

  I am receiving error about corrupt file when trying to install SQL Server Express. I have tried using SQLEXPr.exe as well as SQLEXPr_ADV.exe. They both gave the same error. I have run msiinv and found that SQL Server is not installed. I do have Office Professional 2007 Beta 2 installed. I do not know if this may be the problem with the installation. Do I need to uninstall Outlook 2007 w/ Business Contact Manager Beta 2 Install SQL Server Express 2005 then reinstall Outlook 2007 w/ Business Contact Manager Beta 2 I am running Windows XP Pro. I tried this on another machine and received same problem. I will verify that SQL Express is not showing up on this one, but pretty sure it is not. It does not have Office Professional 2007 Beta 2 ...Show All

• Windows Forms Updating mulitple tables on the same form

  I've got a form with textboxes and comboboxes for Instruments and InstrumentDetails. My dataset has these tables with a data relation/FK constraint which I consider one-to-one (One detailID to One InstrumentID) The child table's ID is set as the primary key, with no auto-incrementing. I've tried setting the datarelation to Relation Only and Relation+FK Constraint. I've successfully made updates to related rows using the .GetChanges method and .Select method in conjunction with the datarelation in my dataset. However, I have ZERO success when it comes to adding records. Since my Instruments table is the parent, I know I must update this one first before adding child table rows related to the new parent record. However, on my form, after ...Show All

• SharePoint Products and Technologies Auto create a workspace - event handler or workflow designer?

  Hi - what would be the quickest way to have a workspace automatically created when a check box column is ticked for a list item Basically we need to replicate the functionality available in a calendar list where you can tick the checkbox to create a workspace when adding a new item but we need it for a Task and Issue list. From what I can tell, some level of coding is required but if anyone knows a way of creating this functionality without code that would be ideal. Otherwise whats the best design for coding this Darren, I wouldnt recommend it, but if you must, I would go with an event handler and not a workflow. Both are a-synchronous, so if the site creation fails the user will now know about it ...Show All