soconne's Q&A profile

• Visual Studio Tools for Office CacheInDocument not available in Excel Project

  I cannot seem to locate the CacheInDocument property where tutorials tell it is available. Infact I get all other properties apart form CacheInDocument. I've just created a normal dataset through designer. Is there something I am missing I've recetly installed VSTO 2005 SE. Does this have anything to do with it.. or the fact that I have an excel template project and not an excel workbook project. Is there some other way to enable dataset caching Hey Mohit, Thanks a bunch for your reply... I was beginning to lose hope about anyone replying to this thread . I think my problem is with the statics. I'm going to sort them out. Thanks once again. ...Show All

• SQL Server using copy database wizard

  we need to move databases from one SQL Server 2005 to another SQL Server 2005 server. We are using the copy database wizard. We are planning to move the databases using the SQL management object method rather than the detach and reattach method. Both ways transport logins without an issue. I also know that the SQL management object method is slower. Other than speed is there any reason I should use the detach and reattach method over the SQL management object method or is there a better way. Install SP2 if you haven't already. http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/servicepacks/sp2.mspx SMO is slooooower SMO alows to move a database while it is in use. See SQL Serve ...Show All

• SQL Server issues with CDATA section in FOR XML EXPLICIT

  Hi, I am trying to create a XML out of sql 2005 database using FOR XML. I need to create XML for tables which may contain data having non-printable ascii characters (1-32 ascii character). I found FOR XML AUTO failes to genrate this XML, but i can genrate XML using CDATA section in FOR XML EXPLICIT. As following querie works fine for me. SELECT 1 AS tag NULL AS parent, template_id AS [Emailqueue!1!user_id], misc1 AS [Emailqueue!1!!cdata] FROM Emailqueue WITH (NOLOCK) WHERE queue_id = -2147483169 FOR XML EXPLICIT in above query misc1 column may contain some non printable ascii characters. But i need to store this XML data in some sql XML variable as i need to pass it to store procedure which expects an xm ...Show All

• .NET Development opposite of XMLConvert class

  Hi! I was wondering if there is a class or method that does the opposite to what XMLConvert class does. i.e. convert a CLR type to a valid string for an XSD. Thanks in advance! Derek you are right! Here is the document that describes ToString() method (I home the link works): ms-help://MS.VSCC.v80/MS.MSDN.v80/MS.VisualStudio.v80.en/WD_XML/html/dc2e2b65-f623-4dc3-938b-d2a054d6832c.htm I don't know where I read that it's culture sensitive! Thanks for your help! ...Show All

• Visual Studio Crystal Reports for Visual Studio Program Manager

  Hi Everyone, As program manager, I'm a recent addition to the Crystal Reports for Visual Studio team. I look forward to contributing to this forum as often as I can, and I'm excited to hear any feedback, comments, or suggestions that you have. I encourage you to visit our Developer Resource Center   as a great starting point for all of our developer products. It has links to sample code (118 C# and VB samples), our Developer Library online SDK documentation, our Developer Zone, and Business Objects Support Forums. Also, for those of you that are new to report design and using the Crystal Reports Designer embedded in Visual Studio, check out the "Creating Reports" docume ...Show All

• SQL Server ETL Package Problem

  I'm going through the Integration tutorial, Lesson 1: Creating a Simple ETL Package. Everything goes fine until I run the package. I get an error about inserting Null in the CurrencyKey field which is set to not null. The flat file looks okay. Any help would be appreciated. --------------------------------------------------------------------- SSIS package "Lesson 1.dtsx" starting. Information: 0x4004300A at Extract Sample Currency Data, DTS.Pipeline: Validation phase is beginning. Information: 0x4004300A at Extract Sample Currency Data, DTS.Pipeline: Validation phase is beginning. Information: 0x40043006 at Extract Sample Currency Data, DTS.Pipeline: Prepare for Execute phase is beginning. Information: 0x40043007 at Extract S ...Show All

• Visual Studio Express Editions Setting up arrays

  hey Guys me again, One more question, in visual basic 2005 express edition how do you establish and set up an array when you want to link many text boxes to the one button... again i have the old book that tells me how to do this but i need the new code as the old is not working.... Thanx heaps for the help guys Newb Sorry bout that! I need the line of code that goes in the buttons event handler that will save the info entered in the text boxs to an array so that it is easy to retrieve when need be.... I will have another look over the help files but yeah. I'm not sure how to explain it more specifically ummmm...... As you can tell i'm completely to new to visual basic. So yeah anyway i need to be able to save ...Show All

• SQL Server QI for IEnumVARIANT failed on the unmanaged server. (CustomMarshalers)

  I am getting the following message when I attempt to Export data in SQL Management Studio from my workstation. The error occurs as soon as I click Next to go to the Source Data Sources page of the Export wizzard. I am using SQL Server 2005 Management Studio. I get a similar error in Visual Studio 2005 when I attempt to open a SSIS project. When I click on the link in the error message the page at Micorsoft Help says there is no explanation. Any ideas on what might be wrong or what settings I am missing The error text is: This wizard will close because it encountered the following error: (Microsoft SQL Server) ------------------------------ For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&ProdVer=9. ...Show All

• Visual FoxPro documentation error - command window - persistence

  Help says "Split lengthy commands by typing a semicolon after a space in the command where you want it to break, and then pressing ENTER." This only works if there is nothing following the semicolon (i.e. I'm entering the command for the first time). This will not split a previously entered command. Are you talking about the Command Box If you go up the history list to re-use a previous command and you want to add to it by adding a ";" then a new line, just select all the text down, after the command you want and press Delete, then continue writing you ammended command line with semicolons (";") if you want. Reused commands go to the bottom of the command list when you re-run them. ...Show All

• Smart Device Development mmc.exe Application Error

  Hello, Is NET.Framework 2 save I downloaded the NET.Framework 2 (x86) "dotnetfx.exe" version : 2.0.50727.42 After restarting Windows XP Pro SP2, i recieved the message: -------------------------------------------------------------------------------------------------- mmc.exe Application Error: (X) The exeption unknow software exception (0xe06d7363) occured in the application at location (0x7c81eb33). ------------------------------------------------------------------------------------------------- Any comment and advice will be appriciated. Jean Are you talking the .NET Compact Framework 2.0 or the regular, full-blown .NET Framework 2.0 With dotnetfx, I think you're talking the fullblown, r ...Show All

• .NET Development Monitoring network packets - incoming and outgoing

  Hi all, Is there any provision to monitor the http packets sent and received per user basis in a network interface . I want to develop a download/upload limit software where I can restrict users setting the download limit in terms of 1000 MB of data or 2000 MB of data etc., Thanks. Hi, Thanks for the reply :) I already saw IPv4InterfaceStatistics. It gives overall bytes received and sent, whereas, am looking for per user basis, the bytes sent and received. Any suggestions on that Thanks. ...Show All

• SQL Server Insert new row to view

  Hi all , I have a problem to insert new data to a view which was created from 2 tables. I am trying to so from run time Any help will be appreciated Hi If there is any Not Nullable field not included in the view then when you call insert on that view the error will occured, add the not nulable field to the view then you will be able to insert in the view. ...Show All

• Visual Studio Team System setup.exe failed to install

  I have installed Visual Studio 2005 Team Suite Envaluate Edition, when everything works well I downloaded Visual Studio 2005 Team System for Database Professionals (file VSTSDBTR.img). I use a virtual CD software map the image to a driver, and can run setup.exe, but when I click the first choice "Install Visual Studio Team Edition for Database Professionals" setup.exe throws an application error dialog says "0x0031424 instruction references a memory can't be written", and when I click "OK" button ,setup.exe exits. I have installed Visual Studio 2005 Team Suit on Windows Server 2003 SP1 box. So anybody helps Try to download the setup from http://www.microsoft.com/downloads/ ...Show All

• Internet Explorer Development IE7 Beta Antiphishing

  I moved my master hard drive to a slave and installed a new master. I was trying to delete fiels off the old hard drive but there is one folder associated with the previous IE7 Beta installation that I can not delete. C:\Documents and Settings\User\Local Settings\Temporary Internet Files\Antiphishing The folder is inaccessible and undeletable. How do I delete it Ending explorer.exe and using command prompt does not work. dude, thank you! i've been trying to delete that folder for HOURS now. I had a feeling it had something to do with securities or permissions but i had no idea how to use them. a hundred thousand thanx. good thing i stumbled across this before i committed suicide. ...Show All

• Software Development for Windows Vista PLEASE READ: Microsoft.MediaCenter.UI.dll

  I would like to down load Media Center SDK to intergrate an application into the Media center where can I find this Thanks for the link!! where can I find some examples / templates of this kind of applications Thanks again :) Manu ...Show All