Chris Henesy's Q&A profile

• SQL Server URGENT: Insert and Update in a transaction is getting blocked

  Hello, I have the following situation: -Package A begins a transaction (TransactionOption="Required") with IsolationLevel=Serializable -PackageA calls PackageB -PackageB has 2 data-flows. The first one inserts into TableA. The second one updates TableA. They run serially. They both have TransactionOption="Supported". The update is blocked in SQL Server by SPID=-2   (which I know is MSDTC). I tried setting RetainSameConnection=TRUE on the connection manager in PackageB. It failed with: "Incompatible transaction context was specified for a retained connection. This connection has been established under a different tran ...Show All

• SQL Server Failed to update database "XXXXXX\APP_DATA\DBSQAFTP.MDF" because the database is read-only

  I am recieving this error after republishing a data driven web site.  I am running on SQL Express, and prior to the last publish all was working fine. I have also attempted to connect to the DB using SQL Server Management Studio Express and it claims that the DB is in use by another process. Any Ideas Below is the error text: Failed to update database "XXXXXXX\APP_DATA\DBSQAFTP.MDF" because the database is read-only. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exc ...Show All

• .NET Development "general network error" when trying to make an SqlConnection....

  This is an old thread, but many people are still experiencing this problem. There are several workarounds: 1. Switch from Named Pipes to TCP/IP. This is in conflict with one of the posts in this thread, which causes me to point out this is a discusssion about workarounds. Workarounds may or may not work. 2. Set OLE DB Services=-2 if using OLE DB. I realize this isn't directly relevant because the original post is about SqlConnection. But the point is that it turns connection pooling off. 3. Add Pooling=False to the SqlConnection string to disable connection pooling. This works for some people and not others. Of course, not everybody can ...Show All

• SQL Server Best way to inform .NET app of change in DB content

  Previously had a 'prototype' (.NET 1.0, SQL Server 2000, CCW to .NET) whereby an update trigger called out to our .NET app. Obvioulsy now SQL Server 2005 is nearly upon us I'd like to explore a better mechanism in order to consider the next phase of deployment (.NET 2, SQL Server 2005). I have a number of servers that 'cache' data from a table in SQL Server. At some later time one of the servers may update a set of the data. When this occurs I'd like to alert the other servers that the data has changed so they can refresh/drop it from the local cache/ The data can cover a number of rows from one of the DB tables (depends ...Show All

• Visual Studio VS.net2005 & VS.net2003 unknown error

  Im having this huge problem, I had VS.net2003 installed befour and it worked fine, but then I re installed my windows and then it gave me a "unknown error" att installation but it continued to install anyway, at the end of the installation it said that 0 errors occured. but then when I tried to start it it gave me first a Document explorer "unknown error" then a visual studio enviroment "unknown error" no ID or anything. so I re installed my system, updated to all the latest updates. installed VS.net2005 and then it worked!, but now a couple of weeks later (I havent done anything to my system) it gives me the same error again! please help. ...Show All

• Windows Forms TableLayoutPanel

  Within a user control, I am dynamically creating a TableLayoutPanel at runtime and then adding controls to it. Basically, I want it to have 4 columns of equal width (25% each). I have no problems other than when the table is created, the first column is certainly much wider than 25% (more like 60%) and the remaining columns are of equal width. My code for creating the table is as follows: TableLayoutPanel tab = new TableLayoutPanel (); tab.SuspendLayout(); tab.Dock = DockStyle .Top; ColumnStyle defaultColumn = new ColumnStyle ( SizeType .Percent, 25); tab.ColumnStyles.Add(defaultColumn); tab.Aut ...Show All

• Visual C# How to Send mail -help please-

  iam a new C# asp.net developer and i want a code to send mail to mysite users . i want a code and instruction to get my framwork ready tahnks for help This question has been asked many times on the forums. Please do a search and you will find the code and instructions you are looking for. Here are a few to get you started: v1.1 http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=717&SiteID=1 v2.0 http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=126529&SiteID=1 Michael Taylor - 1/18/06 ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. mdx 2.0 animation

  mdx 2.0 feb 2006 i copied the code from SimpleAnimation into my engine, and made the few adjustments to the name of variables/properties etc caz going from mdx 1.x to 2.0 and then i try to load tiny.x from the sdk, but it get the error: Unhandled Exception: Error in the application. -2147467259 (E_FAIL) at Microsoft.DirectX.Direct3D.Mesh.LoadHierarchy(Device device, String filena me, MeshFlags flags, AllocateHierarchy hierarchy, LoadUserData userDataLoader) an error msg of: -2147467259 hmmm not to helpful anyone got a working example of animation using mdx 2.0 As the MDX2 system is still in beat I wou ...Show All

• Visual C# Serialize object to string

  I am trying to serialize an object(s) to an XML string. I want to do this without ever actually creating an .xml file. The way I do it works, and seems to be fine. I just want to make sure that there is not something I have overlooked. If anyone has a better way of doing it I would appreciate the help. Here is my code: String XmlizedString = null ; XmlSerializer x = new XmlSerializer (Inv.GetType()); MemoryStream memoryStream = new MemoryStream (); XmlTextWriter xmlTextWriter = new XmlTextWriter (memoryStream, Encoding .UTF8); x.Serialize(xmlTextWriter, Inv); memoryStream = ( MemoryStream )xmlTextWrite ...Show All

• Windows Forms How to run a function from a MDIi Child in a MDI Parent

  Hello all, I have one problem, I want to execute a function I have in my MDI Parent from a MDI Child that is owned by the MDI Parent, and I just cand find a way to do it. If you coi~uld help me, I would apreciate. Thanks in advance! Thanks a lot rkimble! Now I got it! Well, I don't have any more questions for know,  ...Show All

• Windows Forms Datagridview Listing Down to Up

  Hi; When i add new record to database datagridview shows it at the last row of the list but i want to show it on the first row of the datagridview That means new records are must be show on the top of the datagridview. MyDatabase Table1 ------------------------- BOF record1 record2 ..... EOF Datagridview ------------------------ EOF ( First Row) ..... record2 record1 BOF I want datagrid like this. thanks for your reply but with this command it sorting the list for specific colum. I don't want to sort my table i only want to show EOF(End of File) on the top of datagridview and BOF (Begin of F ...Show All

• Smart Device Development Windows Mobile 5.0 vs Windows CE 5.0 - Same thing?

  Are the Windows Mobile 5.0 and the Windows CE 5.0 the same thing I am trying to buy a phone that I can make some .Net mobile programs for and I am looking at the cingular 2125 ( <a href="http://www.microsoft.com/windowsmobile/devices/devicedisplay.aspx module=deviceDisplay;Smartphone;americas;233">Here is a link to the info about it ) but I don't know if those two things are the same so I don't know if this phone will work. Can somebody help me out Thanks! It is my understanding that the phone edition is different from the PDA edition of Windows Mobile. In particular the new office compatibility in the PDA version is no ...Show All

• Visual C# C/C++ to C# Using Interops

  Hi! Your DLL have C++ export, which have decorated function name. You need to export it in C mode, check extern "C" in C++ manuals. Hi I am a student in University and I am helping a phd student on his research. I tried all the good forums out there and no answer yet on my problem. I have a unmanged .dll that I am currently using within C/C++ just fine... I wish to use that unmanaged DLL with C#.  I am using Microsoft Visual Studio 2005, and I am using C++/CLI using interops. Currently I having some issues concerning some exceptions. Some methods are working and some methods are not. Note that the code below are inor ...Show All

• SQL Server SQL Server Alert Notification Systems

  Greetings, SOURCE: http://www.desktopalert.net This is our web-based alert notification service that we are interested in integrating seamlessly with Microsoft’s Notification Server as well as 3rd Party content management systems and ad servers. The differentiating feature in the offering is in its secure Jabber-based instant messaging client/server products and the upwards of 2048 bit security model and optional biometric / identity federated features available for small, medium and large scale system integration capability.  This insures industry, financial, medical and government the world’s most secure end-to-en ...Show All

• Visual Basic Module not maintaining form initialized

  I am having troubles with an application I've developed on a specific server.  I believe the primary problem is the server itself and have yet to see the application fail on any other server.  It's running on a Windows 2000 Server, .NET Framework 1.1.  We've tried reinstalling the framework 3 times with no success and I would like to see if anyone else has run into this problem. The issue is that I have created a form in a Module.  Whenever I try to access this form, it returns Nothing like it isn't initialized.  Originally I wrote it as follows:     Private mvarFormMain As New frmMain   &nb ...Show All