whosthatguy's Q&A profile
SQL Server Error: The value was too large to fit in the output column "colName" (60).
Hi All, I'm trying to transfer data from DB2 Database to SQL Server 2005. Well, i used the OLE DB Source, the Data Conversion Component and the OLE DB Destination component. I have five Data flows with this configuration above. But I am receiving an error message from one of them. Please check below the error message: "[Source Table TARTRATE [1]] Error: The value was too large to fit in the output column "ADJ_RATE_PCT" (60). " "[Source Table TARTRATE [1]] Error: The "component "Source Table TARTRATE" (1)" failed because error code 0xC02090F8 occurred, and the error row dispositio ...Show All
Visual Studio Express Editions Dataset Question
Hi, I created a form and setup a Split Container - the left pane being a Tree View (with some top level nodes being topics: Memory, Operating System, Hard Drives, etc). The right pane contains a listbox. Is it possible to use a dataset (with no DB connection) to hold all my information in memory Then I'd like to be able to query the dataset to fill the listbox with the info I need when a user click on a node in the left pane. I've tried it, but I'm having some problems understanding how to do the dataset. If I create the dataset in design mode, I can create a table and add columns. But I seem to have problems accessing it from my c ...Show All
SQL Server Migrating db's from 2000 to 2005 results in truncated columns???
Hi all, Today I stumbled across something very strange. A couple weeks ago we migrated 2 servers from sql2000 to sql2005, and changed the default colation at the same time. The way I did it was I backed up all the user databases to *.bak files, uninstalled sql2000, installed sql2005 using the new default colation, and restored the databases. Today we discovered any columns that used to be char(xxx) were truncated to char(255), and the leftover went into a new column (i.e. a char(300) column became 2 columns, column1 char(255) and column2 char(45)). Does this remotely make sense to anyone I tested this out creating a ...Show All
Visual Studio 2008 (Pre-release) NetTcpBinding, Windows security
Let's assume you have service application runs on a computer which is part of a domain and a client application runs on a computer which is not part of any domain and you want to use that service (Simple example can be found on MSDN, WinFx : Net TCP Sample ms-help://MS.VSCC.v80/MS.MSDN.v80/MS.WinFX4VS.1033/WCF_samples/html/e8475fe6-0ecd-407a-8e7e-45860561bb74.htm) Obviously it would not work, but the problem is even if you add client credentials to the client application, still it does not work! Why static void Main() { // Create a proxy with given client endpoint configuration using (CalculatorProxy proxy = new CalculatorProxy( ...Show All
Windows Forms Error when attempting to start terrarium for first time
I'd gone through quite a few headaches getting this far. I uninstalled 3 versions of the .NET framework that were installed on my system. I installed the latest (from the MSDN website) framework and then installed the Terrarium client to play. I'm running under Windows XP Pro on a Pentium III, 996 Mhz machine w/512M memory. (It's a Dell&n ...Show All
Visual C# How do I "completely minimize"...
a window to appear as an icon in the right corner of the taskbar, just like for example Outlook or MSN messenger Also, how do I make a window out of focus "twinkle"(orange) on a certain event, like messenger To hide your application and put it in the systemtray you just put a NotifyIcon component on your form, set the Icon property to the Icon you want and look at this self-explaning code: private FormWindowState _lastNonMinimizedState; private void Form1_Resize( object sender, System.EventArgs e) { if (WindowState == FormWindowState.Minimized) { ShowInTaskbar = false ; notifyIcon1.V ...Show All
Visual C# AppSettingsReader and GetValue Problem
The following won't build and is driving me nuts! AppSettingsReader myConfig = new AppSettingsReader (); MyConnectionString = myConfig.GetValue( String MyConnectionString, Type String); Something is out-of-whack with my parameters to GetValue. I know this is pilot error. Any suggestion would be appreciated. DB Did you initialize MyConnectionString somewhere If so, try the following lines: string MyConnectionString = "" ; AppSettingsReader myConfig = new AppSettingsReader (); MyConnectionString = ( string )myConfig.GetValue(MyConnectionString, typeof ( string )); good luck -X ...Show All
Visual C++ Deploying Visual C++ 2005 Applications
Are there any resources or documentation available that explains how to deploy a simple Visual C++ 2005 application http://msdn2.microsoft.com/en-us/library/zebw5zk9(en-us,VS.80).aspx http://msdn2.microsoft.com/en-us/library/ms235265.aspx http://msdn2.microsoft.com/en-us/library/ms235285.aspx http://msdn2.microsoft.com/en-us/library/ms235317.aspx http://msdn2.microsoft.com/en-us/library/ms235291.aspx ...Show All
Visual Studio How do I gain access to class that generates TypedDatasets for Pocket PC...???
I know that the typed datasets generated for desktop difer from the ones generated for pocket PC and are also imcompatible. I would like to know if there is a public class like System.Data.Design.TypedDatasetGenerator wich generates typed datasets for pocket pc apps and where coud i find it Thanks The people who answer questions on this forum are experts about programming Visual Studio, but not Database programming. You will get better and more useful information on one of the Data forums then from one of us. Craig ...Show All
.NET Development Can I access Environment Variables with Jscript? REMOTE_ADDR = IP Address
I am specifically looking for IP address of the user. note: this is for a corporate intranet(no issues with proxy etc...). I want to have certain options on a screen disabled unless it is coming from a small list of UP's. Thanks. Daryl ...Show All
Windows Forms Finding dynamically created controls in Windows Form
I have a template design of controls (textboxes, combo boxes etc) placed in a panel. Based on the data returned from datasource, this set of controls is placed dynamically on the screen, and the names are autogenerated. I need to do two things: 1> Add a eventhandler to one of the textbox controls dynamically. 2> Based on the selected value of the tex ...Show All
.NET Development Why am I getting WSE2008: KerberosToken is expected but not present in the security header of the incoming message.
I'm working with a WSE3 client and WSE3 server. I'm getting the above error when my client tries to call a Web Service method on the server. Debugging the problem, I tried using the QuickStart WSSecurityKerberos Policy sample. When I use the QuickStart sample everything works just fine (both client and server applications are running on the same Windows 2003 R2 Server machine -- a 64-bit machine w/ 4 Intel Xeon 2.8GHz processors, w/ 4GB of RAM). However, when I take the identical wse3policy.config settings from client and server (each) and put them into a 2nd application on that same machine (also with client app and serve ...Show All
Windows Forms I need some help with The class Matrix()
Maybe it is a simple problem but I see no solution. Default matrix: [ 1 0 0 ] / [ 0 1 0 ] / [ 0 0 1 ] When I use First and only "Graphics grfx" as grfx.ScaleTransform(2, 2); The new Matrix is then: [ 2 0 0 ] / [ 0 2 0 ] / [ 0 0 1 ] When I user  ...Show All
Audio and Video Development Is the new Media Foundation a replacement of Direct Show?
They seem to perform the same task too me. Is Media Foundation supposed to replace Direct Show Hi John, You're correct that DirectShow and Media Foundation are similar; both of them are platforms for running multimedia presentations. As for whether Media Foundation is a replacement for DirectShow... As of Media Foundation v1 (i.e. the flagship version of Media Foundation that will ship with Windows Vista), if you're doing something like multimedia playback, you'll notice that working with the Media Foundation requires you to work at a slightly lower level than working with DirectShow would have. An ...Show All
Visual Basic Need to call external DLL that takes structured parameter
Hi, My application needs to call an external unmanaged DLL supplied by a third party. That DLL is written in C I suspect, it takes a struct parameter that holds some 30 fields, most of them of type char[x] where x varies for each field. What I did was a wrapper class, that has a declare statement like this Private Declare Ansi Sub ExternalSub Lib "ExternalDll.dll" (ByRef struct As strParam) The struct is defined like this <StructLayout(LayoutKind.Sequential, pack:=1)> Private Structure striParam <MarshalAs(UnmanagedType.ByValTStr, SizeConst:=10)> Public id As String <MarshalAs(UnmanagedType.ByValT ...Show All
