ThompsonMcG's Q&A profile

• SQL Server Help Designing an App. to be Run from a Job

  Hello, I'm working on a project that uses SQL Server 2005 and C# 2.0. I need some ideas of the best way to design/implement an application that will be executed from a SQL Server job. The general idea is: a SQL Server job will call [ something ] and pass a couple of parameters to [ something ], then [ something ] will query a database and gather other information, then [ something ] will do some processing of data, and finally [ something ] will output the results for end user consumption. The problem is that I don't know what [ something ] should be. Should it be a C# executable (but it can have no UI) Should it be a web service ...Show All

• Visual FoxPro Pageframe and Pages

  I have a pageframe with 5 pages. Each page is linked to different table; the table each linked by unique field.  I also have the wiztxtbtns at the bottom of the form outside the pageframe. This is what I want to achieve.When I run the form, all the pages should show details pertaining to the first record. Also, when adding a new record, I give the new key field number and it should accept details for that on all pages and when I hit Save, the details should get saved. The same has to happen when I use any of the keys like Next, Prev etc... If key field value is 1 on the first page, it should be the same on the o ...Show All

• Visual Studio Name of EventHandler called when Compartment item is selected?

  Hi all, I've been playing with the tool for a while. I'm trying to override the event handler which is called when an item in a compartment is clicked. I've searched and searched to no avail. I've digged around classes like ContainerShape, CompartmentItem...etc. Here is what I'm trying to achieve. The item in the compartment of a container has some property that points to some other compartment item (possibly in other shape). When the item is selected on the compartment (i.e. highlighted), I want to read the value in the property in order to make some changes to the compartment item which the selected item is pointing at. ...Show All

• Visual Studio Express Editions Starter Kits ?

  Hi I like the starter kits how many starter kits are out there and where can I find more of them and do you need the express editions to use them or can they be use with any other visual studio edition (std , pro , team) Thanks you Hi, Keep an eye out for new starter kits in the 2005 downloads area of the developer centers: http://lab.msdn.microsoft.com/vs2005/downloads/starterkits/default.aspx Best, Paul Yuknewicz ...Show All

• Visual Studio Simulating App.config behaviour

  I would like to be able to have App.myconfig files copies to the output directory like AssemblyName.myconfig, like it happens with App.config files. How can I do that without creating the targets from scratch Ovatsus, Just add the following just before the </Project> tag:   <Target Name="AfterBuild"              Inputs="@(MyFilesToCopy)"              Outputs="@(MyFilesToCopy ->'$(OutputPath)%(TargetPath)')" >   <Copy SourceFiles="@(MyFilesToCopy)"   &n ...Show All

• SQL Server Using SSIS 2005 to strip out bad rows in Excel and then insert detailed rows into OLE DB Data Source

  Environment:   Running this code on my PC via VS 2005 .Net version 2.0.50727 on the server (shown in IIS) Code is in ASP.NET 2.0 and is a VB.NET Console application SSIS 2005   Problem & Info:   I am bringing in an Excel file.   I need to first strip out any non-detail rows such as the breaks you see with totals and what not.  I should in the end have only detail rows left before I start moving them into my SQL Table.  I'm not sure how to first strip this information out in SSIS specfically how down to the right component and how to actually code the component ...Show All

• SQL Server Import from adaptive server anywhere 9

  Hi, I'm trying to import data into sql 2005 from sybase sql anywhere 9 (9.0.2.3320) using DTS (using the asademo db). I can select the tables I want to import but during the actual import on Setting Source Connection I always get an OLE DB Error : Could not connect source component. Error 0xc0202009: Source - contact[1]: An OLE DB error has occured. Error code : 0x80040E21 Error 0xc020204a: Source - contact[1]: Unabtle to retrieve column information from the data source. Make sure your target table in the database is available. Does anybody have an idea of what is going wrong here Is there another way of accessing sybase that will work and ...Show All

• SQL Server SQL 2005 Uninstall/Install Problem WMI Configuration related

  Hi, I'm the following encountering WMI error message when invoking SQL2005 setup. The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine CAPRICORN Error:2147942405 (0x80070005). For help, click: http://go.microsoft.com/fwlink LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=setup.rll&EvtID=70342 I'ver found other postings related to WMI errors and tried the WMI fix batch, but to no avail. I noted the error code I have is 2147942405 which is different from other postings. And from examining setup log generated, this seems to be security related, ...Show All

• Visual Studio 2008 (Pre-release) Binding Command to InputBindings

  I'm having trouble creating a MouseBinding for my ListView. Here's the line: <MouseBinding Command="{Binding Path=DataContext.ViewTransactions, RelativeSource={RelativeSource Mode=FindAncestor, AncestorType={x:Type Grid}}}" Gesture="LeftDoubleClick" /> I've used that same binding elsewhere on my page and it works fine. However, when I use it on the MouseBinding, I get this error: Error at element 'RuntimePropertyInfo' in markup file 'MyPage.xaml' : Object of type 'System.Windows.Data.Binding' cannot be converted to type 'System.Windows.Input.ICommand'.. Any suggestions ...Show All

• .NET Development Create mdb file in VB 2005

  Hello, How can i create an Access database (.mdb file) in a VB 2005 project Is this possible Christos Hi there, Here is a best link that could help your problem. http://www.dotnet247.com/247reference/msgs/11/59426.aspx hth, Michael Castillones ...Show All

• Visual Studio Express Editions VB app memory usage

  I noticed that my VBE apps were consuming a lot of memory so I wrote a test app that consists of nothing more than a form with a single button. When I run the compiled .exe file, Windows Task Manager reports the the process is using over 8 meg of memory. If I minimize the app, memory usage drops to 372K. If I un-minimize the app, memory usage then jumps to approximately 2 meg & stays there with each successive minimize/un-minimize. Can somebody explain to me what is going on here Why does it initially have such a high memory usage for such a small app And why does it settle at 2 meg after minimizing once Thanks... ...Show All

• .NET Development Significant slowdown in a Windows service from .NET 1.0 to .NET 2.0

  I recently upgraded a .NET 1.1 application to .NET 2.0 using nothing but the automatic upgrade of the solution. The service continued to run, but the socket performance is really slow. The service uses UDP socket communications (blocking), and was gathering data from printers and copiers using the SNMP protocol (over UDP). Debugging shows that it takes a LONG time for a packet to arrive at the application layer after it has been received by the network interface. Typically, the service would make a request, and would receive a response within 500 ms. Now, with .NET 2.0 it takes up to several minutes. There appears to be something ...Show All

• Visual Basic Date format VB 2005 beta

  Dim mystr As String mystr = TextBox2.Text TextBox2.Text = Format(mystr, "dd MMM yyyy" ) If date typed in as 01-01-2001 in VB6 will give 01 JAN 2001. If date typed in as 01-01-2001 in VB 2005 Beta will give  - dd MMM yyyy Im assuming Im wrong somewhere. Any ideas please. Thanks, Blinky. You need to convert the string to a date, ie: TextBox2.Text = Format(CDate(mystr),"dd MMM yyyy") Hope this helps, Adam Braden Visual Basic Team ...Show All

• Smart Device Development two-state icons on Windows Mobile 5.0 start menu (grid view)

  Some shortcuts on the start menu of a Windows Mobile 5.0 Smartphone show a different icon when they're selected. The Messaging icon shows the slip of paper poking out of the envelope, for example. Has anyone managed to recreate this with their own applications, and if so, how Is there a convention for how the icons have to be ordered in the .rc file or is there a naming convention Is there a URL talking about this in MSDN Thanks in advance, Matt If you want elements of file class "foo" to have different default and selection icons, your registry changes should be done to the reg key: HK ...Show All

• Visual C++ Heap Corruption with #include <atlstr.h>

  In VS2003, I could create a new WinForm project, add #include <atlstr.h> to stdafx.h (no other changes) and the app would build and run fine. If I do this in 2005, with the addition of using /clr instead of /clrpure, there is a _CrtIsValidHeapPointer failure when the app begins to run (no additional code added, just the include). I need to use some code that uses CAtlStrings. Is there a way to get this to work in VS2005 I have the same problem. The repro step is straight forward. 1. using VS2005 (release version) 2. Create a Windows form application 3. change the /clrpure to just /clr 4 ...Show All