NanaKV's Q&A profile

• Visual Studio Team System TF86001: Team Foundation was unable to load the Office AddIn

  After dealing with the daunting install process and getting it right, now I'm able to create projects and work with most of the items, however I found a new issue while trying to open any of the Excel sheets included in the default project team solution structure from WSS and I get that error, funny thing is that this only happens with XL files, since I can open Word and Project files with no issues Here's what I'm running on: Server: Wind ...Show All

• SQL Server Trouble finding Error Code 40 or 53 in BooksOnline

  When my .NET 2.0 app can't find the server, it yields a SqlException with error code 53 and a message that states SQL Server 2005 may not accept remote connections. It also has a Named Pipes Provider error numbered 40. I need to make the error message more user friendly, so I went to BooksOnline to get a complete understanding of the errors. Unfortunately, the Troubleshooting topic entitled "Errors 1-999" enumerates errors 1, 21, 102, ...Show All

• Visual Studio Team System SQL Server collation: Latin1_General

  The installation guide states: For U.S. English, the recommended collation is Latin1_General . When I check, I see server collation as Latin1_General_CI_AI. Yet, TFS setup tells me: SQL Server collation is not set to one supported by Team Foundation Server. What gives Anyone seeking to correct this situation should read this article in Books Online: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/df40c888-691c-4962-a420-78a57852364d.h ...Show All

• Visual Basic AnalogTVTuningSpace and MSVidCtl

  I´m trying to develop a decent tv tuner/capture application (since there are no such apps, nowhere, I say) in Visual Basic 6.0. I´m using the MSVidCtl component together with the AnalogTVTuningSpace and IChannelTuneRequest object to achieve this, as desc ...Show All

• Visual Studio Why can't MSBuild create XML documentation for a VJ# project?

  I asked how to make MSBuild create the XML documentation file for my Visual J# project, and the answer I got in the VJ# forum was... You can't do that.  I'm finding that answer a little hard to swallow, so I thought I'd come here for an explanation. Basically, the situation I have is... I have a Visual J# project/solution.  When I build that solution in VS.NET 2005, it generates an XML documentation file for me.  But when I build ...Show All

• SQL Server problems with average calculations that do not give correct value

  I am currently building a cube and I have two measures that I need to calculate the average for (i.e. columns measureA and measureB). measureA is a Sum of a value and measureB is the count of the number of occurences of the value. I define a calculated Member that employs the calculation of measureA/measureB. This gives me an average that I want to roll up. At the lowest level the calulation is correct, however as the rollups happen the ...Show All

• SQL Server Basic SQL Server Express Questions

  I'm a long time user of SQL Server 2000 but no knowledge of 2005 Express. Among other things I support some small websites that are hosted at very low cost. The host currently provides version 1.1 of the dot net framework and MySQL v4 is standard. I need to add  database capability to one of the sites. I'm looking at MySQL  but curious if maybe 2005 Express would not work. Can I simply deploy a 2005 Express (si ...Show All

• Visual Studio Team System TFS Reporting Errors

  Greetings, I am using the beta 3 refresh of Team Foundation Server. I am getting problems with the reporting services. No data is shown in the reports. When I look at the server's event log, I get the following messages: Event Type:    Error Event Source:    MSSQLServerOLAPService Event Category:    (289) Event ID:    3 Date:        15/11/2005 Time:  ...Show All

• Visual Studio Express Editions Custom Cursor

  Hi, I don't believe it is but does anyone now if it is possible to import your own mouse cursors into a VB 2005 project If so, how. Regards, Andy yes, it is. You can use various methods (by using a MemoryStream on a resource, for example), but to get a full color cursor you will need to use the LoadCursorFromFile Win32 API Call to get a pointer and use that: Private Declare Unicode Function LoadCu ...Show All

• SQL Server How to export SQL Data to XML via SSIS

  Hi, Is there a sample or anything that shows what the best way of exporting SQL data to XML Thanks, David Such request is already there. It is called SSIS: XML Destination Adapter Here is the URL: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx FeedbackID=303815&wa=wsignin1.0 Regards, Yitzhak ...Show All

• Visual Studio Team System "object reference" error on project load

  I'm having a problem very similar to the one posted by Daniel Pratt a few days ago. Steps: --Created an sql2k project. --Imported schema. --Fixed about 270 double-quote-to-single-quote errors. --Upon having a clean project, save and close. --Reopening takes a long, long time (probably around 15-20 minutes), and then i get the object reference error. Project has a fair number of objects; about 100 ...Show All

• SQL Server How to remove ALL as a dimension member

  Is there a way to remove the ALL member that Analysis Services adds to each dimension thanks. In Analysis Services 2000 you can change AllLevel property of the dimension from Yes to No. In AS2005 you to navigate to the highest level in the hierarchy in your dimension and for the corresponding attribute you change IsAggregatable property from True to False. Edward. -- This posting is provided "AS ...Show All

• Visual Studio Express Editions Nested Loops In OOP

  Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim a, b, c As Integer For a = 0 To 1 For b = 0 To 1 For c = 0 To 1 MsgBox( "Fish" ) Next MsgBox( "Dog" ) Next MsgBox( "Cat" ) Next End Sub I Started VBE in Nov/05..... My first OOP Language... I am having extreme Difficulty in Learning OOP.... Would someone please Translate these ...Show All

• Visual Studio Tools for Office Most flexible deployment is to GAC?

  Working on a VSTO Word application. Users will need to be able to pull documents from a Sharepoint site that use the app as well as email them to each other, and also be able to work offline... Right now I have decided to install the assemblies into the application folder. However, I assume that if two users install into different app folders (or if Program Files is on D: for one user...) then they cannot email the document from one user to a ...Show All

• Visual Studio Express Editions Newbie - File copying confusion

  Hi I am severely struggling with even the basics of this part of my project. I have a destination path in a variable, selected via the FolderBrowserDialog function, and this works fine. I have a ArrayList of source paths, mixed folders and files. eg a file as C:\My Documents\TextFile.txt eg Folder as C:\My Documents\Folder1 I am trying to copy each item as follows: if it is a file, copy to destination folder, if it exists, ...Show All