Biju S Melayil's Q&A profile

• SQL Server Designing SSIS package to Cater to SQL Queries invloving multiple joins

  I have  a query that works fine in SQL Server, SELECT TC.[TestId] ,TS.[NameId] ,[regressionLevel] ,Mstr.[MethodId] ,users.[UserId] FROM [db_db].[dbo].[TEST] TC join [NEW_DB].[dbo].[Users]users on users.FirstName=TC.Username join [New_DB]..[Method_Master] Mstr on Mstr.Description=TC.Method join [New_DB]..[TestSource] TS on TS.Name = TC.TestName basically there is a join between three tables to repalce all the varchars to the corresponding ID. Please guide me in how should I go about in designing my SSIS package to achieve this requirement.   thanks in Advance   MShetty wrote: Jamie Thomson wrote: Can you not use as many ...Show All

• Visual Basic Reverse Engineering

  I have recently taken over for a programmer who has left for medical reasons. He has left a program with a few bugs and the code is nowwhere to be found. Is there a way to retrieve the code from the .exe using VB 2005, which was what it was originaly written in.. thanks As already stated, Reflector is a good tool but it will take ages to piece together a big application manually; and it cannot retrieve variable names, comments, compiler directives etc .. ie the stuff the compiler discards. You really need to try all routes to source the code .... I presume someone has been in contact with the previous developer Richard ...Show All

• Visual Basic adding minutes to the clock

  here's what i'd like to happen... show the current time, you input an integer, click a button, and show future time as (current time + number of minutes inputed in textbox1) label1.text, label2.text, textbox1.text, button1 label1 show current time. textbox1 = you input number of minutes to add to current time click button future time = current time + number of minutes to add label2 show future time i don't want to change the clock, just show what time it would be in inputed # of minutes. anyone know the code to make this work thank you very much! mm123 You can use a number of methods Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e A ...Show All

• Windows Forms Adding Objects Question

  hi my Form1.h file is becoming massive now even though it doesnt really do much. On my Form i have a tabControl with 3 tabs and i was wondering if there was a way to create another file to do some adding and removing of objects like textBoxs and labels so it can be used like a subroutine any help or advice would be great. thanks Im using Visual C++ MS VS 2005 Yep, I got it. You made two mistakes: - You didn't leave the declaration for the button1_Click event handler in Form1.h - You forgot to put Form1:: in front of button1_Click in Form1.cpp I'll email you the files back. ...Show All

• Visual Studio Team System How to login as a different user to Team Server?

  I have Team Server installed and I have been testing with it for a bit but have come across a problem.  I have the Server running in a VM and have created another user on the local system that I want to log in as.  Then I gave that user permissions to use TS.  On my client machine I had been accessing TS as administrator and must have checked the "Remember Password" box on the login screen in VS.  Now I can't figure out a way to logout and log back in as the new user.  Seems like it should be easy. Thanks, Adam Hi, Shenry Yes, that is correct; Team Server site where Team Explorer is connecting will refuse connection using IE. This can be a problem if ...Show All

• Smart Device Development Send keys on smartphone

  Hi all, I'd want to know to send a key in my application. I just want that my application go back at the begenning of the phone, as if i presse the "Home" key (the key with a little house on). So i think i have to use keybd_event or PostKeybdMessage but i don't know what are the arguments that i can use. I know the virtual key word for home: is 0x24. I just want when i use cameracapturedialog to close correctly the application and not have the capturedialog after exiting my application... [ DllImport ( "coredll.dll" , SetLastError= true )] internal static extern void keybd_event( byte bVk, byte bScan, int dwFlags, int dwExtraInfo); [ DllImport ( "coredll.dll" )] ...Show All

• Software Development for Windows Vista Custom queue and persistance

  Hi, I created a custom Activity implementing IActivityEventListener to manager my own events. My problem is when the workflow host is closed and relaunch, all events registered previously are not recreated during rehydratation and my activities aren't responding anymore. How can i solve this Do i need to persist each queue myself If yes, where (or when...) should i do that Thanks for any help, Hadrien Subscriptions are normally created in IEventActivty.Subscribe(). (I also tried to recreate them during OnActivityExecutionLoad() but without success.) The queue management is very similar to the one showed in the CustomActivity Framework sample... I insist on the fact that this problem only occurs in close ...Show All

• SQL Server Error or Bug? Field in dataset won't display on report

  I've got a report with 6 datasets. Each dataset has a field labeled LastUpdateDT which basically shows the last time data for that dataset was updated. All the datasets are called via the same stored procedure in the SQL database. I pass a value in to select the appropriate dataset to be returned. Each dataset returns the same fields, the only difference is the meaning of the data in each dataset, all field names and types are identical. I'm having a problem with 2 of the datasets in the report. Each dataset is displayed in it's own table in the report. When I add the LastUpdateDt field for the 2 problem datasets to the tables, it ALWAYS comes back empty. If I run the stored proc, the LastUpdateDt field has data, if I query the dataset ...Show All

• Commerce Server web service authentication

  Hi I've followed the installation procedures in both the CSharpSite and StarterSite guides, and made sure that all database access is correct, the application pools have the right identity and loaded the authentication store XML files into azman then set the identity for the roles within it. The error I'm getting when I run the web service in IE is: System.Web.Services.Protocols.SoapException: Authenticated identity not available. The current method requires a valid IPrincipal object to be set on the current thread and with the "IsAuthenticated" property set to true. If the MarketingContext is running in ASP.NET (for example, in a Web service), ensure that "Anonymous access" is not enabled for t ...Show All

• Visual Studio Team System Error while connecting to team server.

  Hi, I am using both visual studio 2003 and 2005. I installed Team explorer and MSSCCI provider to work with team system. I can use source control with visual studio 2003 but I can't use the source control in visual studio 2005 and is disabled after displaying the following errors. "This plugin is intended for older version of Visual Studio. Please use Team Explorer." "There was a failure while initializing the Team Foundation Server MSSCCI Provider source control provider. You cannot use this provider to perform source control operations" Thanks in advance . Check to see that you are using the correct plugin in VS2005. From the VS2005 main menu go to Tools>Options When the Options dialog opens navigate to ...Show All

• Windows Forms hiding control changed its location

  I have a control added to a groupbox and another control added to the main form which have the same location. The two controls can "alternate", that is, when I click on the first it is hidden and the second is shown and viceversa. The application starts with the second control hidden. My problem is that when the first control is hidden it changes location and the new location is eqaul to the old location plus the size of the second control plus two. What's wrong   Peter Ritchie wrote: What do you mean by "copies". Do you mean you drag-copied the control in the Designer, or you're doing something like: Button button1 = new Button(); button1.Location = new Point(10,10); Controls.Add(butt ...Show All

• SQL Server ORDER BY, only orders by the first character?

  Hi, I am using a stored procedure that is databound to a dropdownlist. The stored procedure works fine, aside from the fact that the ORDER BY only sorts the list of items using the first character in the cell. E.g. The numbers 1, 20, 100 and 200 would be ordered as follows: 1 100 20 200 clearly i am doing something wrong and i apologise if it is a stupid question, but could anyone please offer me some help Thank you, Shep Sorry I haven't fully explained myself (i missed the most important part, my apologise!) i am working in units of voltage & power, so there for the listing would be as follows: 1kW 10W 100W 20W 200W so i dont think its an option to ...Show All

• SQL Server Rights for clickonce Report Builder access?

  I'm attempting to grant rights to Report Builder as deployed as part of my TFS install. My problem is that I have to add my users to the builtin\admin group in order for them to see the report builder button on the SQL Server Reporting homepage & then have rights to launch the ReportBuilder click once app. I obviously do not want make users admins on the box, but I've tried adding them to all of the other groups having to do with SQLServer to no avail. How can I grant users access to launch the Report Builder app I started with that: the users see the report builder Icon, but then they are prompted with a Sql server logon when the click the report builder icon. I've granted datareader on the sql databa ...Show All

• Visual FoxPro MyEditor (Edit Control) Validation in VFP-9: STOPPING Menus, etc?

  I'm trying to *stay within myEdit control(s)* until *pProcessing* is finished. I seek *better ways*, per se, from any of you (besides making the form(s) modal). Here are some of my awkward (non-bulletproof) workarounds. In myEditor.VALID ... If pProcessing This.SetFocus * Return .F. Endif To STOP Menus... In _msysmenu: set skip for pProcessing (for every menu bar()... ) OR SET SYSMENU SAVE SET SYSMENU TO ...when pProcessing is finished SET SYSMENU TO DEFAULT (I'd prefer to make _MSYSMENU/SYSMENU just *freeze* ... in a modal (myForm.windowtype=1) manner and not have it *blink* off and on ) To prevent oApp.oToolbar... If pProcessing oApp.oToolbar.enabled=.F. Endif Hiding forms until pProcessing is completed, Etc. Etc. Thanks in adv ...Show All

• Visual C++ memory leak for socket program

  I got memory leak after running a socket program. I checked for "new" and "delete" socket, they both seem fine. So I couldn't figure out what's wrong. Here are the messages after exiting the application: ...... 'ip.exe': Unloaded 'C:\WINDOWS\system32\iphlpapi.dll' Detected memory leaks! Dumping objects -> {269} normal block at 0x00B15870, 2401 bytes long. Data: <2.0.8 n > 32 2E 30 2E 38 00 6E 00 00 00 00 00 00 00 00 00 Object dump complete. The thread 'Win32 Thread' (0xc7c) has exited with code 0 (0x0). The program '[1372] ip.exe: Native' has exited with code 0 (0x0). If I run the certain function twice which creates the new socket then deleting it, memory leak will be detect ...Show All