Thomas Jakobsen's Q&A profile

• SQL Server Error Executing Parallel SQL Tasks

  I have three SQL tasks executing in parallel in an Integration Services package.   +-B-+ A-+-C-+-E   +-D-+ It starts with task A; then B, C, and D all execute in parallel; and finally task E runs after BCD are done. B, C, and D are all Execute SQL tasks, all with the same connection manager. Here is their code: B) SELECT CASE WHEN COUNT(*) = 0 THEN 0 ELSE 1 END AS Process      FROM ...Show All

• .NET Development Performance of ADO.Net in CLI Console app vs Windows Forms app

  I have been playing with ADO.Net and at first, I created a CLI console application, where I did different things, such as querying the schema collections of a database. I then created a Windows Forms application and did similar things (wrote code from scratch). What strikes me is that some simple calls that took no time under the console app now take a long time under Forms. I use VS C++ and SQL Server 2005 Express on a Win2000 PC and the ODB ...Show All

• Visual C# Strategy: Draw Large Map without Flicker and Save time.

  Hi ,master For plotting large map, My strategy is to set the overall map size to scrollbars. when scrolling, I judge which partion of my map need redraw,then draw it. which will cause to reduce the time it needs to redraw map. About flicker, I can solve it. I used to use MFC and I am new for WinForm .Could you tell me which methods or properties of WinForm to use I put a picture control, HScrollBar,VScrollbar into Form ...Show All

• Windows Forms DataGrid Displaying two Tables

  I have a windows form that has a datagrid on it. The datagrid is filled with a dataset that contains two tables with a relationship. Basically a parent child relationship. I call my datagrid datagrid1. When the datagrid loads the parent information& ...Show All

• SQL Server Sql Express SP1 upgrade

  I have Sql Server Express installed and now wants to upgrade to Sql Server Express SP1. Do I first have to uninstall my current version of Sql Server Express or can I just run the install Thanks! First off I would make sure that you have valid backups of the database files so that if you do have problems you will be able to back out the changes or just reinstall. But to do the upgrade I would have a l ...Show All

• Windows Forms CHild close when parent form closes

  Hi all, I have a parent form that instatiates and shows a child form. Is it possible to have the child form close when the parent form closes  Is there a setting I should set for this to occur. Thanks for your time in this.  ...Show All

• SQL Server "SQL Everywhere" is a Sybase trademark

  It's all well and good that Microsoft has finally entered the well-established mobile database market (the market that iAnywhere Solution's SQL Anywhere product current *owns* by a wide margin). However, it should be noted that "SQL Everywhere" is a Sybase trademark. For confirmation of this fact, see http://infocenter.sybase.com/help/index.jsp topic=/com.sybase.help.mro12.6.mro126ig/html/mro126ig/legal.htm For confirmation of th ...Show All

• Windows Forms A Form owned only by MDI child

  Hi, I would like to know how can i display a new form (NOT one of the MDI Childs) above only a specific child, i mean when i will select a different MDI Child form i will not see the new form and when i will switch to t ...Show All

• SQL Server Alternate Synchronisation Partners

  Yes, I know synchronisation to alternate partners is deprecated in SQL2005 but.... In SQL2000 there is a Sync Partners tab in the publication properties dialog that allows you tick a checkbox for each co-publisher to be enabled as an alternate synchronisation partner. What is the equivalent in SQL2005 I've set up replication in SQL2000 following these instructions http://support.microsoft.com/ kbid=321176 and it works. Now I'm trying to do ...Show All

• Visual C# How to get all drives of my computer

  I want to get a list of all my drives.how to Hi, Use Environment.GetLogicalDrives(); -chris ...Show All

• Visual C# Generics Question

  After some initial problems, generics work fine but i still have one little problem. The inheritance list of my object is very simple: i have a base class (MyObject) and some derived classes (MyObject1, MyObjet2,...). I have defined an ObjectList: public class ObjectList <TKey, TValue> : SortedList < int , V> where V: MyObject   For every derived class i have declared an ObjectList, and it works ...Show All

• .NET Development Launching a COM server from a service on WinXP 64-bit

  I have a 32-bit application that gets launched by a service. It is basically an MFC out-proc server. On a 64-bit machine, I am seeing an issue where a client is unable to communicate with this COM server. My assumption is since the application which is 32-bit is getting launched from within a service, there is some kind of a security issue. The COM error I get is 80080005. Is it possible at all to have a service launch a 32-b ...Show All

• .NET Development Help getting started on serial comms

  Hello All I need help in starting to experiment with serial port comms. I have a device ( a gas analyser ) that I would like to read the output from via the serial port. I dont know what data it sends so my attempts to read text and byte data have not been succesfull. It has a row of LEDs showing ppm ( part per million) . What I would like to do is emulate those LEDs on the PC monitor. Where do I start Thanks     ...Show All

• Visual Basic TextBox array

  I am upgrading a program that I wrote in VB6 to VB2005 and am having trouble with textboxes. In the VB6 version, I used an array of textboxes to display and order text on screen according to it's priority. This was done in a module. The VB6 program takes a new message, checks it's priority (assigns the texbox color according to priority) and then adds it into the array according to the textbox color and arrival sequence of both itself and the ...Show All

• Smart Device Development Hardware Buttons and AssociatedControl NOT staying associated

  I just upgraded a Dell Axim X50V from Pocket PC 2003 to Mobile 5.0.  This worked without any problem until the upgrade.  Now the buttons will not stay associated.  On the 20th time (20 button presses every time) of pressing the button (or any combination of associated buttons), they are not associated any more and revert to their preassigned apps. Any suggestions would be appreciated. Thanks, Steve Even with this simple ...Show All