Chiro's Q&A profile

• Visual Studio Team System Import Database Schema error: Cannot sort a row of size 8132, which is greater than the allowable maximum of 8094.

  The error message is clear enough. To understand the problem, let's start the initial discussion with a description of the original database in question. The database has two tables that were at the maximum row size and everything was fine. After adding constraints to the database, those two tables ended up exceeding the maximum row size as these warning messages indicate: Warning: The table 'Table1' has been created but its maximum row size (8065) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes. Warning: The table 'Table1' has been created but its maximum row size (8065) exceeds the maximum number of bytes per row (8060). INSERT or U ...Show All

• SQL Server SQL Server Agent SSIS job: "Set Values" drops leading quote

  We are using BCP in a Process task. The value for the path to BCP's error log requires double quotes around it. We initially put this value in a configuration file, and that worked fine. Yesterday, we eliminated the config file and tried to use the "Set Values" tab of the SSIS SQL Server Agent job to pass in this value. The package variable was assigned the value of the path -- all except for the leading double quote. The closing quotation mark was included in the value. We tried adding a second double quote at the beginning of the value, but that caused the job to fail immediately. For now we will work around this problem by putting the quotes around the value in a Script task inside the package. Has anyone else enco ...Show All

• .NET Development How to recieve the notification that a new AppDomain has been created?

  I have found in MSDN that IAppDomainBinding interface can be used to recieve the notification that an application domain has been created. But there is no information what object can implement this interface and how to subscribe to this notification. Could you explain me this, please How can I recieve the notification that an application domain has been created Thank you and happy New Year, Roman Hi, I am not the right person to really comment on CLR Hosting, but what i come to know, i said you in my last post. For further information on Custom CLR hosting, you may get some useful information from the following links, http://www.gotdotnet.com/team/clr/about_clr_Hosting.aspx http://ms ...Show All

• SQL Server Adding folders in the solution explorer?

  Hi.. Isn’t it possible to create sub folders in the solution explorer I have it hard time to create a decent structure inside the SSIS Package folder, since I have like 30 packages in my project. Is it just me being silly or cannot this be done Have a nice day /Erik ...Show All

• Visual Studio 2008 (Pre-release) Can't compile cause InitializeComponent() missing?!

  Hi everybody, I don't know why I'm not able to compile my project. The solution consists of multiple projects. Two are library projects, each which normal classes and wpf-windows in it. One of these projects rejects compiling because InitializeComponent() couldn't be found. In the other project, with exactly the same referenced assemblies, there isn't this kind of error. Does anyone know a solution for this prob Thx! add <Import Project="$(MSBuildBinPath)\Microsoft.WinFX.targets" /> in my .csproj file. this post might be helpful http://blogs.msdn.com/mhendersblog/archive/2005/10/03/476536.aspx ...Show All

• Windows Forms When is GetStandardValues called?

  The following code implements a simple derived control with a public property called "MyProp". This property has a drop-down list with valid values: using System; using System.Collections.Generic; using System.Text; using System.Windows.Forms; using System.ComponentModel; using System.Collections; namespace DefaultValuesTest2 { public class MyTypeConv : TypeConverter { public override bool GetStandardValuesSupported( ITypeDescriptorContext context) { return true ; } public override bool GetStandardValuesExclusive( ITypeDescriptorContext context) { return true ; } public override StandardValuesCollection GetStandardValues( ITypeDescriptorCon ...Show All

• Visual C# Save a string into a file

  Hi, Through my web application I generate a string and I need to save it into a file to send by mail. How can I save the file and send it as attchment by mail Thanks in that case to save a file, import the System.IO namespace then... StreamWriter theWriter = new StreamWriter("filename.ext"); theWriter.WriteLine("my line"); theWriter.Close(); then add "filename.ext" in the attachment collection as shown in the link above when sending the email. Alternatively you can use a stream of data and send that instead of the filename.ext file itself. This will still attach the content to the email as an attachment. does this help ...Show All

• Software Development for Windows Vista Advanced Activity Design

  I have an already existing workflow in production that runs a call external method activity only and needs to be enhanced to run an optional invoked workflow on the other side of an added ifElse Activity that runs a new custom composite activity. I have chosen to create a custom Invoke Workflow activity that accepts a TargetWorkflow type at runtime, and I understand I need to use the WorkflowQueuingService to pass the data that the invoked workflow has completed. However the examples I've seen has a standard InvokeWorkflowActivity on a main workflow used and not a custom one. I can't seem to get my Custom one to work with this situation. I keep getting "Invalid workflow parameter value" when I try to Create the Workflow Instance ...Show All

• Visual Studio Express Editions Assertion failed

  Hi, I have a message at startup that says: Microsoft Visual C++ Runtime Library Assertion failed! Program: C/WINDOWS/system32/adirss.exe File: .\SmtpServer.cpp Line: 28 Expression: bool(sock_) &&sock_->isSockValid() I understand that a trojan may have interfered with the adirss.exe file, but I've run virus scans a couple of times. However, I still get this message. Any suggestions to get rid of the message at startup Cheers Is adirss.exe a program you wrote If not, you seem to have a debug version of it, as it is not normal that assertions pop up in release builds. If the reason is an invalid socket. Then I would guess that your firewall does not allow adirss.ex ...Show All

• Windows Forms Error Code: 0x80070643

  I have tried to install Windows and Office updates utilizing the Automatic installation tool; but, the initialization takes place and none of the updates are intalled. I ran WinDoctor and I am told that I am missing file "ORUN32.exe" and it cannot access "learn32.dll" and "pctree32.dll". I have searched my computer and found the orun32 and pctree32 files but not the learn32 file. I don't know how it got deleted and not sure how to get it back in place to use the automatic update. What do I do to get my Automatic updates to run again Please help me! Office Source Engine bull *** solution does not work...no matter how many times you restart this service. This problem was most likely created ...Show All

• Visual Studio Image to PDF

  Hi , I'm trying to develop an application which is used to convert the Image file to a PDF file using VB.NET . I'm concentrating on the ghostscript and postscript.can any one suggest any resources you know and help start coding that.any help is appreciated. -regards GRk ...Show All

• .NET Development Error: 'Must declare the scalar variable "@categoryID".'

  Hello, I'm creating a Data Access Layer in an ASP.NET 2.0 project in Visual Studio 2005 Professional. My database is SQL Server 2005 Developer Edition. After I Added a parameterized method to the Data Access Layer via a SQL SELECT statement (SELECT ProductID, ProductName, SupplierID, CategoryID, QuantityPerUnit, UnitPrice, UnitsInStock, UnitsOnOrder, ReorderLevel, Discontinued FROM Products WHERE CategoryID = @CategoryID) I get the following error in the TableAdapter Query Configuration Wizard: The wizzard detected the following problems when configuring TableAdapter query "Products": Details: Generated SELECT statement. Deferred prepare could not be completed. Statement(s) could not be prepared. Must de ...Show All

• Visual Studio 2008 (Pre-release) Session data or how to implement a client side transaction

  I've got a three-tier-setup: 1) Client tier. Using WCF to communicate to tier 2 2) Middle tier. Listens to WCF and uses TSQL to communicate to tier 3 3) SQL Server 2005 as database tier. A client opens a client proxy, sends a command to the middle tier, and closes the client proxy after use. The middle tier, when called, opens a SqlConnection to the SQL Server, does its stuff, closes the SqlConnection and reply to the client using WCF. This is working nicely, transactions in the middle tier work nicely, but how do I start a transaction initiated from the client, across more than one WCF call For this I would need to keep the SqlConnection open and reuse it, but where do I store it How do I recognise the client aga ...Show All

• SQL Server RFE: SSIS should recognise YYYYMMDD HH:MI:SS & YYYY-MM-DDTHH:MI:SS

  Hi, I've found a bit of an inconsistency between the way SQL Server treats dates and the way that SSIS treats them. As stated here: http://blogs.conchango.com/jamiethomson/archive/2005/04/26/1337.aspx the only totally unambiguous datettime string formats that SQL Server accepts are: yyyymmdd hh:mi:ss yyyy-mm-ddThh:mi:ss Given that then, its a bit annoying that, as stated here: http://blogs.conchango.com/jamiethomson/archive/2006/06/26/4141.aspx those two formats are not accepted as valid datetime string formats in the SSIS pipeline (check the bottom data viewer in the screenshot at the above link). I know that there is no strict requirement for SQL Server and SSIS to do the same thing as each other in situations li ...Show All

• SQL Server SSIS job runs great manually, but not using SQL Agent

  I am using SQL 2005.  I have created a SSIS package that basically executes another SSIS package (as part of a larger package) .  It runs fine in SSBIDS but will not run if I save it and schedule it using SQL Agent.   I should mention I am using a domain/admin account with SQL Agent, so I don't think that is the problem. When I execute the job in SSBIDS, the Execute Package Utility window pops up, at which point I click on the Execute button, the job runs successfully and then I click on the close button.  I suspect it is not running via SQL Agent because of the user intervention required to complete the task (i.e. clicking on execute as described above).  Is this correct   ...Show All