bxchan's Q&A profile

• SQL Server Mapping Package Variables to a SQL Query in an OLEDB Source Component

  Learning how to use SSIS... I have a data flow that uses an OLEDB Source Component to read data from a table. The data access mode is SQL Command. The SQL Command is: select lpartid, iCallNum, sql_uid_stamp from call where sql_uid_stamp not in (select sql_uid_stamp from import_callcompare) I wanted to add additional clauses to the where clause. The problem is that I want to add to this SQL Command the ability to have it use a package variable that at the time of the package execution uses the variable value. The package variable is called [User::Date_BeginningYesterday] select lpartid, iCallNum, sql_uid_stamp from call where sql_uid_stamp not in (select sql_uid_stamp from import_callcompare) and record_modified < [User ...Show All

• Windows Forms A quick question on modules

  Hi there, I have a module that contains a few public methods. These methods can be used in any part of the project but I don't want them to be used by other sections of the project except for my own section. In other words I my project contains a module for 'Customers' and also a module for 'Vehicles', I don't want the section of the project of 'Customers' to be able to view/use the section of 'Vehicles' How can I achieve this Pikker1981 wrote: Hi there, I have a module that contains a few public methods. These methods can be used in any part of the project but I don't want them to be used by other sections of the project except for my own section. In other wor ...Show All

• Visual C++ UI Unresponsiveness in CWnd derived control

  Hello, I am currently working on a MFC project that has a control that is derived from the CWnd class. Inside of the class, there is code to dynamically create editboxes and other standard windows controls from within the CWnd class. My question is, upon drawing the control on the screen, I can all of the subcontrols (controls within the CWnd derived control class), however when I click inside say an edit box, I do not see a blinking caret, and when I enter data into the text box it fails to update. What would be the cause of such an issue in MFC Sincerely, James Simpson Straightway Technologies Inc. There are many potential causes. I don't really understand what the problem is, except & ...Show All

• SQL Server Remove FileGroup

  I have removed all the files from a filegroup ...when I do sp_helpdb I don't see the filegroup... but when i try to remove the filegroup using ALTER DATABASE <DB> REMOVE FILEGROUP, it says The filegroup 'XXX' cannot be removed because it is not empty any idea... Thanks Ranga Hi I've encountered the same issue. Hi guys, is there a solution for this problem. Below is other post for the same issue. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=446565&SiteID=1 thanks, Larry ...Show All

• Visual C# Fail to Load dll from C# when no VS2005 installed

  Hi, I am running C# application with a MFC dll on VS2005. When I copy the .exe file and the dll to another computer I get the following errer (both installed with .NET 2.0): An unhandled exception of type 'System.IO.FileNotFoundException' occurred in FilesUpdateApplication.exe Additional information: Could not load file or assembly 'StrtData, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified. where 'StrtData is my dll file. When I installed the VS2055 on the computer, it worked just fine. Are there any specific dll's that the 2005 adds is it something that it adds in the installation Please advice, Thanks Idit The problem was that the dll was compil ...Show All

• Customer Care Framework CCF - Context change notification

  Hi, I have written a HostedControl application (App1) where I set the context and then fire context change notification, following is the code: setContext("<testItem>TestData</testItem>") ; FireChangeContext(new ContextEventArgs(Context)); There is one more HostedControl application (App2) where I have overridden NotifyContextChange method so that this application gets notified for each context change. Further, I have hosted both these applications in Agent Desktop. When I select a customer, then App2 gets notified for context change as the customer data gets uploaded in context. However when I fire contextchange command through App1, no context change notification is received in App2. Can so ...Show All

• Windows Forms Locating a program's installation folder

  I have an application that will be used by other applications installed on the client machine if the other applications see that my application is installed. Currently, during installation, my application places a value in the registry that points to the location of my application's executable. When another application wishes to run my application, it can look for this value to locate the executable. This method is all fine and good for now, but we're trying to minimize how much our applications write to the registry. I'm hoping to find a method by which another application could discover the installation folder of my application, perhaps through entries created by Windows Installer during the install process. Unfortunately, I have been un ...Show All

• Visual Basic DecimalPlaces property missing in NumericUpDown?????

  I am writing a Visual Basic application for PocketPC 2003, using Visual Studio 2005. I want a NumericUpDown control with an increment value of 0.1. If I just try to set the increment value to that, it is stored as 0 and the control doesn't work. Reading the online documentation, it looks as if I should set the DecimalPlaces property, but when I look for this property, I can't find it. If I try to change it programatically: myUpDown.DecimalPlaces=1 I get an error, that the property does not exist. Any idea what I am doing wrong, or if this is a bug and if there is a work-around Thanks I just looked at the UP control I am using, and in the properties window, there is a property called DecimalPlaces, where y ...Show All

• SQL Server Deployment and Configuration

  Hi: I have a SSIS package on my local machine, and would like to deploy it to DEV server. Which files should i be moving to the SQL DEV Server and where How do I modify connection managers or is there a way to do that from the Management Studio or some other way Thanks and I would definitely appreciate some prompt advise. If the only thing that needs to be changed/configured is a single connection string, and you have only one package (no parent package calling child packages)...you may want to use the SET option of the package execution command line instead of package configurations. I don’t like that approach when I have many packages that need to be configured in the same way; as I have to maintain every command line, as o ...Show All

• Windows Search Technologies WDS 3.0 Beta 2:Scanning network drives

  Hi, In WDS 2.6.5 it was possible to scan network drives. In WDS 3.0 Beta 2 this is not possible. When will this feature be returning. As it stands, due to My Documents being redirected and other files being stored on network locations WDS 3.0 isn't much use in a corporate environment. Cheers Janson We're working to bring that feature back soon. For the time being we recommend that users who rely on indexing mapped drives (or are in a corporate environment in general) stick with the latest official release, which is WDS 2.6.5. ...Show All

• Visual Studio Express Editions Help an old school guy out!

  Hey, I've started using the Visual Basic 2005 Express edition stuff. and I have a question. I can get the GUI to do a lot of things and its awesome. I'm also not having issues with the app connecting to a database and displaying data, I am however having issues getting data from the table while NOT using the WISWIG stuff. what I mean is I need to get to the point where I can write a SQL statement and return, add, count or scan through a table with elements that are NOT of the form but in the forms. Simply I just need to get this stuff so I can move around Rs.AddNew Rs.Update Rs.RecordCount Rs.MoveNext Rs.MovePrevious Using the SQL server 2005 express edition I am old school myself C to C++ to C# so I know how it feels. ...Show All

• Visual Studio Express Editions how to check the version of Excel ?

  Hi. I have a program that inserts some data from a database into a listview, and if the user clicked on some button it will export all data into an excel sheet using Office Excel Primary Interop. How can i check if the user has MS Excel at the first place, and if ture what is the version of it Thanks in advance. Imports xl = Microsoft . Office . Interop . Excel Dim x As New xl . Application Dim V As String = x . Version ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Help What do I need to download so I can connect to my 360 for XNA?

  What do I need to download so I can connect to my 360 for XNA Do I need to download windows media connect You need to go to your 360, go on XBLMarketplace, go to Games, New Downloads, and find XNA Creators Club. There you'll find both the Download you need (8MB) and the Memberships, prices vary depending on where you live. ...Show All

• Visual C++ Very slow linking on VC2005

  We have been using VC6 for a very long time for our 1M line program. When vc7 became available we ported the code to this platform. After sitting back and waiting for 5 minute links for a couple of months we went back to vc6 with a sob. The reason was the /PDBTYPE:SEPT being removed. Now that vc8 is available we again ported all of our code up, an effort that has taken about a manmonth so far. We had seen some posts on MSDN where Microsoft people indicated that slow linking on vc7 was a concern, so we had some hopes that the bubble sort causing all this was being replaced... All to be faced with what is now a 9 minute link time. It is becoming increasingly impossible to go back to vc6 again as we also link third party librar ...Show All

• Visual Studio Team System Migrating Work Items while preserving the same IDs

  Is there a way, or a tool, or documentation of how… to migrate Work Items from a team project on 1 server to a team project of the same name on another server… while preserving the same IDs Hello, You can move Work Items from one Project to another using Work Item Object Model, but you cannot preserve the Id's these are system generated and cannot be populated by the user. Here is a helpfull link telling how you can move the work items. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=535837&SiteID=1 Thanks, ...Show All