creaturita's Q&A profile

• SQL Server SSIS package design - Ideas

  Greetings SSIS friends, I am in the process of designing a package for populating a Dimension table for my new data warehouse. I would like to discuss with you my proposed solution in the hope that some of you will be able to advise me on any mistakes that I have made so far. I have 3 source tables which are used to populate my Dimension table (I will restrict each source table to a few columns to keep this simple). The source tables are : Meetings (MeetID, NameID, Meeting_Start_Date, Meeting_End_Date, Meeting_Time_Stamp) Events (EventID, MeetID, Event_Start_Date, Event_End_Date, Event_Time_Stamp) Names (NameID, Long_Name, Short_Name, Names_Time_Stamp) My Dimension table structure is very bas ...Show All

• Visual Basic Windows Service Monitoring Problem On Vista

  I've built a small utility to monitor the status of SQL Server Express and start/stop it and it works nicely on Windows XP SP2 and fuctioning great but when I've tested it on windows vista it monitors the service ok but I can't start/stop the service any more unless I use the Run as administrator command to start my tool I've used the folowing code to test my rights on windows My .User.IsInRole(Microsoft.VisualBasic.ApplicationServices.BuiltInRole.Administrator) but it gives me false - note that I've logged as an administrator to windows - is there is any way programtically make the program have administrator rights on windows so I can use all functionality of my little tool Thank You Alot ...Show All

• Software Development for Windows Vista COM Elevation and dcomcnfg

  We have successfully implemented COM elevation for English Vista but are encountering problems on localized versions of the OS. We have been following the steps outlined here . The root cause seems to be that the registration at install time via dcomperm fails. Even trying to set the Access permissions manually through dcomcnfg on both German Vista and XP fails. It seems like “Interactive” is not a recognized name. How do you give the interactive user permissions to the COM object on non-English versions of Windows Thanks ...Show All

• SQL Server Excel 2007 and OLAP Server Formatting

  Hi, I can't make Excel 2007 to apply on percent number format. I use the CustomMemberOption on my calculated AS2000 members. It works great for number formats like FORMAT_STRING='0.00' but I can't get Excel 2007 to apply on FORMAT_STRING='percent'. It works great in ASManager browser. Any idea Thanks, Christer ...Show All

• Windows Live Developer Forums robot is offline for some users

  Hi, I've developed a robot for the contest ( secretarybot@hotmail.com ) and it appears offline for some users, though they can chat with it. I've contacted incesoft, they thought it was because of the 300 users limit but I have provisioned my bot so there should not have limits... Any idea There are any number of things that could be going on here and there are platform specific tweaks as well, but I'll take a stab at the most likely issue across platforms. Please note there are also the occasional network issues that even knock some of the Microsoft bots offline for brief periods. We're working on those issues, but here's my top thoughts for fixing your bots presence problems: Did you prov ...Show All

• SQL Server Trigger not executing

  I will try to keep this as simple as possible and make a long story short. The college I work for has bought a third party package to basically run the operations of the school. There is a component for registration, admissions, billing, etc. It also has a web component so students can access their school information from anywhere. The backend for all of this is SQL Server. To make things easy, the vendor has provided us with the steps to bulk load users, via DTS, into the system and create their accounts for the web portion. The way this works is as follows: I create a CSV file which I then load via DTS into their "Bulk Load" table. This table has an "on insert" trigger that fires off when the load happens on the &q ...Show All

• Windows Search Technologies WDS suddenly stopped working

  Hi there! I have had WDS on my computer for about three months now. I have the final 3.0 version and we have Windows XP Professional 2002 running our machines. WDS is absolutely wonderful, when it works. I really can't tell you what happened, but when I choose 'Search Now', nothing happens. I can see that the indexing runs from time to time, but that's about it. I would appreciate very slow and DETAILED help on this one. I really can't work without my WDS!! Anyone Help ! ...Show All

• .NET Development Synchronize AS400 with Access???

  Is it possible to have an interaction between an AS400 database and an Access database. The two databases have just about the same type of information however I want to create a more user friendly GUI in Access that can reference, create, and edit data in the AS400 system. Is this even possible and if it is where can I go to get a reasonably easy walkthrough to go about creating it Thanks for any comments/answers. ...Show All

• .NET Development Passing a value using a thread

  I'm trying to pass a variable with the Upload Procedure and I can't do it, it says method name expected!! how you are guys doing it thrUp = new Thread ( new ThreadStart (Upload(OpenFileDialog1.FileName))); thrUp.Start(); thank you Hi John, thanks for your reply but I do get this error msg Error 1 No overload for 'Upload' matches delegate 'System.Threading.ParameterizedThreadStart' frmMain.cs 135 43 MyApp So, how do you resolve this please ...Show All

• Windows Forms string input via forms

  How do I input strings using a form ...Show All

• Smart Device Development Pocket PC

  Hi Guys im new to pocket pc programming. i need help on developing a pocket pc application using sql ce and the database should reside on a pocket pc. regards ...Show All

• .NET Development (WinForm) check if service is running? if not start it

  How can I check if a service is running, if this isn't, then start it . I would like to start database service but not at windows start-up. thanks in advance for your help, Edward I would have a look at the service controller/management classes in .Net and have a look what they can do, another option is to jump into the system.management classes and use WMI Windows Management Interfaces) to change the status of the service, ie start it. ...Show All

• Windows Forms ComboBox with List<CustomClass> Datasource problem.

  I have a combobox which is bound to a List<CustomClass> (i.e. list of objects of my own custom class type) through its DataSource property. When the datasource is initially set, the items are filled out as expected (i.e. reflecting the items in the list), however my problem is that if i then add an item to the list after it has been bound to the combobox then the combobox items arent updated to reflect the change. How can i solve this I have tried to refresh, update, invalidate etc the combobox, but they all just deal with the UI/drawing side from what i can tell. Thanks in advance Paul e.g. List<CustomClass> exampleList = new List<CustomClass>(); exampleList.Add(new CustomClass(0)) ...Show All

• Visual C++ text editor

  Hi everyone, I`m working at a small project in VC++.NET 2005, for school, a simple text editor, and I couldn`t find how to do some things, I hope to find some help here. I don`t have much experience in visual programming. So, here are my questions: I have a main for with a rich text box, menu, toolbar, and I want to implement a function to find text, so I have another for which I open when i click on the find menu item, like this Code: Search^ find =gcnew Search; find->Visible=true; find->Activate(); my question is how can I acces from the find form the richTextBox from Form1 to call it`s find method - can you give me an example of how to use the print preview dialog and the print dialog. I understood tha ...Show All

• SQL Server SSIS Oracle --> SQL Server import Fails

  Im getting the following error when I try to export from Oracle 9i and import into SQL Server 2005 using Oracle and SQL OLE DB Provider's respectively. Cannot retrieve the column code page infor from the OLE DB Provider. If the component supports the "DefaultCodePage" property, the code page from that property value will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used. I know there is a way to change the property settings for the OLE DB Provider in the Data flow section of the development studio BUT ... 1) Is there a way to change this outside of the development stud ...Show All