maria_tachi's Q&A profile

• SQL Server Connectivity Issues in AMO

  Hi, I am using AMO to connect to SSAS 2005 and programmatically create objects. currently I am specifying only the ServerName in the connection string. Please see the code below: <code> Server SSASServer = new Microsoft.AnalysisServices. Server() ; SSASServer.Connect ( "DataSource=" + ServerName); </code> The above code works fine and I am able to connect. Now I want to provide the instance name of the server and also the server name. because tomorrow we will have multiple instances of Analysis server running on the same server. I read somewhere that we need to specify ServerName\InstanceName. S ...Show All

• Smart Device Development Derived ComboBox Designer/Component Error

  I am using VS 2005 Beta 2 for a PocketPC 2003 VB project, developing with a physical device. I am trying to derive my own ComboBox control, and then drag it onto a form. My code for the derived ComboBox is simple so far, the class just inherits from ComboBox and provides a default constructor which calls MyBase.New(). My problem is in using the designer. I can see my new component in the toolbox, however when I drag it onto the form I get the following error: "Failed to create component 'ListCombo'. The error message follows:   'System.InvalidCastException: Unable to cast object of type 'Microsoft.CompactFramework.Design.UnsafeControl' ...Show All

• SQL Server Unit Testing

  Well was wondering this weekend. How do you do unit testing with SSIS Is anyone trying it What are you doing and do you have any suggestions I've been reading about this but haven't done anything yet. Here are a couple of things I found: There is a section of a paper on MSDN about this, in the VS Team Edition context. http://msdn2.microsoft.com/en-us/library/bb381703(VS.80).aspx#dtbunttsttedp_topic7 One might be able to poke around there and steal some ideas for use outside that context. For instance, in the paper they talk about the data generation tool built into VSTE but there exist ...Show All

• Visual Studio Team System Load Testing - Counters

  I'm doing load testing with web tests.  The web tests that the load test uses require going through a couple different pages to get to the "important/interesting" page.  Every time I re-run the load test, I have to drill into the counters and find the "avg. page time" for the specific page I'm interested in.  Two questions: 1. Is there a way to "save" the counters I'm interested in so that they redisplay automatically each time I rerun the test 2. The stats being collected appear to have many holes where no data was collected.  For example, the avg page time was collected at 15, 20, 25 and 40 seconds, but not at 30 or ...Show All

• Visual Studio Tools for Office Server-side VSTO scalability and licensing

  I want to use VSTO for creating Word and Excel documents in an ASP.NET application. Will this scale, or it will create a Word/Excel instance in the background as the old Excel/Word COM Automation model How is the licensing Do I need one Office 2003 license in the server Thanks If you are needing to create new Word and Excel document on the server then I don't think that the new ServerDocument functionality within VSTO 2005 is going to help. The ServerDocument class allows you to read and write cached data to an already existing VSTO 2005 Excel or Word document without needing to automate Microsoft Excel ...Show All

• SQL Server Grouping a query in 30 seconds

  Hi, How can I make a query and group the registries in a interval of 30 seconds...like for each line I have a datetime field that have all the day, and I need it to return just like TIME Contador_type1 Contador_type2 Total 01-01-2006 00:00:30.000 2 5 7 01-01-2006 00:01:00.000 3 7 10 It's just an example...but that's the result that I need and my table is data_hora -- datetime field tipo - 1 or 2 -- count nrtelefone - that's is the number dialed. Thanks Hum...ok..I'll check again...but do you ...Show All

• Visual FoxPro Container 'when' method?

  Hi; I don't see a when event for a container. I am using 'gotfocus' but if there is a command button in the container, and I want to prevent the user to click it (in some cases), gotfocus is too late bacause the button's click method already fires. Any ideas how would I conditionally prevent a user access to everything contained in a container Thanks, Aleniko Dave; If I use the .enabled property, How would I tell the user that he needs to click "Clear" prior to being able to select something from the container Using the MouseEnter event would do it everytime he hovers over ...Show All

• Windows Forms How should I resize the datagrid

  In the design mode I had created the datagrid which can accomodate 30 rows During runtime this grid has 2 to 1000 rows is there any way when my grid has less than 10 rows I want to minimize the height of the grid in run time Hello! I want to know is that how can i get DataGrid header height. I have been looking for ...Show All

• Smart Device Development phone program in PPC

  Hi all expert, If i understand exactly, the phone program (which is included in pocket pc) is written from APIs. I want to rewrite a program phone like that, so i look in msdn, i found some APIs phone functions:  + PhoneCloseCallLog          ---  + PhoneGetCallLogEntry         |__ i can use them to build "call history"  + PhoneOpenCallLog              |   + PhoneSeekCallLog          ---  + PhoneM ...Show All

• SQL Server Performance with multiple packages in the IDE

  I'm having serious problems with the IDE for SSIS for projects that contain more than 5 packages. Especially if these packages call each other with a run package task thats configured with a file connection. Especially annoying are the 20+ "Document contains one or more extremely long lines of text.." messages that pop up during loading / validating. For my project with around 30 packages it takes me around 10 minutes to click through all these pop ups in addition to the long loading time. Anyone got any tips on this specifically or how to improve performance in the IDE in general As it is now, the product is a REAL pain to work ...Show All

• Windows Forms ClickOnce Errors with C# Express Final

  Hi gang, My ClickOnce-deployed application, which used to work fine back in the beta-2 days, is now giving everyone who tries to install it a lot of headaches. When I deployed this version (made using the final release of Visual C# Express) I deliberately put it in a different folder on my web server, so there could be no "accidental" upgrades from beta users. My users have meticulously uninstalled the beta version of my program, as well as the framework. Some have even run the pre-RTM removal tool from MS. What errors am I seeing Well: - A machine at work (which never had beta 2 on it) that I tried it on today simply appeared to stop i ...Show All

• .NET Development retrieve data from detailview

  I am trying to accomplish something that I imagine is very simple, but I cannot find any specific information on it. I have a DetailView control bound to an SQLDataSource. I want to retrieve the data from a specific field in the current record. I have been successful in retrieving the field names, but the data is eluding me. Thanks I have found one way to get the data: DetailView.Rows(RowInDetailView).Cells(CellInRow).Text Anyone know of a way to access the dataset directly ...Show All

• Visual Basic Making a picturebox have a transparent background

  I have a picture of a panda with a pink background (panda_down.bmp) and I was wondering: how do I get that pink background to be transparent Draw the image yourself in a paint handler, and use the imageattributes class to make 255/0/255 ( magenta ) transparent. ...Show All

• Visual FoxPro Select SQL Problem

  I am trying to select records from a database to determine qualifying order over 3 rounds of competition.  I *thought* I had it working but the results are not always correct. I need to find the lowest number in the field IQUARTER from a list of runs from many different entries listed by the field RACESESSIONS, but I need only the lowest for each contestant.  If there is a tie then the highest Miles Per Hour from the field I1320MPH breaks the tie, if there is an additional tie then the first one is placed above the other, this is determined by the TIMESTAMP field. The structure of the database that matters is this: tim ...Show All

• .NET Development How can I parse high precision decimals into an SqlDecimal object

  I have not found a way to create a high precision SQLDecimal value using SQLDecimal.Parse. If the string has more than 28 digits then there is a runtime exception: SqlDecimal sqldecTest = SqlDecimal .Parse( "1234567890123456789112345678921.12345678" ); System.FormatException was unhandled Message="The input wasn't in a correct format." Source="System.Data" StackTrace: at System.Data.SqlTypes.SqlDecimal.Parse(String s) I have been able to use high precision is DataTable.Select statements with success. But, other than reading the data from SQL Server, how can I create a high precision SqlDecima ...Show All