Kamii47's Q&A profile

• SQL Server DTS vs Integration Service

  Hello All, I have issues regarding DTS in SQL 2000 in comparison to the Integration Services in SQL 2005. In SQL 2000 the way I used to import data from a Microsof Excel file was through DTS where I could mention row number from the Excel file to start extraction into the SQL DB. ( Transform Data Task Properties > Options > Data Movement: First Row ) Whereas, in SQL 2005 I cannot specify anywhere from which row number the extraction should start. I am new to SQL server 2005, any help regarding above issue will be much appreciated. Thanks Umer see SSIS forum In SQL Server 2005 Books Online : Flat File Connection Manager Editor (Gen ...Show All

• SQL Server Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B

  Hi, I have developed several SSIS packages with the last Beta of VS2005 / SQL Server CTP. After the public release I tried to uninstall the CTP-Versions to install the msdn finals but this time I got lost and was not able to satisfy the requirements of the final setup of VS2005. So I decided to install the whole pc again and after some hours I had a clean machine (XP with latest SQL Server 2005 Standard and VS2005 Professional).   Now I have tried to open my SSIS-Project but getting the following error:   Error loading ImpNetqNewsRss.dtsx: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Schlussel ist im angegebenen Status nicht gultig.". You may not be authorized to access this information. ...Show All

• Visual Studio Express Editions Reading bytes from serial port

  I am new to vb and I have spent days trying to read bytes from my controller to the PC.. I have been trying to modify the program listed. Can someone with a good knowledge of vb modify the program to read a byte. I am sending bytes repeatedly to the serial port but there are only displaying when I change the com1 to com1 You description is not particularly clear and havent provided any code to show us what you doing. Spending the time to do both of these is likely to provide you with a better opportunity to get a timely answer. ...Show All

• SQL Server Deployment 'utility' script using sqlcmd

  Hi all, I'm looking at creating a sample utility script that will invoking scripts to deploy some SQL code. For example, a utlity script that will run a SQL script, and on successful completion, execute the next script. Having not used SQLCMD at all before, and being very new to SQL2005 (< 1 month) please guide me if there is a better way of invoking this... For example, a way of avoiding the xp_cmdshell invocation! The following code invokes a script, but I'm trying to find a way of getting a return code back from sqlcmd, so I can progress and do the next, or fail if the return code <> 0 (success). [code] --Process to create DB, Tables, and Stored Procedures set nocount on DECLARE @Error i ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Terrain & Terrain-Physics (intersection, dynamic slicing)

  Hi, at the moment i am wondering how to deal correctly with a terrain in XNA. For now i just have a static terrain model loaded from file. So i have an object (a buggy for example) and want to get some physics on it, therefore i need to check for collision with the underlying terrain. The collision with the buggy could be done with a boundingbox, but the terrain needs to be checked per face (3 vertices triangle) i think. But i cant find a way to check this. I think iteration throught all faces of the terrain would take to long for all objects in the world. How do other developers solve this problem So if I do it this way i will always need to calculate every object in the world each frame, no mather if its visible or not, is this th ...Show All

• .NET Development System .Net tracing vs network monitor

  I'm monitoring an asp.net 2.0 app on windows 2003. This aspx page calls asynchronously an asmx web service on another server. I'm looking for some clarification on the tracing behavior. Looking into the traffic with a network monitor I see that I receive small HTTP packet (the corrisponding tcp packet is: Tcp: Flags=...PA..., SrcPort=HTTP(80), DstPort=20287, Len= 1460 , Seq=2278731085 - 2278732545, Ack=2977840638, Win=64388 (scale factor 0) = 64388) Looking in the trace of System.net I see System.Net Verbose: 0 : [5940] Data from ConnectStream#5312697::Read System.Net Verbose: 0 : [5940] (printing 100 out of 4096 ) System.Net Verbose: 0 : [5940] 00000000 : <content stripped> System.Net Verbose: 0 : [5940] Exiting Con ...Show All

• SQL Server Two report parameters: "Please select a value for the parameter...."

  I’ve build a report with Report Design. On this report I want to show the items customers bought. In this report I added a Report Parameter so the user can select a specific customer. I made an extra dataset and use the filter =@customer and this parameter works fine. Then I want to ad a second Report Parameter: the salesperson. When I leave one of the parameters blank, I get an error "Please select a value for the parameter....". Even if I choose the options allow blank or null values, I get this error. What I want is de possibility to get all the records, to filter records from one specific customer or to filter records from a specific salesperson. Hi, i think your SQL-statement have to mo ...Show All

• SQL Server invalid column name 'rowguid'

  Hi all, I'm new to replication and database management so I will like some understanding and guiding as this is a new task for me. I was given a copy of a database with merge replication on it and doing allot of reading and using some scripts I cleaned replication (or so Im thinking) and tryed to use it again on the ms-access front end. When I try to update some data I get "invalid column name 'rowguid'" , but no such column exist in my database as it was dropped. Any help on this thanks George. When you setup merge replication, it adds a guid column to your table article. You scripts may have dropped the column when you clean up the replication and your front end may still have depe ...Show All

• Visual Studio Team System How to log worked time for each work-item?

  Hi: I want to use VSTS to log time for each employer, and generate related reports. Does VSTS provide and how Thanks Ron Ron, VSTS provides a work item repository in the server side part of the product called "Team Foundation Server" (TFS). Out of the box, these work items contain a "Estimate Hours Renamining", "Hours Worked" etc type fields that can be used to collate the data that you require. You can customize the work items to collect whatever data you want for each work item. You can generate reports based on the data stored in your work item repository. Note that this will only collect information about work items (i.e. Bugs, Features etc). This does not really provide the capability to re ...Show All

• Visual Studio 2008 (Pre-release) Strange behaviour with disabled toolbar

  I have discovered a strange behaviour (bug ) in the chess application. Load the chess game, go to 2D page, navigate back to the main page and then navigate forward to the 2D page: the toolbar is disabled. This doesn't happen with the 3D page or if you navigate using the menus instead by clicking the arrows. I have no idea if it's a bug in my application or in WinFX runtime. Any thoughts Is there a solution for that I have an application with tab control as its main panel and when adding removing a tab the entire application toolbar become disabled. ...Show All

• Windows Forms how to put my application on start up in deployment project

  hello to all.. i have completed my project and now i am preparing a setup project for it.. does anyone have an idea abut how can i put my application on the start up menu of PC that will install my project so that whenever the user turns on the PC my application will launch automaticallly please do not offer services i am new to development and i ddi not understand much of services... Thanks for that. It works in C#. Will try it in VB. I suppose the only difference would be VB uses ApplicationEvents.vb and me.Startup event. ...Show All

• Smart Device Development How to detect if a Smartphone application is put in the background?!

  Hi there! Following problem: I have a Smartphone application which has main window which consists of a single (docked) TreeView. I need to perform certain tasks when the application is put in the background. That is when the Escape/Back key (KeyCode 27) is pressed. However it looks like and TreeView / ListView eats up that KeyCode. I tried a number of things but i simply can't get the escape key event. This is probably because the escape key might also be used to collapse tree nodes. So how on earth can the application figure out, when it is put in the background when neither the TreeView nor the Form fires the KeyUp event for the Escape/Back key Do i have to do some dodgy constructs with the OnDeactivate / OnMinimise event ...Show All

• Visual Studio 2008 (Pre-release) storyboard begin from codebehind

  I have a button (play button) which when pressed begins the storyboard which is all in xaml. However, I want to begin the storyboard from c# (in the .cs file) and not from a trigger in xaml. When I try to access the storyboard from c# it doesn't recognise it : storyboardname .Storyboard.begin(this); // where storyboardname is the name in the xaml code so I take out the trigger event from xaml and then try to set the StoryboardName within the Storyboard tag but seem unable to do this without generating further errors. Any help on this would be appreciated, thank you ...Show All

• Visual Studio Express Editions ATL DLL Vs Win32 DLL - VC++

  Hi, What is the difference between the ATL DLL and Win32 DLL in VC++ I am not sure which one to select from the template wizard. IS COM dll different from this I appreciate any input. Thanks These are different technologies. I suggest reading on MSDN on the different topics. Also, ATL is not a supported technology under the Express edition. In addition, you won't find templates for such technologies in the Express version. Thanks, Ayman Shoukry VC++ Team ...Show All

• Windows Forms Have .NET 2.0 added more windows forms controls?

  I want to know whether .NET 2.0 added more windows forms controls to what was already in the .NET 1.1 version If yes, may I know what other windows forms controls have been added and from where can I get the information about these. I know in .NET 2.0, so many new web-based controls have been added but not sure about the windows forms controls. Regards, Kamran Yes, there are some new controls: ToolStrip/MenuStrip/ContextMenuStrip/StatusStrip - these replace the old ToolBar/MainMenu/ContextMenu/StatusBar DataGridView - a new data grid control FlowLayoutPanel/TableLayoutPanel - "layout" controls MaskedTextBox WebBrowser See here for more details: http://www. ...Show All