newCinC's Q&A profile

• SQL Server Pre-Execute Phase

  What happens during the pre-execute phase Is there anything I can do to optimize it's execution I have a package that takes data from 2 SQL Server sources, unions them, and writes to a sql table. The pre-execute takes 20 minutes, and the execution takes 45 seconds. Thanks BobP Are you sure there are no other components in your data flow (Lookups ). Do you have another data flow in the package Give us a picture about the used metadata; how many columns How many rows do get transferred Thanks. ...Show All

• Visual C# Hex convertion to string in C#

  I have a string variable in Hex format which I need to convert to a standard ASCII string ; eg "48656C6C6F20576F726C64" should convert to "Hello World". I can't seem to find anything in the help files which actually helps with what should be a fairly common requirement. If anyone can throw light on this (and indeed the reverse conversion) I would be very grateful. Yes I suppose so. It's just so irritating that, with so much work that has supposedly gone into VS2005 C#, they can't even provide a simple conversion like this in a single shot. I'm sure that I can't be the only person in the w ...Show All

• SQL Server Problems with SQL 2005 Export Wizard

  I am trying to transfer data from SQL Express to SQL Server 2005. The data is from Paypal Commerce Starter Kit from ASP.NET site. I have tried several options (Optimize for many tables, Run in Transaction). However the data is not exported. This is the error I am getting: TITLE: Operation stopped... ------------------------------ The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.". This occurs when CPackage::LoadFromXML fails. --------------- ...Show All

• Windows Forms My wishlist

  1)A BackColor property for Tabs. 2)Better support for the icon and cursor file formats, e.g. colored/animated cursors, enumerating icon formats, etc. 3)Improved ListImage draw method that allows blending images with a color to create the "selected" and "ghosted" looks 4)Fixing the RTFTextbox ScrollToCaret bug 5)Hiding ListView headers using .Visible=False 6)Improved Designer support for cust ...Show All

• Visual C++ MS C++ 2005 express database mismatch error when compiling

  Every time that I attempt to compile a c++ program I get a database mismatch error. When I looked this error up in the included documents, it said that I needed a newer version of dbi.dll. Where can I find this file I know that my programs work because they compile with ms vc++ 6.0 and the gcc complier. Here is the artilce where it told me "how to fix it," but I still cannot find the file that I need. Visual C++ Concepts: Building a C/C++ Program   Fatal Error C1902 program database manager mismatch; please check your installation A program database file (.pdb) was created usin ...Show All

• SQL Server Can we toggle the database status between recovery and nonrecovery?

  Hi, 1) We will setup logshipping for a large database. 2) 2 systems are located at different city 3) Instead of use 'backup from primary and restore with norecovery to secondary ', we planned to use SAN disk clone to get a second set of disks for related database files and log files. 4) We will mount the disk to the secondary server, however, how can we put the database on the new server as 'norecovery' mode so that we can setup logshipping to this server Another easy example is: 1) detach database 2) Copy database files to another disk 3) bring the disk to another city and attached to the new server ...Show All

• Windows Forms Windows Forms Datagrid Problem

  Hi, I have a datagrid tied to a dataview.  I want to validate the information that is being entered.  I want to accept only numbers in a column or only letter in another one. I'll really appreciate your help on this matter. Thanks, Roberto Acevedo .Net Programmer Guatemala City, Guatemala Try to state what version of the framework you are working with when asking quesitons. I assume since the other post didn't help that you might be using 1.1. Here is a sample project I did for the 1.1 datagrid. http://www.planet-source-code.com/vb/scripts/ShowCode.asp txtCodeId=1591&lngWId=10 Hope this helps Jose ...Show All

• Microsoft ISV Community Center Forums Does the VBA save word as XML???

  Hello! I'm really needing to know if there's any VBA code able to save a Word document as an XML doc. Any sample is appreciate. thanx Marcos Hercules dos Santos There an XML format called WordML that lets you save a native Word document to an XML document. The XML file thats produced contains a lot of XML that you might not want or need but you can perform transformations on it or use DOM to extract what you need or to reformat it. If you look at the Document.SaveAs method there is a enumeration for XML ActiveDocument.SaveAs FileName:="doc.xml", FileFormat:=wdFormatXML You'd need to look into WordML ...Show All

• Visual C# How to find registered event handlers?

  Hi, I'm trying to determine if an object has any event handlers registered on it. The reason I need this, is to not let an object to register one single event twice. this .menu.BeforePopup += new CancelEventHandler(menu_BeforePopup); // OK this .menu.BeforePopup += new CancelEventHandler(menu_BeforePopup); // Don't let it happen twice   Any help would be great Hi Patrik, and what is here the "anEvent" Is it the event itself or the event handler I just can't call GetInvocationList() on any of events.. ...Show All

• Windows Forms printing text

  I am trying to print a text file and am using the examples provided by Visual Studio. The following line calculates the number of lines per page in the PrintPage eventhandler: lpp = ev.MarginBounds.Height / printFont.GetHeight(ev.Graphics); The problem is that lpp calculates a number of lines but the printer is printing past the margins and I miss 2-3 lines per page. If I subtract 4 from lpp this works but why isn't the calculation correct The event is listed below: //Event fired for each page to print private void pd_PrintPage( object sender, PrintPageEventArgs ev) { float ...Show All

• SQL Server Missing ODBC DriverI ran the check against "MDAC 2.8 SP1 ON WINDOWS XP SP2."

  I have a Windows 2000 development server with multiple instance of SQL Server 2000 Dev Edition installed. Recently, i encounter an error on Enterpise Manager. "A connection could not be established to SERVERNAME\INSTANCENAME . Reason : Data source name not found and no default driver specified. Please verify SQL Server is running and check your SQL Server registration properties(by right-clicking on the SERVERNAME\INSTANCENAME node) and try again." I tried to use Query Analyser on the server to connect to instance. And receive this error "Unable to connect to server SERVERNAME\INSTANCENAME: ODBC: Ms ...Show All

• Visual C# which control captures drawing?

  I have a touch screen PC (not a Tablet PC). I would like to write an application to allow users to draw anything on PC and then save it as image. Which control should I use Thanks. Joe. There's no control that does that. You'll have to write an app that uses the paint event to draw the image, and captures input to do the drawing. ...Show All

• Windows Forms Rows in the DataGrid automatically deleted

  Hi - Has anyone of you encountered a situation wherein all the rows in a data grid disappeared automatically. After rows have been displayed in the data grid, I left the screen untouched for a few seconds (number of seconds varied) and the rows would just disappear. There are several events that called for the population of the data grid. Could that&nb ...Show All

• .NET Development Typed data sets and adapters

  Hello all   I use typed datasets, and the adapters which created for each table, it is very convenience. But...   The application is targeted to be distributed to my clients which has a different connection string than I do.   How do I change the connections string dynamically Please do not give me one of the next answers:   I already know that the connection string in the app config is read only.   I do not have the option to change the file using XMLDocument.   I am looking for a one place solution, not like changing the connection string mo ...Show All

• Visual Studio Team System HELP I THINK I DELETED THE TFS BETA 3 Registration Connection file with TFSREG tool

  Is there a way that I can fix this   Maybe someone can post this registration xml information and I can apply it to this machine.  I am using beta 3.  There are several variable substitutions that happen in the registration xml for each install, including machine name(s) and the sharepoint admin port, so it may be tricky to try and fix it that way.  Nevertheless, we can give it a shot.  Here is the data from another Beta3 machine.  Replace the "ApplicationTierMachineName", "DatabaseMachineName" and "17012" values with your machine names and your WSS admin port.  Then save the ...Show All