JohnGriswold's Q&A profile

• Visual Studio Team System Shortcut to "Go to Work Item"

  I know this is "piddly" but is there a shortcut to the "Go to Work Item" command Thanks, ~slee I believe it is Ctrl + G Hope this helps! Sincerely Vince ...Show All

• Visual Basic VB6- .NET 2005 ( Wininet)

  Hi, We are trying to migrate from VB6 to VB.NET 2005. The following function has been used in VB.. ' Opens an HTTP request handle. Public Declare Function HttpOpenRequest Lib "wininet.dll" Alias "HttpOpenRequestA" _ (ByVal hHttpSession As Long, ByVal sVerb As String, ByVal sObjectName As String, ByVal sVersion As String, _ ByVal sReferer As String, ByVal something As Long, ByVal lFlags As Long, ByVal lContext As ...Show All

• SQL Server Can't connect to Analysis Services using the Excel Add-In

  Hi, I've installed Office 2003 (the trial of the Standard edition) along with the Excel Add-In for Analysis Services on a Windows Server 2003 box that is running SQL Server 2005. When I select Build Report in Excel to connect to a cube I've created I am getting the following error when attempting to connect to the server: OLAP Server error on connection SCSRV-DR2\MATTTEST OLAP Server error: Unable to connect to the Analysis Server. T ...Show All

• SQL Server How do I propagate custom properties to downstream transforms in a data flow task

  I implemented a custom source adaptor. I want to be able to associate custom properties with each of the output columns. I want them to be passed downsteam. The idea is to be able to retrieve these information in a downstream custom transformations of ours and process the various columns accordingly. How do I go about doing this I noticed that the IDTSCustomProperty90 seems to have a local scope only. It is not possible in the current data ...Show All

• Visual FoxPro VFP 6 Table designer field length discrepancy

  I have a table with 51 fields and the table designer tells me there are 51 fields with a record length of 999. However, display structure shows 51 fields and gives a total length of 1,003. If I add the individual field lengths together, this comes to 998. I believe a single character is used for the delete character so 999 would seem to be correct. However, another application I am using (PReS from Printsoft) only accepts the data when I s ...Show All

• Windows Forms BackgroundWorker and exceptions

  Hi together, I am using the BackgroundWorker component to do some long time processing work in the background of my form. Do when the DoWork event is finished it calls my RunWorkerCompleted event - Everything seems fine. When the working thread throws an exception I can get the exception in the RunWorkerCompletedEventArgs of the RunWorkerCompleted event. But afterwards I still get the "Unhandled exception has occured in your application ... ...Show All

• .NET Development starting an application with the primary for hidden

  Hi! Application.Run(new Form1()) starts the application by showing Form1. I would like the start-up form of my application to be initialized but remain hidden, since it contains a notifyIcon with which it can be shown. How is this done You can encapsulate you're form in an ApplicationContext. Here's an article that explains it: http://www.windowsforms.net/articles/notifyiconapplications.aspx ...Show All

• SQL Server Newbie: error-message question

  I got the error message: "The metadata of the following output columns does not match the metadata of the external columns with which the output columns are associated". What does that mean and how am I supposed to fix the problem TIA, Barker P.S. The SSIS UI seems extremely slow and sluggish (opening, creating connections). Any performance tweaks known (I have 9GB of RAM on my box and plenty of HD space so I don't think ...Show All

• Visual Studio 2008 (Pre-release) DLink -- Object DAC

  Hi, I am a system architect for fujitsu australia and we have developped something very close to DLINK in a SQL object DAC. I can't discuss the details of our implemetnation online but I would like to suggest a few things. 1- Being able to automatically map an entity to a table while still being able to exclude a few of the fields from being stored... (they may be calculated or even be UI centric) 2- Being able to have an ID inner class th ...Show All

• Visual Studio 2008 (Pre-release) Determaining isselected inside a data template

  Anyone have any insight on how to determine INSIDE a listboxitem's datatemplete wehether or not it is selected (whether the containing listboxitem IsSelected).   Stephen: i think the animation is not starting because you are trying to operate on an item named "ControlPanel" under the logical tree of the stack panel named "ControlPanel", and it can't find the name because it's not looking at the root. ...Show All

• Software Development for Windows Vista Scalability for Hosting Multiple Instances in a Single Workflow Runtime

  Hi, I would like to know the maximum number of workflow instances that a single workflow runtime can handle at the same time. Is it just dependent on the server hardware hosting the workflow runtime or there is a maximum number of workflow instances to be hosted in a single runtime. Hi Akram, The maximum number of workflows that can run simultaneously in a single workflow runtiem is the same as the number of Clr threads av ...Show All

• Visual Studio Visual Source Safe

  Does anyone know of a hosting company that provides hosted VSS services If yes, do you even recommend it Thanks. Just to be clear, gotdotnet is a community server that offers source code control. They do not use SourceSafe as the source control system, though. ...Show All

• Visual Studio Team System How to make TFS recognize my new WSS template (.stp file)?

  I'm getting the final staging of my TFS template customization so it fits into the exact way of how we do things :). Now the final hurdle, I also finally figured out how to change the WSS template (.stp file). Now the question is, once I create my own .stp file, how do I make my TFS template to use it It still goes to the MSFAgile.stp template since my TFS template is customized from the MSF Agile one, so I guess somewhere it references that st ...Show All

• SQL Server now its invalid object name instead query timeout expired

  Using VB, I am running a bulk insert query from csv file into a newly created table. It works fine on small test files; but when I try it on the production data, I get a "query timeout expired" message and processing ends. The text files contain several hundred thousand lines. How can I resolve this problem. I have several hundred of these csv files and more coming. Here's the code: Dim sSQL As String sSQL = "BULK INSERT ...Show All

• .NET Development Undefined data type: 'token'

  I've got a committee designed xsd that I need to read and read xml data against it. I'm getting this error 'Undefined data type: 'token'' on the second line of this VS2005 VB code: Dim _ds As New DataSet _ds.ReadXmlSchema("long path to.xsd") The xsd I'm trying to read has 3 files, 2 imports. It looks like this: transcript <-- academic record <-- core The only place in the 3 files I find 'token' is in the core.xsd file. One of ...Show All