ymhtp's Q&A profile

• SQL Server Need help designing dimension

  Any ideas appreciated on this: We are pulling customer data from 8 homogenous sources like so: customer attributes, sourcesystem This data is going uncleaned into a base customer dimension Using fuzzy grouping we group and extreact similiar customers into another dimension: conformed customer dimension, and update the base customer dimension with the conformed customer dimension primary key in a parent_customer field. We add several ...Show All

• SQL Server Copy Database or Database Restore

  Hi, I am restoring one of my database from test box to production box. I don't have all the logins defined(users for copied database) in production box, What happen if user tries to access the database. I guess they will not be able as user is defined but there is no matching logins. Will Copy Database wizard creates all logins as Restore Database does not Thanks No. When you copy the database as well as when you restore the datab ...Show All

• Visual Studio Add web control to web form designer at design time

  Someone please help me !! I am trying to add a standard web control (e.g. label, textbox, datagrid) to the currently active web form surface in VS2002/2003. If I add it using the DesignerHost.CreateComponent method it seems to add to the controls collection OK, and usually the code-behind shows the declarations. But the HTML design / source tabs never display the added item. How can I get this working Someone mentioned simulating drop after pla ...Show All

• SQL Server Issues for "embedded" SSIS solutions

  My warehouse app employs a distributed architecture. Extractions from disparate (wildly so) systems, and transformations and loads into a standardized schema are performed at various locations close to the source systems (both physically and "logically" speaking). There are security and other reasons for this. However this causes some related design and implementation challenges for the ETL processing. For one, the ETL processes mus ...Show All

• Microsoft ISV Community Center Forums How do you test a user's input for alphabets?

  Hello programming gurus! Is there anyway to test if a user's input contains only alphabets Thank you! Just thought I'd share that I ended up using OR instead of AND. Private Sub TextBox1_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger) If KeyAscii < 65 OR KeyAscii > 90 Then 'invalid input, set to zero (ignore) KeyAscii = 0 End If End Sub ...Show All

• Visual C# How do you do to get only 6 from 2006

  I need the last number of the year to use it to for something else. How do I do it If he really does want the "last number of the year" (I assume that means "last digit of the year"), it would have to be: int lastDigit = year % 10; But if the year is in string form, it would have to be: string lastDigit = year.Substring(year.Length-1, 1); Or if you KNOW it's a 4-character ...Show All

• Visual C# Nullable Value and Generic

  I want to mark a generic class to support nullable value.  The following is my class public class DataField<T> where T:System.Nullable<T> {     public T Value; }   But it can't.  Why Please help me.... 1. string  is not actually valid. Nullable<T> has a struct constraint so only value types can be used with Nullable<T>. As far as I'm aware there is no way to use constrain ...Show All

• Visual Studio Express Editions Error adding web reference

  Trying to add a web reference to a program yields: ERROR: Some of the files required for web references are not installed. I've tried re-installing, but no dice. Help Apparently the same unregistered files that prevented me from using windows update were to blame. Fixed through the windows update instructions and serendipity. ...Show All

• Smart Device Development GetWirelessDevices/ossvcs api

  Hello, I am in dire need for Wireless API documentation for the calls contained in the ossvcs.dll I believe they are contained in a header file called "Wrlspwr.h". I have the Windows CE 5.0 Platform builder, but it does not have documentation for this. It is my understanding that it was released under AKU2, but I am unsure on how to obtain this update for the platform builder. Thanks very much for the assistance. ...Show All

• Visual C++ dllexport and function templates specializations

  Let's say I have the following template function:   Template <typename T> void Fun(T t); I'd like to be able to implement some specializations of Fun in a first DLL (DLL_1), some other specializations in a second (DLL_2), and still some other in a third (DLL_3), but DLL_2 and DLL_3 may make use of specializations implemented in DLL_1. So in DLL_2, Fun<T> may be both imported and exported, depending on T. I somehow managed ...Show All

• Visual C# End

  Hello, What is in C# the statment for end, like the end statment in VB DIII AFAIK, you mean this: sub mysub blah blah end sub That syntax does not exist in c#, instead scope is defined by curly braces void mysub { blah blah } ...Show All

• Smart Device Development Web Services and static classes - need help :(

  Hi folks, I'm trying to contact a web service from a PocketPC 2003 application. Right now I'm just using the PocketPC 2003 Emulator, and my web service's Url property is set to a real URL on my LAN - not the "localhost:1130" you get by default. If I place this code in the "Load" event of my main form, everything works fine: using (SitesProxy.SitesService ssvc = new SitesProxy.SitesService()) {     DataSet sites = ...Show All

• Visual C# How to trust an intranet-server?

  Hello, how can I mark a Server as "trusted location" Problem: Was studying C# during my holidays on my notebook. Wanted to transport the projects to our code-fileserver in the company. But now some parts of the application won't run. Message: "That assembly does not allow partially trusted callers." If I copy the project to the local harddisk, it runs without problems. But I need it running from our development fileserver. H ...Show All

• SQL Server Unable to cast COM object of type 'System.__ComObject' to class type 'System.Data.SqlClient.SqlConn

  Dear all, I am stuck with a SSIS package and I can’t work out. Let me know what steps are the correct in order to solve this. At first I have just a Flat File Source and then Script Component, nothing else. Error: [Script Component [516]] Error: System.InvalidCastException: Unable to cast COM object of type 'System.__ComObject' to class type 'System.Data.SqlClient.SqlConnection'. Instances of types t ...Show All

• Visual C# Click button from javascript in asp 2.0 content page

  Hi everybody. I have this code: < input id ="Ready" type ="button" value ="Ready " onserverclick ="AuthenticationReady_ServerClick" runat ="server" /> < OBJECT id ="ActiveXLogIn" height ="220" width ="300" classid ="AuthX.dll#AuthX.XLogIn" > </ OBJECT > < script language ="javascript" for =& ...Show All