Shaun's Q&A profile

• SQL Server Reports Services will not work with SharePoint 2003 and SQL Server 2005

  We have installed SharePoint Portal Server 2003 (it is working correctly) and SQL Server 2005 (it is working correctly) on a single virtual machine. If I enter " http://ComputerName/ reports" to display the Report Manager we get the following error: (yes, I did put in our computer name in the appropriate location) Parser Error Message: An error occured loading a configuration file: Access to the path 'c:\inetpub\www\root\web.config' is denied. Is this a permissions issue, a configuration issue, or something else Any suggestions for resolving this would be appreciated. ...Show All

• .NET Development Dealing with an offline SAO

  I have a client that invokes an single call SAO hosted on a NLB cluster. The SAO hosts a finite resource, under certain conditions it will need to delegate to another server (in a way acting like a client). If I take down a server, the client is directed to a 'good' SAO, but delegation won't stop the server carrying out its resource checks, invoking a request to an offline server. The timeout on this synchronous request is LONG (I've not found a way to change it), so I've considered asynchronous requests with timeout to hear back. I'd be concerned if I'm re-inventing the wheel. Am I on the right track Is there a design pattern I should be ...Show All

• Windows Forms CellBeginEdit is fired after moving focus to a DataGridViewCheckbox cell

  My application sets a status flag if the user starts editing data in a datagridview. So I use the CellBeginEdit event and it works fine for dgvtextboxes, dgvcomboboxes, etc. But now I have a dgvcheckboxcolumn and found out, that the event is fired just after entering the cell by keyboard or mouseclick. Additionaly the property "isInEditMode" is true during the cellvalidating event for the cell. Is this the correct behaviour by design or a bug I use VS2005 Beta 2. Thank you! This behavior is by design for cells that do not host and editing control (IDataGridViewEditingControl). The CheckBox c ...Show All

• Visual Studio BUG: Add-In Wizard not available in VS2005 Beta 2

  Hi! I am not sure whether this bug was already posted here. I have installed VS2005 Beta 2 (Version 8.0.50215.44) and the latest VS2005 Beta SDK (VSIP) and the wizard for creating VS addins is not available anymore! The whole "Extensibility Projects" tree is missing if I open the wizards page through "File -> New -> Project...". Is this a known bug Are there any workarounds available Kind regards Sebastian Hi Bob! Now, it works! I reinstalled Visual Studio 2005 Beta 2 Professional Edition and anything is fine. Maybe there was an installation option unchecked during the first setup. Kind regards Se ...Show All

• Windows Forms How can I get the DisplayMember value in a combobox in the datagridview?

  I have a datagridview dgv with columns name and companyID, companyID column is a combobox, now, how can I get the DisplayMember value and not the ValueMember Get the cell's FormattedValue instead of value. -mark DataGridView Program Manager Microsoft This post is provided "as-is" ...Show All

• Visual Studio Team System How can I import work items from one project to another?

  I have a number of issues in a project we just completed. We're starting a new project and there are specific work items I would like to import to the new project. Is there a specific way to do this Any help would be appreciated. aaron As far as I know, there is no "automatic" way of doing this, all you can do, is make your own program, using WI object model, to do the import. You can find more info about the work item object model on the Visual Studio 2005 SDK ...Show All

• SQL Server Cluster nodes

  Hi All, I've heard in a presentation that the number of supported nodes in a cluster on 64bit system is going to be limited to 4. Can you confirm that What about the number of instances These are the informations that I have: 25 in a cluster (a drive letter is required per cluster group) 50 in a standalone server with Enterprise Edition 16 on the other Edition Can you confirm as well Thanks for your response. Jerome The maximum instances I have seen on MS SQL 2005 is 16 instances on 4 nodes. ...Show All

• Visual Basic What has .tabenabled changed to in .NET?

  In VB6 I was able to use frm.FormName.tabenabled(2) to select the second tab on a form. It seems that the keyword has changed. And for the life of me I can't figure out what it has changed to. Any help on this would be appreciated. Thanks. In VB.Net Tab Control, Each of the pages on a tab control will appear as separate controls, you'll see this when your looking through the controls on the form. So all you have to do is set the selected tab page. The following code will alternate between selecting tab1 and tab2 and illustrates setting and getting the selected tab If Me .TabControl1.SelectedTab I ...Show All

• Visual Studio export each page on different pdf file

  Hi! I have a dataset containing two related tables. The parent table contains many rows. Each of them normally creates a page in my report. Is it possible to export each of these pages into separate pdf files The most simple thing to do would be to loop through each row, copy  it to a new dataset, copy also the child rows and then perform the export to the new dataset. Can you think of a more elegant  way to do that Thanks Dimitris Thanks Mark, I think this will do the job for me. I was wondering though: When does the actual rendering of the report takes place I hope that if I execute the Export method several t ...Show All

• Visual Studio Express Editions Creating a line break in a messagebox

  How do I create a line break in a messagebox ...Show All

• Windows Forms DataGrid word wrapping

  Could anyone post an example os a word-wrapping datagrid If not, and because I need to implement it, I'd like to know where the row height can be altered, since that all i need to override the Paint event of DataGridTextBoxColumn object. I've been looking for hours trying to find it without success, and it MUST be saved somewhere, as it's somehoe pres ...Show All

• Windows Forms VS 2005 Copy and Paste a Form in Solution Explorer

  Has anyone tried to duplicate a VB WinForm within a project. I tried copy and paste a form (with controls on it) and then rename the new form but I got multiple errors. One of them is the following: Error 4 'Private Sub InitializeComponent()' has multiple definitions with identical signatures. What's the correct way of doing it Please help. Thanks. I just realized my mistake. I was trying to rename the "Copy of FormXX" in the Solution Explorer before I changed the class name in the .vb and the Desinger.vb. I need to fix the class name in the "Copy of FormXX".vb b ...Show All

• Visual C# how long a image can be??? SQL

  Hi i try to load a movie in my DB .. as a image type.. problem is that when i try load big filles int o the DB it hangs up for 15 min.. windows si not respoding anymore .. and at the finsih i get an exception.. i yhink its because the image type cant support such large file.. anyway.. does someone has ideas for foing this Thanks!! Dear Zapacila, Regarding the size of Image, SQL server can support till (2^31-1) amount of data for a single column.So,please dont get confused with the limitation of space.In appsettings please change your time limit to maximum.By default, it's only 20 minutes. Regards, vinoraja. ...Show All

• Visual Studio Tools for Office UDF in Excel XP with C#

  HI All I'd like to write UDF in Excel XP using Visual C# Express Edition just downloaded. I'm quite new to C# so I searched on the web for some examples, and I found this http://blogs.msdn.com/eric_carter/archive/2004/12/01/273127.aspx . I followed all the steps suggested (I do not post the code because it's exactly the same you can find in the article above), added the Automation Add In to the Excel Add In list. Then I put into a cell on a blank sheet my sample function created in C#. Result : #NAME ie Excel does not recognize my function. I checked in the functions' wizard and there is not the category AutomationAddin.MyFunc ...Show All

• SQL Server Partition Scheme

  Hello everybody, how can I verify a partition scheme in SQL Server 2005 (June edition) SELECT p .* FROM sys.partitions p , sys.objects o WHERE o . name = 'mytable' AND o . object_id = p . object_id GO this always returns only one partition thank you Eckard BTW, there is some confusion about terminology.   A partition != a partition scheme.  The query above looks at a table's partitions.  It does not "verify a partition scheme."  Every table has at least 1 partition that ultimately refernces a filegroup.  A partitioned table has >=1 partition that ...Show All