sdochert's Q&A profile

• SQL Server MSDE or SQL 2005 Deployment resources - real world input

  I have traditionally done web app and client server programming and am have been playing around with a new tool (Win forms) app that I eventually want to distribute to other developers and a couple of business people in our organization. I have done apps in the past that all connect to a central server for data access. The I'm working on now will have an individual DB per user and should be available locally for a desktop version of the software. I am looking for more resources on things to consider when deploying an app with either MSDE or SQL 2005 Express. More specifically, items like long term maintenance of the db once it's installed with the user, etc. (DB bloat, transaction files, auto maintenance routines I may want to build in, ...Show All

• SQL Server Reusing package configuration file across all packages in a solution?

  I have 5 packages in a solution. For 1st package, I add a package configuration file (xml) named common.dtsConfig containing only Database Connection configurations. For the same package, I add another package configuration file names first.dtsConfig containing configurations specific to 1st package. Now for 2nd package, when I reuse from existing package configuration (common.dtsConfg) with same name, it allows me to do that. I also create a package specific configuration file for 2nd package. And so on for all 5 packages. This works fine for development. If my database user/password changes, I edit onyl one file i.e. common.dtsConfig. But, when I want to create the deployment utility, it fails by throwing error that "cannot cop ...Show All

• Visual Studio Express Editions invalid breakpoint on line number over than 65535 in c++

  Using Visual c++ 2005 , we can set breakpoint on line number over than 65535 But when running, break point over 65535 become invalid with this message "The breakpoint will not be currently hit", invalid file line : 102183 Breakpoint under 65535 are ok. Documentation say we can set breakpoint up to 2^24 - 1  line number At compile time, we did not get the c4049 warning as in Visual C++ 6.0 said. Steps to reproduce : Compile a large c++ file ( over than  65535 line ) set first breakpoint on low line number set second breakpoint on high line number Start debug Results: First breakpoint is checked ( valid ) Second breakpoint become unchecked ( invalid ) Expected: Can debug up to 2^24 -1 line number We di ...Show All

• SQL Server Connection Manager problem in ScriptComponent

  Hi, I am using OleDB source as well as Script component in my package. Both these component are using same database. But as of now I am using two connections for each of this comp as I am unable to make use of the OLE DB connection in script component. How can I solve this. I mean how can I use the the OLE DB conn which I used in OLEDB Source comp in the Script Component. Any help will be greatly appreciated. Thanks For script component, create and use ADO.NET connection manager. OLEDB connection is not meant to be used from .NET. If you really need to use it, you should create a custom component in C++, rather than using script component. ...Show All

• .NET Development ExecuteNonQuery asynchronously

  Hello, Is there any way I can run ExecuteNonQuery asynchronously, such as initiate stored procedure call and return immediately. Thanks, Hi How does this work for ASP.NET I also need to execute a long-running stored procedure from a web page and have that web page return immediately (it's just executing a big DELETE and I have no need to display any results on the page). I can see that "BeginExecuteNonQuery" would be a great way to do this - but I am worried about if/how the database connection gets closed. Normally, you specify a callback method in the call to BeginExecuteNonQuery in which you close the connection. But does this work in ASP.NET Is it possible for the callback method to be executed long after the page r ...Show All

• Software Development for Windows Vista Hows start workflow?

  Good day! I am novice in programming. In Visual Studio I created a simple Workflow "Workflow1" and an aspx page "InitForm.aspx" with one textbox "Assigned" and one button "Start". In workflow.xml I wrote InstantiationUrl="_layouts/InitForm.aspx". Question: Sombody can explain to me how to start Workflow from ASPX page being hosted on a Windows Sharepoin Service and send data to workflow "Workflow1" from texbox "Assigned" Malya - not sure what difference/value addition Windows sharepoint service as a host provides for hosting workflows. You might consider posting this on Sharepoint forums. However if you want to host a w ...Show All

• Visual Studio Express Editions Reading Data from Network Stream

  I need to know how to read all the data from a network created by a TcpClient. The MSDN documentation on the TcpClient only showed me how to read a certain amount of data from the stream not all of it. So how would I go about writing a request to a NetworkStream and then recieving the entire response Thanks, David you would normally read the data recieved into a byte[] buffer then handle it in your way. an example (stripped from a project) //listening method: this.theClientSocket = this.theClientListenerSocket.AcceptSocket(); this.theNetworkStream = new NetworkStream(this.theClientListenerSocket); .. .. byte[] theDataRecieved = new byte[1024]; int theData = 0; theData = this.theNetworkStream.Read(the ...Show All

• Windows Forms Web Browser Control cookies

  Hey, I am using a combobox to show the URL you are at on the webbrowser control, and I made it so that when you press the Go button it will add the Url to the Combobox list... WebBrowser thiswebpage = GetCurrentWebBrowser(); // Get the currently displayed WebBrowser URLtextbox.Items.Add(thiswebpage.Document.Url); But wehn I look at the combobox it has the webpage URL you were jsut at about 10 or more times in a row...So it is saving the cookies more then once, how do I fix this Thanks :) look through the collection of objects stored in the list according to the solution I had provided you via email. So, for each element in the array, if current element.url does not equal URLTextbox.Text, ad ...Show All

• SQL Server access problem

  Hi, The Report Server and the server hosting web application are differrent. I have an aspx page with the reportviewer control. If I try to open the page with the report control its giving me a message privilages for the user 'domain/server$' are insufficient for performing this operation ". where the 'server$' is the IIS server hosting webapplication. Please help me in solving this ...Show All

• Visual Studio Team System Newbie Questions

  Hello! I am new to the team system. How can I analyze my Application for performance issues Is there a profiler in the Team system How do I use it Matt aha you have a profiler in the Visual Studio Team system for developers, to use it, just go to Tools/Performance Tools, where you can create a new performance session. I also recommend you to use it (it will be easier) together with unit testing, when you run unit tests, if you go to the results and right click on any test, you will be able to create performance session on that method. I know it's a really brief resume, but here I put you some really good articles about it: (three articles about how to use it): http://blogs.msdn.com/ianhu/arch ...Show All

• Audio and Video Development WMP and multiple audio stream divx

  Is there a way to change the audio stream of a divx playback in WMP library Your question is about WMP; try it here: http://www.microsoft.com/windows/windowsmedia/community/newsgroups/WindowsMedia/default.mspx dg=microsoft.public.windowsmedia.player&lang=en&cr=US ...Show All

• Software Development for Windows Vista Final list of runtime services available in WF .NET 3.0

  Since the inception of Windows Workflow, I think there have been some runtime services that have come and gone. I was just wondering if there was some documentation I can consult to find out what the final set of runtime services is in the .NET 3.0 framework Any help you can provide would be very much appreciated. Thanks, canuck81 Check the SDK documentation for Workflow services http://msdn2.microsoft.com/en-us/library/ms734738.aspx Hope this helps ...Show All

• Visual C# how to return null from a constructor

  say, i a m trying to do something like: class something something(streamreader){ if (wrong format or end of file) caller receives null as result else build object from what has been read in file } i tried 'return null', but it says it can not do that since a constructor is 'void', so i can not place a return sentence. i'm not sure something like this.dispose would retunr a null, since the 'dispose' may be asynchronous (or something) i have the next alternative class something blah blah somehting(string) (build object from string, check if string==null or wrong format before calling) static bool checkformat(string) check to see if string is adecuate to build somet ...Show All

• Windows Forms Working with Data in Datagridview

  I have been successful in creating a datagridview based on a data source that links to a view in a SQL Database. I have figured out how to create a query with parameters taken from testboxes. Now that I show the data. How do I access the records(rows) to do something. For instance, there is a returned column that is called extended (price * quantity). I would like to go through the records and add this up to show the total in a separate textbox. Any help will be appreciated. Thanks JasinB (David) The example adds a column to the dataTable which calcuates the total price. The new column will show up in the datagridview and will automatically recalculate when the unitprice or quanity cha ...Show All

• SQL Server Lookup on AS400

  Hi everybody, I'm new in SSIS and I'm trying to activate a lookup on a table reside on DB2/AS400. Iget the following message when I try to join the input column to the lookup column: TITLE: Microsoft Visual Studio ------------------------------ The following columns cannot be mapped: [STOREK_S, STOREK_S] One or more columns do not have supported data types, or their data types do not match. ------------------------------ BUTTONS: OK ------------------------------ I know both columns have the same format on the DB2 table. What I'm doing wrong P.S: I'm using the IBM DB2 UDB for iSeries IBMDASQL OLE DB Provider as connection. If I try with the Microsoft OLE DB Provider for DB2, I was unable to get the list of ...Show All