tolyy's Q&A profile

• SQL Server Exception Handling with a script component.

  My situation is that I'm reading from a source script component with code similar to ( in CreateNewOutputRows ) Try With OutputBuffer .AddRow .Status = odbcReader.GetString(1) end with Catch err as exception With ErrorBuffer .AddRow .ErrorInfo = err.Message End With End Try In the event of an exception what I end up with is a row going to the OutputBuffer and a row going to the Erro ...Show All

• SQL Server Error creating view from DB2 Linked Server if table has large number of rows.

  I have successfully created a linked server entry for a DB2 server via Microsofts Microsoft OLE DB Provider for DB2. I am also able to create a view based on a table that has 100's of rows. I am UNAble to create a view based on a db2 table that has 1000's of rows. I get the following timeout type of error. First a " Timeout Expired " error, then this: TITLE: Microsoft SQL Server Management Studio -------------------------- ...Show All

• Windows Forms BIndingSource AddingNew Event and Factory Pattern

  I found the answer here when I want to just create the right DataRowView Object _row = view.addNew(); But how can I inject a new Object from a Factory Method... Without a DataGridView in the background the sample is already in the VS Docu. And this works...but in this situation I have no idea Thanks Peter ...Show All

• Visual Studio Express Editions PSDK Installation Problem

  I use Microsoft Visual C++ Express Edition on Windows XP SP2 and I wan't to download Platform SDK.Very good....I have downloaded the PDSK file and start the installation.But at 50% of installation I receive a error: "A necesary file from C:/Windows/Installer is corrupted." But I have an antivirus (BitDefender 9 Internet Security) and I have tried on another Windows XP system from my computer (I have 2 Windows XP) an I received the same ...Show All

• SQL Server Question SSIS "Script Task" + VB.NET keyboard configuration

  I was pretty excited when my first script ran in this type of task. But I soon noticed that I couldn't find the "watch" or "immediate" windows I was used to in standard VB.NET. Did I miss them or are they simply not available in the Script Task editor TIA, barker P.S. Also under the VB.NET environment, I can Import the VB.NET default keyboard settings (e.g. Step Into is F8; Step Over is Shift+F8) in ...Show All

• SQL Server SQL Server Agent Issues

  Hey everyone, I don't know if I am posting to the correct forum so please move this if there is a better forum for this. I am having issues through SQL Server that I believe may be related to the SQL Server 2000 User Mode Scheduler. First of all, I am running a single instance of SQL Server 2000 on a Quad Processor system. I was not around when the system was installed so I do not know how it was originally configured. I am getting a ...Show All

• SQL Server Profiler in April CTP

  Hi, I am trying to run the SQL Profiler. Whichever way I try (Program Files, Tools Menu), this seems to lauch the Profiler90.exe, which seems to be running in the background and no UI appears. Anyone has similar problems Rgds, Anand http://www.dotnetindia.com Hi Anand,     This is a known problem that is fixed with Windows Server 2003 SP1. Check out the readme file for more details. Thank you, Bil ...Show All

• SQL Server Error detaching sql express database using SMO

  I am using SMO to provide a backup/restore feature. The restore code looks like this: try { // Initialise server object. Server server = new Server(serverName); server.ConnectionContext.ConnectionString = connectionString; // Check if database is current attached to sqlexpress. foreach (Database db in server.Databases) { if (String.Compare(db.Name, destinationPath, ...Show All

• Software Development for Windows Vista IndexOutOfRangeException while invoking WorkflowRuntime.getWorkflow(workflowInstanceId)

  When I get the Workflow Instance from Workflow Runtime I am getting the following exception. Can anyone please help. WorkflowInstance wi = workflowRuntime.GetWorkflow(workflowInstanceId); This is the syntax used. Please help. The workflow I am trying to get is the StateMachineWorkflow.   A first chance exception of type 'System.IndexOutOfRangeException' occurred in System.Workflow.ComponentModel.dll ...Show All

• Visual C# Requirements for a C#.NET Windows Application

  Could anyone pls tell me the minimum System Requirements for a C#.NET Windows application. ie. Requirements like RAM, Processor, Hard Disk Free Space etc. Not counting your own application requirements my guess is that the minimum is bounded by the min. requirements of the .Net Framework redistributable that you are using (v1 or v2).  I did a quick search for the redistributables min. req. still didn't fou ...Show All

• Visual Studio 2008 (Pre-release) HOW TO: turn off WS-Policy generation in ?wsdl from WCF service to enable Java service interop over TCP

  I have created a simple WCF service that has a custom binding. The custom binding only has a TextMessageEncoding and a TcpTransport. I am trying to get an Axis2 Java service client to call my simple service over TCP. The generated WSDL contains the following WS-Policy assertions - even with my simple CustomBinding. The Axis2 RC1 framework has limited support for any WS-Policy assertions. As a result, I am getting an error on the WCF side of thi ...Show All

• Visual Studio Changing selection of most common environment

  When you first launch Visual Studio 2005 after installation, it asks you for your preferred environment , with choices for VS.Net 2003 compatibility, VB, C#, C++, etc. I accidentally chose one that I did not want. How can I reverse that I tried uninstalling and reinstalling, but it retained my setting. And by the way, in the process of uninstall/reinstall, it ate another few hundred megs of disk. Not sure why this happened either. ...Show All

• .NET Development Set cookie from IE hosted windows user control

  Hi everybody. What do I have: I have a (c# VS 7) Web app that uses an Internet Explorer hosted Windows User Control. Problem: I need to set a cookie on clients' machine from the IE hosted control. Does somebody know how to do that I would appreciate any suggestions. Thanks in advance! Bozesan Mihai As of now, from System.Net api's you can't set a cookie into ...Show All

• Architecture .Net 2.0 Migration Strategy Needed

  I work for a large organisation where we use .Net 1.1 as our sole development language. We have many frameworks and applications and web sites that are developed in .Net 1.1 These developments are by no means trivial, they are the result of an IT department of over 300 people and 2 years of development It is my responsibility to develop a strategy to move to .Net 2.0, this includes the existing applications, new developments, integration, QA, li ...Show All

• Visual C# datagrid prevnt click

  Hi How can I prevent all click in any cell in a datagrid rows. I do want to keep the columns active. If I disable the datagrid - I can't resize columns at execution. Thanks Abhijit Then use bound column (or column type other than hyperlink column)where clicking of a cell will result in nothing. ...Show All