Matt Garnham's Q&A profile

• SQL Server Date out of range?!

  Greetings! I have a data source that gets generated based on a variable with the following SQL : "select * from result where deletion_ind = 1 and when_deleted >= '" + (dt_str, 50, 1252) @[User::Last_Run_Date] + "'" But when I run my package I get an error message saying: The conversion of CHAR to DATETIME resulted in a DATETIME value out of range The Last_Run_Date variable is set to '2006-06-25 14:35:05.450' When I run the code in a QA session it works, but in the package it complains! What am I doing wrong Thanks for your help in advance. You've already told me further up this thread that the error is getting thrown by SQL Server when you issue that query from SSIS. You have 2 ...Show All

• Gadgets can't "build" a valid gadget file!!! UGH!

  I have created a zip file. I have all the proper files in it. I rename it to x.gadget and the icon changed to a sidebar gadget icon. I double-click it and it prompts to install the gadget. I hit "Install" It pops up an error message saying this is not a valid gadget file. In the directory it puts a folder with my gadgets name with ".~0019" appended to the end of the foldername. The number increments with each attempt. MyfolderName.gadget.~0019 What is going on I downloaded AlphaZip and compressed the files into a cabinet file instead of a zip, then I renamed it to a gadget file and the install works fine. Something is wrong with using "Compressed Zipped Folder ...Show All

• Windows Forms How to attach a context menu during runtime

  Hello everybody. Right now I am trying to create a small hotel program(similar to Room Master) What it is supposed to do is to create as many rooms(represented by buttons) as the user wishes. Also I have created a context menu with all the options on it what i want to do is to attach the context menu to every dynamically created button i've tried doing the following myButton.ContextMenu = this.contextMenu1; but it doesnt work then I've created the context menu inside the code, i mean like ContextMenu cntMenu = new ContextMenu(); cntMenu.MenuItems.Add("touch up"); and so and so I feel it is much easier if I can just attach already visually created context menu any ideas how to do this maybe if I create a reference(I dont know how ...Show All

• Smart Device Development LNK2001, LNK2019 in embedded Visual C++: Please help!!

  Hello- dear experts! I am trying to build a static library using embedded Visual C++ 4.0, and then link an application to it targeting the Standard SDK 420 for WinCE 4.2. I am getting many link-time errors though (pls scroll down) for symbols like _strdup, _strerror, etc and have not been able to resolve this so far. This library and application are compiling fine on XP using VS 2005 Express C++- that is my starting point. Kindly advise! Thanks! [To keep the discussion focussed, I renamed all obj files to object_file.obj and functions to func_namein the error msgs below] -------------------------------------------------------- In eVC++, these are my settings: 1. Library: a. Preprocessor definitions: DEBUG,_i386_, ...Show All

• Smart Device Development MIME Parser

  Hi, Follow to 'PR_CE_MIME_TEXT' returned value, Is there any kind of a built-in MIME Parser under Win32 API Have a nice day, Asher You could try mimepp/mime++ lib. Though it isn't entirely free. We are using that and it works pretty good on PPC2003/WM5 platforms. - Stefan ...Show All

• Visual J# IF statmenet problems

  Hi I am having some conditional statement problems and need some help. I am attempting to get the check of the second if statement but it does no go through. The first if statement checks but does not seem to go to the second if. I based this on console J# and will thank all that help. package Lab4; import System.*; import java.io.*; import System.IO.*; import System.Data.*; /** * Summary description for Class1. */ public class Class1 { public Class1() { // // TODO: Add Constructor Logic here // } /** @attribute System.STAThread() */ public static void main(String[] args) { //test code, replace with variable to test //Console.WriteLine("\n" + name); int counter = 1; Console.WriteLine("\tW ...Show All

• .NET Development .Net Framework V2 and Visual Studio 2003 Ent Arch

  Thanks for your time. Can I use v2.0.50727 of the .Net framework with Visual Studio 2003 Ent Arch Or am I limited to 1.1 I'd like to take advantage of "MY" objects. im afraid you are limited to .NET 1.1 for VS2003. Download the free Visual Studio Express editions for use with .NET 2.0. Or purchase VS2005. Other than that you are stuck im afraid. Each VS is tied with its version of .NET Framework, with 2005 being the exception since it can also develop .NET 3.0 apps with the orcas add-in ...Show All

• Visual Studio Express Editions How to add new Page

  Hi all, please help me with add more 1 page on final of my report... i use, System.Drawing..... thanks! hi, by default there is no reporting tool for express edition, so i assume you wrote your own class , and no one can tell you how to do that without seeing your code hope this helps ...Show All

• Visual Basic Debuggung error

  When I try to test an application I get an error: Binging handle invalid msg. Help Please! Thanks!! It's a known issue. Check out the following blogs for more info: http://blogs.msdn.com/greggm/archive/2006/01/04/509243.aspx http://blogs.msdn.com/habibh/archive/2005/11/10/491572.aspx Best regards, Johan Stenberg ...Show All

• SQL Server Load data from .DAT file

  Hi All, I am using Bulk Insert task to laod data from .dat file to SQL table but getting an error below. [Bulk Insert Task] Error: An error occurred with the following error message: "Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.The bulk load failed. The column is too long in the data file for row 1, column 1. Verify that the field terminator and row terminator are specified correctly.". Any help will be appreciated. Thanks. I found the solution. I had a Format file which I fixed it ...Show All

• Visual Basic Custom CType operator not being called

  This code defines a custom CType operator that converts Integer to TestNumber. This works great when converting from Integer to TestNumber. But an InvalidCastException occurs when converting from Object of type Integer to TestNumber. The online help for CType function implies that this call should work. "If the conversion is undefined, an InvalidCastException occurs. This can happen, for example, if expression is of type Object and its run-time type has no conversion to typename ." But because of the custom CType operator, there *is* a conversion from the run-time type (Integer) to typename (TestNumber). This problem is causing big headaches in my app. It happens on both VS 2005 and VS 2005 SP1. This seems like a CType bug ...Show All

• Visual Studio Team System Team build CTP6 datadude project

  I'm trying to team build a solution with a ctp6 Datadude project but the build fails stating the next line in the buid.log file Target SqlBuildScriptName: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727 Microsoft.VisualStudio.TeamSystem.Data.Tasks.targets(26,5): error MSB4044: The "SqlBuildScriptNameTask" task was not given a value for the required parameter "TargetDatabase". Done building target "SqlBuildScriptName" in project "SenterNovem.Ras.Database.dbproj" -- FAILED. Can someone give me a hint where to look to solve the problem. It may be, Ruben. You might want to take a look at the following help topics that were new for October: Ho ...Show All

• Visual Studio Team System Project Portals stop working after restoring TFS from backups

  Synopsis of Problem: After restoring TFS from backups, the Project Portals cease working. When I try to load one I get the error message "The virtual server that is referenced here is not in the config database.". Full Story: In my evaluation of Team Foundation Server I decided to see how smoothly a backup and restore would go. The backup was easy enough. I backed up all the TFS databases (per this article ) and the reporting services encryption key (per this article ). With backups safely stored on a separate machine I wiped the server running TFS, reinstalled Server 2003, applied all available updates, and started the TFS install by following the instructions found in the installation guide for a single server configuration. ...Show All

• Windows Forms progressbar external application

  Hi, I'm trying to make a progress bar in vb.net for an external application. The external application moves all files in one directory to other directories. Do I have to use a timer that starts when the external application starts, and count every files left And then update the ToolStripProgressBar1.Value I'm very new to programming, I'm not sure how to code this. Thanks, Dennis One can go crazy trying to figure out how to step the progress bar. Unless there is a known quantity which lends itself to steping. Change the type of the progress bar to Marquee . While the program is running change the property Enable to be true or false...or or set the visiblity property to on or off to make it appear that work ...Show All

• SQL Server How to set precision of a decimal number

  there is a column which type is float in a table, i want to set the precision of its value, for example if its value is 10.333888, i want to get its value as 10.33, how to complete it in a select Sql thks You can change yourcolumn to numeric or decimal data type, for example, decimal(18,2) or numeric(18,2), which will return 10.33 in your case. You can look up the difference between numeric and float data type from Books Online which covers everything you need for SQL Server. HTH ...Show All