Ryan Paddy's Q&A profile

• SQL Server Very confusing error about timeout and estimated-cost of query

  Hi, I created a cube from one fact table named Revenue. It's total records was about 16.8 million, consists of 12 partitions, distributed quite even (so about 1.4 million records per partition). The partition was based on month. Each partition is mapped to different file-group. The data file for each file-group was 340-360 MB (350 MB in average). The total size is about 4.2 GB. The cube involved 5 dimensional-tables. One of dimensional tables was time-dimension table. 3 out of 5 was for hierarchical region tables. The last one of dimensional tables was product- dimension table. Each of these dimensional tables are very small, less than 1 MB. The cube contains very few columns. It contains 6 columns from 3 (dimensional) region tables, 3 col ...Show All

• .NET Development DCOM EnterpriseServices

  COM+ Application Packaged (Exported) on server, got MSI file Install MSI file on Workstation: error "The typelib could not be loaded". What's wrong The MSI file was generated using the Component Services management console exporting a in-house developed .NET Enterprise Services Server object.  The typelib it is looking for is not specified in the error message.... ...Show All

• Visual Basic VB Error ImgeditLibCtl.ImgEdit

  Hello, I am receiving the following error on more than one form in my project: *Class ImgeditLibCtl.ImgEdit of control ImgEdit1 was not a loaded control class. How can I fix this error If I need to download something, please let me know what to download and where. Thank you. ...Show All

• .NET Development App.Config File and My.Settings conflict.

  I don't get it, I'm doing something wrong. I went to the properties window for my project and added some settings, which created an app.Config file for me and put those settings in it. Well, when I change the values directly in the app.Config file and run the project, it doesn't read anything from there, it only reads the values on the Settings tab of the project properties. I cannot seem to get the program to read the values (and their changes) from the app.Config file rather than the Settings tab on the Project Properties window. I was having problems with the appconfig myself.  It made me wonder why I didn't just create a vanilla xml file and use that.  Long story short, I accidentally grabbed the wrong file.& ...Show All

• SQL Server Which services are needed?

  Hi, i have a server with SQL Server 2000 installed on it. Also IIS is installed with Executive Viewer on HTTPS (a program ( www.temtec.com ) which creates webreports of MSAS Cubes). A list of services is started everytime i start the server. My question is very simple. Which services are needed, and which services are only taking memory but are of no use at all to have my above configuration work. This is my list: Alerter - Started Automatically Application Expreience Lookup Service - Automatically Application Management - Manually Automatic Updates - Automatically COM+ Event System - Automatically Computer Browser - Automatically Cryptographic Services - Automatically DCOM Server Process Launcher - Automatically DHCP Client - Aut ...Show All

• Windows Forms MouseDown not fired for ToolStripControlHost

  Hi, I am using ToolStripControlHost to contain a UserControl. The UserControl is made up of a toolstrip (with a label and a button), and a RichTextBox. The arrangement is working but has a few quirks. The main one is that the mousedown (or click) event for the button on the toolstrip does not occur until the second time I click within the UserControl. The MouseEnter and MouseLeave events do occur and can be intercepted. What am I missing Thanks private ContextMenuStrip emAbstractMenuStrip = new ContextMenuStrip (); private void contextMenuStrip2_Opening( object sender, CancelEventArgs e) { emAbstractMenuStrip.Items.Clear(); EmAbstract emAbstract = new EmAbstract (); emAbstract.OnCloseAbstract ...Show All

• SQL Server script component isn't finding a reference dll

  I have created this c# dll for one of my packages and I was planning on calling it from the script component, but for some reason when I try to call it I get the following error. Could not load file or assembly 'VRS.Utilities.Dates, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified. I've dropped the dll file in the WINDOWS\Microsoft.NET\Framework\v2.0.50727 folder and it shows up when I go to add the reference however when I try to implement it I get the error. Any idea's on how to fix this Thanks for the help Saitham8 Add the DLL to GAC. At run time the script task will check the DLL in GAC, at design time script task will che ...Show All

• Windows Forms Databinding problem when tabbing through form

  Are you kidding I hope this is just a case of me not doing something I am supposed to be doing. Here is the situation: I have a databound form. When I click on each individual field and either set the value (combobox, checkbox, etc) or type the text, and then save to the database, everything is fine. However if I tab to each field and never click the mouse (ie set the combos with the arrow keys) the updates are never flushed to the dataset and the update command tries to send an empty row to the database. I have both a call to "Validate" and "EndEdit" in my save button sub. What gives Obviously I don't want dataentry people to have to click in each field. They should be able to tab from one to the next. ...Show All

• Community Chat taskbar color

  alright i've been searching around for a while and still havent found much. does anyone know a way to change the color of the taskbar to some color that isn't XP set, like black iv read up on this and there were 2 solutions, 1,third party software;2,"hack". Well considering that there is 3rd party software, there should be a way to change it programmaticly. so does anyone know how or at least what programming language this can be done in d'ya mean the bar that has "start" at the bottom 'cause i've got styler running right now and it makes windows xp look awesome! just google styler and you'll find a download for it (it's shareware), and then just get some xp themes (must have .msstyle ...Show All

• Visual Studio 2008 (Pre-release) Terminology Question

  What's the official name for: (a) a query that binds to the Enumerable operators (b) a query that binds to the Queryable operators This is for writing a book. I'm looking for something simple (one or two words) that captures the difference in their architectures. Note that (a) includes LINQ to XML queries. Thanks Joe ...Show All

• SQL Server Is Conversion from SQL Server Express to Full SQL Server Required?

  If I develop my app in SQL Server 2005 Express, and then want to use a hosting service that only offers full SQL Server 2005, do I have to do some kind of conversion to my DB file, and if so, what might that be   (I notice that there are hosting services that provide SQL Server Express...I'd like to know how much work it would be to be able to use other services.) Any guidance on this would be appreciated. Thanks! it is an easy process to upgrade the database... you have two methods that you can use. the first is to use the detatch/attach method... with this you would just detatch the database on you server and then have the hosting company attach it for you. Or you could just use ...Show All

• Visual C++ CList and template

  Hi guys, I made a template that will works on a CList type, but it doesn't work. template <class T> class CIntFile { // ... void Write(T list); }; template <class T> void CIntFile<T>::Write(T list) { //// list.GetAt(0); list.Next(); //// } ///////////////////////////// in another file: CList<CIntMyClass> listMyClass; /// fill it listMyClass.Add(NewData); /// CIntFile<CIntMyClass> intFile; intFile.Write(listMyClass); -------------- Why Tnx yes, there are not cast. But I used the CIntAirport class in the example because it's just an example. I have not only the CIntAirport class in the CList but I can have many other one. So how can I use these ...Show All

• Windows Forms Check If sql Server Exits

  hi is there a way to check if sql server exist when creating and installer (i want to create an installer for a program and during setup i need the installer to check if sql server exits ) Hello I have this same question, but i am looking for if sql server express edition exist. In VS.NET 2005 Instaler I added serach registry key, but what i must to write to property, regkey or Value in serach for regisrty entry properties ...Show All

• SQL Server debugging SQL stored procedure

  Hi I have a simple windows application which uses two stored procedures at the backend to fetch the data and display it in the grid of UI I wanted to debug these stored procedures line by line like using run time storage dump for various variable and statements used in the procedures as we do it in Visual studio using functional keys etc. or Any way to do this using SQL server 2000 query analyzer The stored procedures contains nearly five hundred lines of code in sql. Early reply is much appreciated. Thanks! In query analyzer, show object browser. then select your stored proc, and right click. Select debug. For more, look at this article http://www.15seconds.com/Issue/050106.htm ...Show All

• Visual Studio Tools for Office Can I add an Outlook addin to a pre-existing form?

  Can I add an Outlook addin to a pre-existing form and, If so, How do I do it Or, how do I add a Outlook addin project to another project I have been struggling on this for days please help! Thank you in advance!!! What features are you thinking of With regard to Outlook, VSTO isn't anything more than a new add-in architecture plus the same programming features that are in Visual Studio 2005. You don't need VSTO to write Outlook automation code. ...Show All