T.Beal's Q&A profile

• SQL Server SQL Server 2000 Personal Edition or Enterprise Edition

  I am trying to access SQL Server from a seperate VMWare session. I have instsalled SQL Server 2000 Personal Edition on my main PC and am trying to access it from a seperate VMWare session. When I do this, I get the following message: Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection. I have checked my Enterprise Manager and is is setup with SQL Server and Windows authentication. Am I able to ...Show All

• SQL Server SSIS: Inserting unknown members from fact table

  Looking up surrogate keys in a dimension table and adding these to your data flow is easy when there is a match in your dimension table for every key in your fact table. However, I am puzzled by how to manage the data flow when no match can be found for a specific key in the fact table when doing the lookup AND I then want to insert this unknown key as an unknown/inferred member in the dimension table. The problem is further complicate ...Show All

• .NET Development Is v2.0.50727 the final?

  I installed Visual Studio RC and found that the Framework version is v2.0.50727. Will this be the final version Hello, As far as I know, the final version of of the Framework is v2.0.50727.42. Hope that helps, Stephen [Microsoft Common Language Runtime: Security - Developer] http://blogs.msdn.com/stfisher ...Show All

• SQL Server SQL 2000 Report services incomplete export to excel

  I have a report that I am trying to export to excel.   The export seems to work but the data in the spread sheet is incomplete.   The document map is completely exported but the work sheets are not.   The links in the document map stop being links after the first occurrence of the lowest level detail.   All the data is visible in Report services and all the data exports to PDF.   There are 5 levels and 124 page ...Show All

• Visual Basic Opacity Problems

  The Opacity property on a windows form allows the form to look translucent.  By looping through varying degrees of opacity in the form's closing event I have a form that looks like it is fading out.  In VB 2005 I have been unable to replicate this.  The problem is that when the form begins to fade, instead of retaining the form's look and colors, it turns completely black and then fades to lesser degrees of gray.  In VB ...Show All

• SQL Server What component to use for Calling View

  In SSIS 2005 what component can I use inside my Data Flow task to call my View and use it as a datasource I know I've used an Execute T-SQL Task but I don't know what component to use inside an actual task itself. What I'm trying to do is in my Data Flow task, instead of using 3 OLE DB Source components, I want to actually call 3 stored procs and use those 3 components as the data sources to merge on using the merge and sort components later on ...Show All

• Windows Forms Serialization of custom colors (and other types)

  I have defined some custom colors (and fonts, etc.), and would like to be able to have designer serialize these as the custom types rather than numeric values. Here is a psuedo snippet: // Implemented as a singleton... details are excluded public class MyColors {   Color _myGray = new Color.FromArgb( 42, 42, 42 );   public Color MyGray   {     get { return _myGray; }   }   // ... exclude ...Show All

• Visual Studio Team System Exporting Load Test Results

  Hi, I am running load test runs on two different system with VSTeam Suite on both. I am trying to export results on the other system to the local system. When I try to open the results, i get an error :Could not read results repository. An error occured while connecting to the server....Error 26 - Error locating server\instance specified) I checked that the SQLserver has the TCP/IP enabled but am not able to open the SQL server surface are ...Show All

• Visual Studio Problem with custom DDEX Provider on Binding Source configuration

  I'm writing a DDEX provider for the Firebird ADO.NET Data Provider (firebird.sourceforge.net) While Trying to configure a BindingSource from an existent connection ( that can be opened correctly from the Server Explorer and it shows the tables, stored procedures and views information correctly ), i'm getting the next error: --------------------------- Microsoft Visual Studio --------------------------- Failed to open a connection to the databa ...Show All

• Windows Forms How do you refresh data bound to a DataGridView

    This should be easy... but I don't know how to do it. I have created a DataSet that is bound to a DataGridView so that the DataGridView displays the data in my DataSet.  If my DataGridView is called dgvStudents, the following code DOES NOT do the job: dgvStudents.Refresh(); I can see the grid itself flash and refresh(), but the data behind the grid is not being refreshed, so new items in the database (added by another pro ...Show All

• Visual Studio Tools for Office Design Issue in Word VSTO Programming - Save vs Autosave

  I've a requirement to do certain tasks (say connect to db and update a table) when user Saves the document. The code is now written in BeforeSave event. The issue is BeforeSave event is getting triggered even for AutoSave. I dont want to do anything for autosave. How to distinguish between user's save ( menu click , ctrl+s, icon click) vs autosave of word feature -sraju Hi Youenn, You can "ove ...Show All

• Windows Forms ComboBox bug?

  ComboBox control’s TextChanged event does not fire if selected item is changed using keyboard. Its DropDownStyle is set to DropDownList. Is this a bug or it’s supposed to work this way Any workaround to capture this event Note: This event is fired if selected item is changed using mouse. This event is fired (by keyboard changes) if its DropDownStyle is not DropDownList. You sh ...Show All

• Visual Studio Internal Error 2908 {7D4B5591-4C80-42BB-B0E5-F2C0CEE02C1A}

  Gentlemen, I got a problen when I were installing the .net framework. The error message is "Internal Error 2908 {7D4B5591-4C80-42BB-B0E5-F2C0CEE02C1A}" Is there anyone can help me to figure out what it is Thank you ! Geoffrey I'm getting the exact same error. When I click ok it gives the further error:   Error 1935.An error occurred during the installation of assembly 'Microsoft.Vsa,V ...Show All

• Visual Studio Express Editions Cannot install SQL Server 2005 Express

  Hi, I have tried installing SQL Server Express 2005 a couple of times after installing Windows XP with/SP2. Also, I noticed that SQL Server 2005 was installed in the Add/Remove area within the control panel. Thus, should I remove the SQL Server 2005 things and retry the installing of SQL Server 2005 Express Thanks in advance, -Conrad Something that came as a suprise to me after initially inst ...Show All

• Windows Forms What is the best practice to store application messages in multi-language applications?

  Hi, I'm developing a multi-language application. For localization within buttons, labels, and everything on forms, it's quite simple as you all know that the VS.NET manages satellite assembly for us. However, what about other messages such as application messages which are shown in MessageBox and error messages As far as I can imagine, there are 3 ways :- 1. Store these messages in database by making a table like (messageID, culture ...Show All