EricJ's Q&A profile

• Visual C# SQL fails to be recognized by Visual C# Express 2005

  I recently installed Beta 2 of VCSE and also the SQL Server Express Edition, and after being unable to complete some tasks I required that SQL Express couldn't handle, I decided to uninstall it, and install my copy of SQL Server 2000 Dev on the machine instead. Now, VCSE fails to recognize the SQL Server that I installed, and when using the "Add New Connection" Wizard, I am unable to connect to the correct server. If I click on Advanced, the DataSource field is set to .\SQLExpress, and I am unable to change it. Is there some way to correct this issue Any help would be greatly appreciated. Thanks ^_^ Hi all, ...Show All

• SQL Server Selecting Connection in Custom Destination Component UI

  Hi there, I am writing a Custom Destination component with a custom UI. The UI contains a combo box which contains the connection names of type “FLATFILE”. I also have provided a button which would create a new connection of type “FLATFILE” by making a call to CreateConnection method of IDtsConnectionService. The combo box gets properly updated showing the connections of type “FLATFILE” but on clicking on the new Connection button the application hangs up. Am I missing something or is there some other way to do it The function are the events handlers which are called by the UI. void form_GetC ...Show All

• SQL Server Use opendatasource

  I want using opendatasource, to insert given in an file .xls without formatting some, an file .xls simply created and saved. Then I want that a application one that this in machines goes customers in my net, activates one procedure that I go to create with this opendatasource and carregue the archive .xls that goes this in these machines customers tb, remembering that the bank this in a server, thus I want to know as I must place date source for the file in opendatasource to load the file .xls. Moreover also necessary to know if I have that to place plus some thing in the line of code for insertion of the data, therefore in the test that I m ...Show All

• Visual Basic Seemingly trivial question - why is a property an array?

  Kinda new to this objects game, but the following trival code runs and, on the last console.writeline will give an IndexOutOfRangeException but I was rather expecting at least a compile time error let alone the property acting like it was an array, what basic faux-pas have i dropped here:- Dead Simple Class:- Public Class Bob Private mfield As String Public Property aProperty() As String Get Return mfield End Get Set(ByVal value As String) mfield = value End Set End Property End Class And here is some quick test code off the back of a button click:- Dim anObject As New Bob anObject.aProperty = " ...Show All

• Software Development for Windows Vista MSDN Problem..,

  In MSDN WinFX Software Developer Kit, In class Library Reference.., If I go to System.Workflow.Activities namespace, I can't able to view the webpages.., http://winfx.msdn.microsoft.com/library/default.asp url=/library/en-us/cpref/html/N_System_Workflow_Activities.asp Can anyone of you say why it is not working Remaining and all namespaces are working properly but only System.workflow namespace is not woriking properly. Sekhar Ragu If you installed WF extensions, documentation should be there. It is not integrated in VS - look in programs->Windows Workflow Foundation->Windows Workflow Foundation Hel ...Show All

• SQL Server Looping through an excel spreadsheet

  Being new to SSIS I wish to loop through a series of excel spreadsheets and within each workbook loop through each sheet. I am aware of the For Each container but how can the each sheet in the workbook be referenced Steve Thanks Jamie, my problem is for each spreadsheet I loop through how do I reference each sheet / tab within the spreadsheets returned by the For EachLoop. Thanks Steve ...Show All

• Windows Forms stand alone WinForm testing in VS 2005

  Hi, Is there any way I can test a winform (eihter .exe or dll project) without building the whole project for the UI look and feel purpose in VS 2005 I guess, old days from VBA, we can test a form in Excel or Access just to look at the appreance of the form without testing the interactions. It will be useful when we are building a class library project, where we sometimes don't want to test the functionality but just to have a look at the form in runtime. Thanks The Object Test Bench allows you to test instances of your classes by invoking methods within Visual Studio. You can access via View -> Other ...Show All

• SQL Server Guide to Setting Up the Different Data Mining Operations

  Unfortuately, the documentation doesn't seem to really provide the process to setting up the various mining operations (clusters, trees, etc.). So I am sitting there, trying to figure out what it is asking for when I try to set up a K-means cluster. Is there a better guide available The hands-on lab is actually using Beta 2 of SQL Server 2005 instead of the latest CTP.  Hope this gets updated as a lot of people want to dig in to these new features of SQL Server 2005. ...Show All

• SQL Server Merge replication with anonymous subscribers and identity columns

  Hi, I read the BOL on how the publisher will had out identity ranges to subscribers, but it was not clear if this was also the case for anonymous subscribers. Will merge replication with identity columns work with anonymous subscribers that sync via HTTPS Thanks, Darrell Young ...Show All

• Software Development for Windows Vista HandleExternalEvent: event filter / correlation

  Hello folks, I am new to WF and I am completely baffled by correlation. What I am trying to do is very simple: I have a State workflow activated by a single event from my local service with a parameter in the event args to do the disambiguation. The HandleExternalEvent activities knows those values at design time, but not at compile time. What I wanted to do initially, and what is my preferred solution, is to derive a new class from HandleExternalEventActivity, add a design-time property that will match the eventarg and filter the events for events matching the property. The problem with this approach is that HandleExternalEventActivity's vi ...Show All

• Visual Studio Team System config file for App Under Test is not used when executing test

  I have found what I think is a bug in the Unit Testing Framework: If your App Under Test (AUT) has its own config file, that config file will not be used when you run a test against it from within the IDE's Test View. I have a complete Visual Studio solution which demonstrates this behavior if anyone wants me to email it to them but here is the gist of the example: I have an AUT which has an app.config file that contains a string value: Test_String="Hi There" < xml version="1.0" encoding="utf-8" > <configuration> <configSections> <sectionGroup name="userSettings" type="System.Configuration.UserSettingsG ...Show All

• Visual C++ audio input?

  Hey there, just wondering if anyone knows of a simple way to get audio input from a microphone. What I want to do is build a neural network, train it to recognize commands, and then have it execute files and or tasks based on those commands. In addition, if anyone knows how to call external programs, that would be very nice to know as well -I have a good book on the windows API which I imagine I will need to read to figure this one out though, as I imagine there is no simple way to do this. Thanks At some point someone is going to come tell you to look over at the newsgroups. But before they do ...Show All

• Visual Studio Team System Publish Operation Failed for Custom Test Type

  Hi there, When I try to publish the test results from a run of a custom test type, I get "Publish Operation Failed." When I include the test in a build, the build log also displays the same error: Results file:      C:\SecureBuild\AdventureWorks\Build_0111\TestResults\TFSSERVICE_VSTSL05 2005-11-18 17_30_02_Any CPU_Debug.trx         Run Configuration: Local Test Run         Waiting to publish...         Publishing results of test run TFSSERVICE@VSTSL05 2005-11-18 17:30:02_Any CPU_Debug to http://vstsl05:8080/Bui ...Show All

• SQL Server Need to create <Query> statement programmatically

  I am creating a web application that uses a using a web service to get data for my reports. Since the webservice only accepts 1 parameter called "sql" (the sql select statement), I am using the report's query string to get the data. Here is the data source and dataset info I am using: DataSource Name: WebService Type: XML Connection string: http://localhost/myWeb/myWebService.asmx Credentials: No credentials DataSet Query tab: Name: WebService Data source: WebService Command type: Text Query String: <Query><SoapAction>......</SoapAction></Query> Here is a sample of the < ...Show All

• Visual C# Video Analysis Tool

  I am looking into producing a piece of software for analysing golf swings on recorded on video. My software needs to provide the user with the ability to load video files and then draw (lines, dots etc) on top of the video. Time permitting, I would also like to be able to 'do things' with the videos e.g. be able to adjust brightness, contrast and possibly even superimpose a video faintly on top. For example, the swing of Tiger Woods could be imposed faintly on top of John Doe's swing to highlight the differences in the two techniques. Please could somebody give me an idea of how these things can be done Should I be using DirectX Can these th ...Show All