Albert Ross's Q&A profile

• SQL Server Trouble Calling Web service

  Has anyone seen this one - Getting an error calling a web service- error: Unable to handle request without a valid action parameter. Please supply a valid soap action. Can you pass in a soap header in a string as I've done below- is their another way to handle headers- soap action properties- Would appreciate the help- Perhaps other ways to call a web service using System; using System.Collections.Specialized; using System.Text ...Show All

• SQL Server Reporting Services HTTP 401 Unauthorized Error

  I have IIS 6.0 on Windows 2003 spk 1 configured for digest authentication. Using a bland test html document, I can authenticate via IIS using my domain credentials to the html document. I then attempt to access the report manager folder document and get HTTP 401 unauthorized as a message. Not sure what I have to do to the reporting service piece to have it allow digest authentication This is interesting! I did ...Show All

• .NET Development C# oriented object programming - Collection of objects

  What will be the best for me as a C# programmer to use a list of object of the same type.. EXP: Object 1 = League.cs Object 2 = Teams.cs Should i use an ArrayList in my League object to store all teams that are refered to it what will be my best array here for me in .NET framework to use to store objects !! ** I dont have any third party software and i dont want to buy any of them.. because some people have said the arraylist can do the ...Show All

• Windows Forms Problems creating XML and Schema from SQL

  I am using a vb.net program to process SQL Stored procedures to create XML data and schemas. When I validdate the schema (generated from vb) against the XML (generated from vb) I am getting the following error:  The 'prodai' element has an inva ...Show All

• Visual Studio Tools for Office Multilingual CommandBar?

  Hi, I am currently developing an add-on to Word using VSTO that adds a custom CommandBar. As it is directly constructed in the code, how can I have multilingual texts on the buttons Thanks in advance. lynnbt wrote: Does this code work across multilingual installations of Word ThisDocument.Application.CommandBars["Menu Bar" ...Show All

• Smart Device Development Remote spy not working?

  I'm seeing some really weird behavior from remote spy. I've built a test application that is an single document (no doclist) MFC app w/ActiveX support for Windows Mobile 5 PPC version. VS2005 debugger is started and the app is running on the emulator. First weirdness: When I click on the "find window" button in remote spy, the "Menu" button on the test app running on the emulator fires and the menu pops up (the ...Show All

• Visual Studio Tools for Office Accessing data from excel

  Are there any new classes available in vs2005 for accessing data from excel file or still need com interop libraries I need to extract values from the particular cells of an excel worksheet.   Thanks To extract values from the Excel sheet you still use interop libraries.  Managed code allows you to get values from a batch of cells in one call instead of making one call per cell. ...Show All

• SQL Server Indexes and tuning resources

  I'm something of an amateur when it comes to table indexing and tuning and was hoping everyone could recommend some quick-read resources that I can better my knowledge and understanding. I know there are books that cover these topics but I really need some quick solutions and need to better understand these things as quickly as possible. Thanks! - James James, Your best bets are Books Online (either intalled locally or online at http: ...Show All

• Windows Forms SelectedIndexChanged in C# WinFrms databind listbox

  I am having a problem with coding the SelectedIndexChange event on a listbox that's bound to data from a database.  When I code the SelectedIndexChange event, it is fired when the listbox is populated with the data from the database, which resu ...Show All

• SQL Server Problem with query using SQL Server 2005 September CTP

  To SQL Server 2005 Team:   This query works fine on SQL Server 2000:   select    top 10 aename as EscrowOfficer,aomon,aoday,aoyeary2k,                               aemon,aeday,aeyeary2k,aprice,aescr#,aprpt#,abra#,arecmn, arecdy,arecyry2k,Source,absct,asrep1,asrep2,asre ...Show All

• Software Development for Windows Vista CreateProcess() + "highestAvailable" = error 740

  On vista Beta 2, i have added a manifest to one of my executeables that specifies the "highestAvailable" application marking. If I am logged on as a member of the administrator group, with UAC at the default setting, and call CreateProcess() on this executable, it fails with GetLastError()==740. Wouldn't it be better if the process creation succeeded, but as a limited user This makes things very difficult to code for - if my a ...Show All

• Visual C# DataGridView new row

  Why when I add a new row to a DataGridView do all the textboxes show (null)   How do I make it so that these are just empty textboxes Thanks dave I upgraded from Beta1 to Beta2 and it went away.  Thanks for the reply. dave ...Show All

• Visual Studio Adding menus items (don't understand ProvideMenuResourceAttribute)

  I'm taking the normal ToolWindow sample and modifying it to start a new package. This package simply exposes menu items and nothing else. I modified all of the commands and guids and names and stuff and now I'm not seeing my menus showing up as I expected them to. There is only one thing that I don't feel I've changed correctly (though this may not be the true problem) because I dont understand the numbers its using. At the top of the ToolWindow ...Show All

• SQL Server How can I configure sql mail in sql express?

  is that possible You asked about SQL Mail, thats a specific feature of SQL Server and it does not ship in Express. This is also true for Database Mail. The current version of express has as a reporting solution the report controls that are part of VS. An express version of Reporting Services will be made available, but its not part of Sept CTP and I am not sure if it will include sending mail ...Show All

• SQL Server OLE DB Provider - Saving SQL UserName and Password error

  I have created an SSIS package, which uses an IBM OLE DB Provider for DB2 to access some data. In this case it is not possible to use Windows NT Integrated Security, so therefore I stored the username and password in the connection. It works fine for the current user,  but if I log on to Windows with another user and try to change the OLE DB connection I recive the following error:   Error 1 Error loading B ...Show All