ScottComstock's Q&A profile

• SQL Server Removing Columns from a data flow

  Seems obvious but I can't see how. How would I remove columns from a data flow so that columns which have been used earlier but are not needed for insert/update are taken out of the flow. I'm asking because the data ends up in a update statement and the flow has got so big it is unreadable. Cheers, Al You cannot remove a column from the buffer, the best method is to not create it to start with. Obviously starting from your source, only bring through the columns you need. Any asynchronous components, e.g. Aggregates, Sorts, Joins, can also be used to carefully select only the required columns. A new ...Show All

• Microsoft ISV Community Center Forums read only file opening

  Hmm, it worked for me... maybe you should dim a new object for the wb and close that. Then you won't close the whole Excel application accidentally.;) But if that doesn't help, try posting some of what you do inbetween opening and closing the workbook... Dim xlApp As Excel.Application 'Note: better memorywise Dim WB As Workbook On Error Resume Next Set xlApp = GetObject(, "Excel.application") Set WB = xlApp.Workbooks.Open(sFileName, False, True) If Err.Number = 0 Then 'error checking, values are read only if Workbook has been successfully opened ' code for reading values WB.Close (False) Se ...Show All

• Visual Studio Express Editions Visual Basic Installation Error 1304

  All, I am having a bit of trouble installing VB 2005 Express Edition on a Windows XP Professional Machine.  I am a local administrator as well as a domain administrator so I know it has nothin to do with privileges.  I am using the manual installation as we are unable to connect to third party program installation procedures through our proxy server.  So, I have tried to install the program and it installs the .Net Beta 2.0 perfectly and then when installing VB 2005 I get this error. Error 1304. Error writing to file: Microsoft.VisualStudio.Debugger.Interop.dll.' Verify that you have access to that directory. I have tried to j ...Show All

• Visual Basic Pardon my ignorance.. Visual Basic ".NET" ?

  I've been out of the development loop for over 4 years. What is this Visual Basic ".NET" Is it a different version of Visual Basic I've seen Visual Basic 6 and Visual Basic 2005. What is the latest version, and how does Visual Basic ".NET" fit into all of this I didn't see a ".NET" version of VB for sale.. Clearly I'm missing something. Any help or links to more info appreciated! Just when I thought I'd made my decision. Thank you for the tip. I'll check out C#. ...Show All

• Architecture Smart Client and the Mac

  Is it possible yet to develop a smart client application and deploy to the Mac as well as the PC I'm assuming this depends on whether there's a viable CLR for the Mac And what about deploying to Linux is this possible see the mono project ... http://www.mono-project.com/Main_Page runs in linux and on a mac. Cheers, Greg ...Show All

• Visual Basic Configuration Sections

  Hi, I've just started playing with VS2005.  We currently have a VB.NET application which uses a custom config section implemented by declaring a class which implements the IConfigurationSectionHandler interface and which was invoked by declaring it in the <configSections> section of app.config. The section handler so defined parsed a 'systems' configuration section in app.config and returned a collection of objects from its Create method. The result of this was a <systems> configuration section in app.config which in turn was made up of one or more <system> entries, as for example: <systems>   <syste ...Show All

• SQL Server SSIS Send Mail Task - Failure Sending Mail

  Hi Everyone, Hopefully someone out there will have an idea as this is driving me nuts. I've setup a task to email on success/failure and keep receiving the following message when executed: Progress: The SendMail task is initiated. - 0 percent complete [Send Mail Task] Error: An error occurred with the following error message: "Failure sending mail.". Progress: The SendMail task is completed. - 100 percent complete Task Send Mail Task failed When I configure Outlook Express on the same machine with the same settings it works. On the SMTP Connection Manager I have left the default name, tested with both an IP address a ...Show All

• SQL Server List all your connection managers

  Hello, I'm building a custom task which has a property ConnectionManager which obviously allows you to select which connection manager you're goinng to use. I know how to get the list of connection managers but how do I make them appear in a combo-box in the properties pane Anyone got some code for that Hopefully this is fairly trivial for you developer types out there. Thanks Jamie Adam Tybor wrote: I don't know about dataflow components, but on a custom task I simply created a property of type ConnectionManager and it gave me a drop down list of all the connectionmanager's guid's in the package. The built in type converter has ...Show All

• SQL Server SQL server memory leak

  I was doing a quick test with SQL Server Express and noticed that there is memory leak Here is the pseudo code do loop //1000 times { 1. Open connection to the database 2. Build SQL statement 3. Construct SQLDataAdapter 4. Fill DataSet using ( adaptor.Fill(dataSet); ) 5. Close connection to the database 6. Dispose whatever is disposable } When I ran this test I saw that SQLServer service memory usage is going up and never released Is there something that I am doing wrong. If I ran same test against Access database then there is no problem Thanks I found and I think this is default behaviour of SQL ...Show All

• SQL Server Server Registration

  TITLE: Microsoft SQL Server Management Studio Express ------------------------------ An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 41 - Cannot open a Shared Memory connection to a remote SQL server) (Microsoft SQL Server, Error: 87) For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=87&LinkId=20476 ------------------------------ BUTTONS: OK ------ ...Show All

• Visual Basic Communication Between Objects? Is it possible without creating a new object

  Hello, I'm a beginning programmer, and I have a problem that involves object oriented programming. I'm making a game and in this game there is a form and another class called "ship". So when the form runs it makes a ship to be "myship" Public MyShip As New Ship( ByVal vbobject As StarGame.Main ) Now in the object ship there is a method called MoveTo(ByRef x as integer, ByRef y as integer). In the code it step by step moves the ship toward the destination by changing the x and y of the ship. Everytime I do this I want the form to show the movement of my ship. I tried using an interface, again I am a beginn ...Show All

• Visual Studio Express Editions Install a database..

  Can I install a database in windows xp home edition ... I don't see any reason why you couldn't.  http://msdn.microsoft.com/vstudio/express/sql/download/default.aspx The SQL Express download page just says XP, so I assume you'd be fine.  Is this what you mean by a database Do you have a programming language such as C# or VB.NET installed to write code to interact with the database   ...Show All

• Visual Studio Team System Replace MSF Agile May 2005 Beta in VSTS Beta 2

  Hi: Just wondering could it be possible to replace the contents of MSF Agile showed in VSTS Beta 2 (April 2005) with the newest one manually when I created a team project   I found the May one contained more information. Or wait for new CTP Thanks! Hi: I downloaded the MSF for CMMI Process Improvement as expected today, July 8, 2005.  God work!  Thank You! Next, when can we get the process template for MSF CMMI Thanks! ...Show All

• Visual C++ How to work in VC++ .net 2005

  i’m doing the first steps in vc++ 2005, and i like connect a data base in access (.mbd) in my program I trying use OLEdataAdapter, i configured the wizard... i think... Its possible sendme a simple exemple conde, whith how to connect a data base e a simple code using a sqlcode Select. I believe you might need to configure your data source using the ODBC administrator to use the Access database driver. Take a look http://msdn2.microsoft.com/library/ck4z6wwt(en-us,vs.80).aspx  & http://msdn.microsoft.com/library/default.asp url=/library/en-us/odbc/htm/odbcchoosing_a_data_source_or_driver.asp  where you can find an example. ...Show All

• Windows Forms Replacement of ImageList Collection Editor

  I'd like to know how to either replace the ImageList Collection Editor  or at least have it show my images in the correct size instead of  "scrunched".  Probably because the ImageList is required for many of the Windows Forms controls, there is no way to attach an alternate collection to say a TreeView because the TreeView is bac ...Show All