Jon Abbott's Q&A profile
SQL Server OLE DB Command and Destination writing to the same table
Hi, I have a data flow task that performs an "upsert" by directing successful rows from a Lookup to an OLE DB Command that updates rows and unsuccessful rows (Lookup error output) to an OLE DB Destination for insertion. The problem is that execution hangs when both tasks update/insert into the same table (execution is still hung after 20 minutes). Modifying the OLE DB Destination to insert into a different table succeeds (execution completese within 2 minutes). Replacing the OLE DB Destination with a Row Count transformation also works. Could this be due to a table-locking issue Any suggestions Thanks ray rlee1003 wrote: Hi, I have a data flow task that performs an "upsert" by di ...Show All
Visual Studio Tools for Office opening a Word document
I want to open a Word document and then be able to tie into its events. If I create a new Word Document project in Visual Studio, then I get this kind of control over a document because it creates a Microsoft.Office.Tools.Word.Document. I know that I can call (Microsoft.Office.Interop.Word.Application instance).Documents.Open() to open a document, but this returns a Microsoft.Office.Interop.Word.Document object, not a Microsoft.Office.Tools.Word.Document object, so I don't have access to all of the events and properties that I need. Is there a way to get a Microsoft.Office.Tools.Word.Document object for an existing document that I load up from disk There must be a way because the Word Document project seems to be doing this, but I can't f ...Show All
SQL Server Removing a paramater gives an error
Removing a parameter on a Reporting services report based on a 2005 AS cube results in an error: [rsParameterReference] The Value expression for the query parameter ‘KalenderHierarchieJaarMaand’ refers to a non-existing report parameter ‘KalenderHierarchieJaarMaand’. On the dataset, the parameter still exists. The error still occors after removing the parameter overhere too. Steps to reproduce: Build a raport based on a cube. Make a parameter in the dataset. check if the parameter works. Save the report and remove the parameter via the menu: Report> Report parameters > select the parameter and choose [Remove]. go to the "Preview" tab. Has anyone found a work-around for this Thanks in advance, ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Why does XNA render at 75 Hz in fullscreen?
When I run my game in window mode it runs at 60 fps and 60 Hz (which runs fine). But when i run it in fullscreen it runs at 75 Hz (but 60 fps, which makes the movements a little jerky). My monitor is set at 60 Hz. Why does XNA run in 75 Hz in fullscreen Other games run at 60 Hz (in fullscreen) on my computer. Shawn: after swithcing to fullscreen, XNA GSE changes the monitor refresh rate to 240Hz by default (at least, in my case) for 800x600 and to 200Hz for 1024x768. Everything is back to normal after hooking the event you mentioned and manually setting the rate to an accepted one (like 60Hz, 72Hz or 75Hz). ...Show All
Visual C# Sound In Form...
Hi, I was wondering if someone could provide me with some code to simply add a continuous sound playing in the background of a form I have performed a few searches but all examples are really complicated. Isn't there an easier method hi, i have a simple solution for it. we can give it in <bgsound> <head> <bgsound src="mysound.wav" loop=10> if you give loop = infinite it will play repeatedly... and if you want at server side add runat =server. i don't say its a perfect solution.but its a simple one ..try it out.. Regards Baji Prasad.B Bangalore India. ...Show All
Visual Studio Express Editions How can I specify the location where a form pops up?
When I click the "Help" button, the Help form pops up at random locations. How can I specify the location where it pops up Private Sub HelpButton_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles HelpButton.Click Dim f20 As AccDragDropHelp = New AccDragDropHelp f20.Show() End Sub The following will specify the position of the form popup to a manual location at coordinates 100,100 THis gives you pretty specific control over the form - instead of setting the startposition manually you can use some fo the other options for this. http://msdn2.microsoft.com/en-us/library/system.windows.forms.form.startposition.aspx With various se ...Show All
Architecture Physical seperation of layers - business layer -> data layer?
Hi Forum Does it make any sense to build a design that supports more than one physical seperation. I'm making a web application and I need to make it secure and scalable. I can see an idea in making it possible to physically seperate the presentation layer from the business layer. You can put the presentation layer in a DMZ. Does it make sense to make it possible to physically seperate the business tier from the data tier What requirements would justify such a design I'm making a web application that is to run on a web farm in a hosting center. There is not reqirement that the data tier is to run on there other side of the planet. I'm thinking mostly about security. I know that making physical seperation has a perform ...Show All
Windows Live Developer Forums I lost my pictures spaces live
I lost my photos blog en my spaces live. I can't see them. what can i do I'd like to erase my espace y edit another one. can i do that HELP me please Romerriera: This forum is for questions and discussions related to Windows Live Spaces development. For questions related to using Windows Live Spaces, try the Windows Live Help Central page: https://account.live.com/HelpCentral.aspx . ...Show All
Software Development for Windows Vista Setting volume levels with IAudioVolumeLevel
Hello, I've been trying to set the level of a particular part by using the IAudioVolumeLevel interface of the API. I can Activate a valid instance of the interface, and when I call GetLevelRange on it, I get a min value of -34.5, a max value of 12, and a step value of 1.5. However if I loop through the valid step values and set them with SetLevelUniform, while comparing the value of the volume level slider in the Control Panel (which goes from 1-100), I get unexpected results. The number on the slider (and volume from the speaker) remains at 0 for the first 8 iterations of the loop until I get to a level of -24 for the SetLevelUniform call, at which point the slider value moves to 1, where it remains until the 8th iteration in the loop ...Show All
SQL Server copying a DB from one server to another
Hi I have a PC with MSDE2000 and need to copy the data to another PC running SQL2005. I have registered the MSDE server on my SQL2005 PC and can see the tables etc. Can this be done automatically, say every day Is there a way of mirroring the DB Cheers Eugene Hi Steve I Am using 2005 Std, I have also just installed SP1 I was hoping to use the mirroring function but it looks like it only works with sql 2005 DB! The same is true of Log shipping I think So is there any samples of how you use this integration service I am not that familiar with SQL as a whole and it would be good if there we're simple ways around the problems. I would of thought there is an easy way to au ...Show All
Windows Forms communicating between objects
Lets say I had a windows form Form1. Now, later at some point I created an object of the form Form1 ^myObj. How would I send lets say a string that this new obj gathers to some control on the form itself How do I communicate between the two Oh darn... so this isnt gonna work. Thanks for the pointer. I'm looking into this invoke stuff and will have to figure out how to make this work. If you can think of any code samples that may help, please pass along. Appreciate your help!! ...Show All
Visual C# System.TimeZone/TimeZone resource
I am creating an application that will use timezones, both nationally and internationally. Are there any resources on the net that I can get a list of time zones, or development insight I don't know if you are familiar with SimpleTimeZone, but that is what I am using for this project. However, it requires the Abbreviation and Daylight Abbreviations. Is there somewhere I can get this information I can't find information on half the Time Zone's listed in the registry. ...Show All
Visual C++ Error result 1 returned from 'C:\Program Files\Microsoft Visual Studio 8\VC\bin\rc.exe'
I am trying to build a Visual Studio 2005 C++ application, but I keep getting this error whenever I do a build in debug mode. Any suggestions as to what to look for Is there something I should change in Tools/Options/Projects and Solutions/VC++ Directories My Path environment variable Thanks, Shelley In this thread the solution seemed to suggest that replacing "C:\" with "C:\\" for the last path in the VC++ Includes directories. I did this and it had no effect, I still get the same build error. Does this need to be done somewhere else also Do all the "\" need to be replaced by "\\" in those paths or just the first occurrance ...Show All
Visual Studio Deployment without using merge modules
Hi there, does anyone know a way to deploy CR components without using the VS 2005 merge modules. The problem is as follows. we developed a (business) framework for the use of variety of application. For the reporting part we thought of using a "generic" method on our application server. There we create database stored reports and pass them to the requesting clients. By strict guidelines of the hosting center, we're not allowed to made changes to the clustered windows enviroment - such as installing dll to windows directory / gac or so. Unfortunately for using CR it seems only to be possible to use the CR engine after installing the merge module for CR which is not possible in our case. Does anyone know a different ...Show All
SQL Server How do I get Management Studio to not reset the selected database to Master when I open a new query?
Hi there, I often have to run multiple SQL scripts against a single database. SQL Server Management Studio always reverts the selected database to Master whenever I open a different SQL file. This requires me to re-select the correct database, and if I forget, I end up running the script against the Master database. SQL 2000's query analyzer "remembered" your selected database and did not force you to re-connect each time. Is there any way to make SQL Server Management Studio act this way Thanks! Kiron Hi Sethu - thanks for the response. Unfortunately, this will reset the default database, as opposed to having the new query session just "remember" the database that was ...Show All