Phil Pownall's Q&A profile

• SQL Server adding a new data column (not derived) midway thru a data flow

  I need to know what a table's max row Identity is part way thru a data flow.  I can't get it at the beginning of the data flow.  I need to either (1) add it to the data buffer part way thru or (2) set it into a package variable and then reference the var in a script component. I've not found a way to add a database column to the data buffer without doing a lookup for each row (too slow and not appropriate here) or some goofy oledb source and then merge join into the data buffer on a contrived join. I've read questions about referencing package vars in scripts but I can't get that to work.  DTS.V ...Show All

• SQL Server Limited number of assemblies available in Visual Studio SQL Server Projects

  Hi, When starting a SQL Server Project in Visual Studio, there are a very limited number of assemblies available to reference. Does anyone know why Specifically I would like to use "Microsoft.AnalysisServices.AdomdClient". Does anyone know how I could do that Best Regards, Johan Ahlen, IFS Hi, if you want more than these one, you have to register them in the GAC to see them in VS. The ones listed were intensivly tested by Microsoft not to produce any memory leaks being threadsafe etc. Additional (custom) resources have to be listed first for the computer and marked with the ...Show All

• Smart Device Development Targeting a Framework Version?

  Hi comunity, i create a tool with framework 2.0 Beta and its works fine, but how can i target older framework, i the current pc dont have framework 2.0 installed, only 1.1 Version I want that my application runs on pc's with Framework 1.1 and 1.0!!! thanx mirsad Hi, i see that but it was to late to change! sorry forum! mirsad ...Show All

• Software Development for Windows Vista WWF HandleExternalEventActivity Problem

  Hi I have two states in a state machine workflow [Start] and [Process]. The [Start] state has a CallExternalMethodActivity with uses a ExternalDataExchange interface, and runs a method called GetEmployee() Inside the GetEmployee() function I raise an event as so: EventHandler myEvent = EmployeeRecieved; if (myEvent != null) { myEvent(null, new MyEventArgs(instanceId)); } The instance id is set in the GetEmployee() function: instanceId = WorkflowEnvironment.WorkflowInstanceId; Then in state [Process] I have a HandleExternalEventActivity, Which handles for event EmployeeRecieved. The issue is I get the following error when ...Show All

• Smart Device Development Open menu under program control

  I'm writing Pocket PC program which will use a special keypad. I want to open the menu items that appear on the menu bar under program control so a user can see the "subchoices". I'm using visual basic. ...Show All

• Visual Studio Express Editions Binary to Number... Maybe vice versa

  Hello, Once again, I have a question My question is this: How can I convert Binary a Number and vice versa I've seen simple PHP pages do this but I can't find anything online about this. If there's an algorithm, then please tell me, I'll try to implement it. Thanks for any help! Keehun Nam This might give you a start: Add a button and two Textboxes to a form. In the Button's Click Event put the following code: Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click If TextBox1.Text Like "*[!0-9]*" Then TextBox1.Text = ...Show All

• Visual Studio Team System Permissions bug?

  Scenario: userAdmin is a member of [SERVER]\Team Foundation Administrators userAdmin is also a member of [SERVER]\DevTeam [SERVER]\DevTeam have the following permissions (nothing derived): Access source control Create a workspace Fire events View server level info View system sync info Creating a Team project Now, creating a new team project logged in as userAdmin fails: User userAdmin needs the AdminConfiguration global permission(s). Workaround Add the following permission to [SERVER]\DevTeam: Edit server level info Bug Is this intended If userAdmin is a member of [SERVER]\Team Foundation Administrators, shoulden't this override th ...Show All

• SQL Server Server Crash SQL 05 on Win2k

  I know as you read this you will think that the problem I describe is unrelated to SQL server, however the problem that I am going to describe only began to occur after SQL 2005 was installed, and is beginning to happen with more frequency. So here goes... O/S = Windows 2000 Server SP4, PDC with AD 2003 extensions, DNS, DHCP SQL Server 9.00.1399.06 The problem starts with an event logged as Source = Application Popup Event = 26 Description = Application popup: vsjitdebugger.exe - Application Error : The application failed to initialize properly (0xc0000142). Click on OK to terminate the application. After this error starts it con ...Show All

• SQL Server .net StoredProc

  Hi, I'm trying to use a LDAP request to simply fill a table.  I want to use the database agent to schedule the insert every night. So I was trying to make a storedproc to do it, but I can't make a import of "System.DirectoryServices".  Many references types look to be unavailable.  How could I do it Some ideas Regards Jacques Hi. I find it easier to create a normal classlib and do the "create assembly", "create function", etc. myself. Your assembly must be marked EXTERNAL_ACCESS. ---- Snippet -- Delete all dependent objects from the assembly DROP FUNCTION SomeXYZ -- Drop and ...Show All

• Windows Forms Connection error when application deployed via Click Once

  I'm getting an exception when I'm attempting to run a database application that I've deployed via Click Once. The Application uses User Instances to connect to a the database file, but if I run it through the Shortcut placed in the Start Menu, or if it attempts to start up after installing it from the Publish Site it has the following error. An attempt to attach an auto-named database for file C:\Documents and Settings\Administrator\Local Settings\Apps\2.0\Data\K07EP42J.YP8\90GXYVXE.12R\phot..tion_a43878dd5ac33e16_0001.0000_aff308a14936b643\Data\PhotoAlbum.mdf failed. A database with the same name exists, or specified file cannot be opene ...Show All

• Software Development for Windows Vista Developing a Distributed Workflow

  Hi group members Hope u be doing gr8 with WWF , well did any body try a distibuted (but tightly coupled , as the complete objects/context may also be needed to be passed) Work Flow in WWF . Like couple of activities run on Machine A then Other on Machine B (see figure below ) Machine A                  Machine B                   Machine C Acttivity 1                      ...Show All

• Windows Forms ContextMenuStrip

  Is it possible (maybe through custom renderer ) to modify the scroll arrows at the top and the bottom of the ContextMenuStrip control. Create a contextMenuStrip, set the Size to 200,500. Add 30 Items. Since there are more items than can be displayed, there are scroll buttons at the top and bottom on the context menu. How can these be modified. I want to change the size and shape of the arrow. Thanks, Sean And while you're at it, how do you add mouse wheel support to a context menu. ...Show All

• .NET Development Still unable to compile vb asp.net code behind using command line

  Hi, I am still unable to compile my code behind using the command line: vbc /t:library /r:system.dll,system.web.dll,Microsoft.VisualBasic.dll,system.data.dll, system.drawing.dll  filename.aspx.vb I was able to resolve most of the compiler errors I got earlier except for this one: error BC30451: Name 'Color' is not declared.  PremiumTable.BorderColor = Color.Navy I declared in the beginning of my class the following: Imports System Imports System.Exception Imports System.Data.OleDb Imports System.Data.OleDb.OleDbError Imports System.Data.OleDb.OleDbErrorCollection Imports System.Data.OleDb.OleDbException Imports Micros ...Show All

• SQL Server How to sort that does not include duplicates in display?

  Hi everybody,    I like to asked anyone who is very good at sql to help me display this data in a table format that duplicate headings, subheadings or other columns won't appear twice or more. Can anyone help me I need to sort them and load them in a Datatable. Loop thorugh all records and display them in a label control created at run time. Thanks in advance. Sample Data: Topics Table TopicId  TopicLevel  Topic          ParentId 1           1        First      ...Show All

• Visual Studio Tools for Office Can't install Visio 2005 after installing VS2005 Beta 2

  Hi, Can't install Visio 2005 after installing VS2005 Beta 2. The Visio 2005 Beta 2 Installation program will popup with a message " You must first install Visual Studio 2005 Beta ." Visual Studio 2005 Beta Which is already installed. Regards, Abdoessalam This also works if you install VS 2005 RTM as downloaded from MSDN, and then try to install Visio EA 2005. Used Orca to edit the VisVea.msi file, did the trick, install went without a hitch. ...Show All