Gary Little's Q&A profile

• SQL Server Importing Decimal Data Types into SQL Server 2005

  I have a simple Integration Services project and the problem is that decimal fields are importing as real (I'm loosing the digits behind the decimal point). The project contains a data flow task importing a flat file (.csv) to an SQL Server destination. My .csv file has two decimal type fields. Example: Field 1: 12345.67 Field 2: .123456 My database table that I'm importing to has two fields. The only way that I can get this data to import is to define the fields as "float" in both the text file and database table. I want the database table fields to be defined as decimal or numeric, not float: Field 1: decimal(7,2) ...Show All

• Visual Studio Team System Team Foundation Server MSSCCI Provider Beta 2 Now Available (Feb 20, 20006)

  The Team Foundation Server MSSCCI Provider Beta 2 is now available here . IMPORTANT:   Beta 2 is not strongly signed, so you'll need to disable strong name validation as mentioned in the README.  You can find details at http://blogs.msdn.com/buckh/archive/2006/02/21/536260.aspx . New in this beta: Support for Visual Studio 2003 and Fox Pro in addition to the already supported VB6 and VC6. Integrated Checkin - you can now associate/resolve bugs and specify checkin notes with your checkin Improved performance - opening controlled solutions, get, checkout, checkin, and compare/diff are much faster M ...Show All

• Visual Studio Team System Upgrade problem : "TFS sql server exists and their schema doesn't match..."

  Hi upon trying to upgrade to RC I encountered a problem : "TFS sql server exists and their schema doesn't match the version expected by setup" how do I workaround it all the upgrade steps went fine until this one.... 10x, guy Hi, Im'getting exact same error while upgrading from beta3 refresh to RTM. How do i update the Databases. I don't see any steps invloving that in the upgrade User guide. Thanks, ...Show All

• Visual Studio Team System VSSConverter.exe missing from installation?

  I have installed TFS successfully on a test server and VS2005 on a client. I would now like to migrate VSS6.0 to TFS VC. I'm following the "Preparing to Migrate" walkthough and have found that, although VSSConverter.exe has been installed on the client machine, it has not been installed on the server, which is where the analysis and conversion must be run. I have Team Explorer on the server, but do not wish to install the entirety of VS2005 here. Am I missing an installation option that would put VSSConverter.exe on my TFS machine If so, why isn't it installed by default, as TFS VC was Any help appreciated... W ...Show All

• SQL Server dmx query probablity ?

  CREATE MINING MODEL mortgage (  [id] long key,  Edu_Status long DISCRETE,  Work_Status long DISCRETE,  age long CONTINUOUS,  asset_value long CONTINUOUS,  Net_income long CONTINUOUS,  paid_Status long DISCRETE PREDICT )USING MICROSOFT_DECISION_TREES i have  a mining model above and i am designing a web cross ablication to see probablity of the a costumers' paid status. can you write for me dmx command for selecting paid status that have same criteria(ex;age=30 net income=2000,Edu_status=college) and when i write dxm window(select * from [paid_Status] ) it only shows "4" one row one column why as you ...Show All

• Visual FoxPro what is the maximum field VFP9 can handle

  Good day to everybody... just a little problem with my update at VFP interface with my back-end database I dont have this problem updating my employees table in SQL2000 with 35 columns at my VFP interface, but recently I add another 3 columns at my table, that's where I encounter this problem. Inserting a new record or deleting there's no problem, but when i edit a particular record then saved the changes,the update is OK.. but after I close the form and open it again, that particular record I edited does not really saving the changes. why is there a limit in field column use by VFP Just asking.. or there's i miss... but I already m ...Show All

• Visual C# strange performace question, maybe a bug?

  The method DrawLine1 is much faster than DrawLine2 and DrawLine3, why the parameter white_line is always true. // draw horizontal line in binary image public static unsafe void DrawLine1(byte* baseline, int x1, int x2, bool white_black) { Trace.Assert(x1 <= x2, "the first point must less than end point"); int xhi1 = x1 >> 5; int xlo1 = x1 & 31; int xhi2 = x2 >> 5; int xlo2 = x2 & 31; if (white_back) { if (xhi1 == xhi2) *((uint*)baseline + xhi1) |= swap_hi_lo(0xffffffff << (32 - xlo2 + xlo1) >> xlo1); else ...Show All

• Visual C# Preventing decompilation!!

  Hi, Can someone tell me how can I prevent decompilation of assemblies created in .NET. Are there any freeware softwares that makes this happen. Please provide me the download link of these softwares, if there are any. Thanks, Frens You can use a obfuscator, here is a little list of obfuscator's for .NET: {smartassembly} Decompiler.NET Deploy.NET Salamander .NET Obfuscator Semantic Designs: C# Source Code Obfuscator Spices.Net Thinstall Demeanor for .NET XenoCode .NET Obfuscator and Optimizer ...Show All

• Visual C# How to change the font color...

  Greetings for all: My question is how I can change the font color of a ListViewGroup, for example set it RED. Thanks every body. Hope this might help ListViewGroup lvg = new ListViewGroup (); lvg.ListView.ForeColor = Color .Blue; ...Show All

• Visual C++ How do people get UML from Visual C++ Projects in VS 2005?

  Just what it says in the title; C# has the class designer, VS 2005 has done away with reverse engineering in Visio, and I don't have the funds to buy commercial products; is there another way Or do I just have to open Visio and draw lots... IxxI ...Show All

• .NET Development Interesting architectural problem

  I have an application that contains two web service projects.  One contains all of the "query" (read-only) functions and is publicly available to all.  The other contains all of the administration (update) functions and is locked down with encryption and Windows authentication.  To avoid the need for administrative users and applications to reference two separate web services, I added a project reference to the query service withinin the administration service project, and had all of the admin classes inherit and extend the query classes.  This works great in 1.x, but in 2.0 websites and web services no longer compile to ...Show All

• SQL Server SQL Server 2005 Express April CTP

  I have tried several different ways to get SQL Server 2005 Express installed with a VB 2005 Express package. It continues to tell me that it is unable to install due to incompatible components on my system. I've used the clean up tool, I've reinstalled the earlier beta version and uninstalled it again (with and without the clean up tool) and I've tried cleaning up the system manually. If anyone can give me some other ideas I would appreciate it. GARussell ...Show All

• SQL Server SQL Server 2005 CLR integration problems with unmanaged code

  Hi, With SQL Server 2005 I'm trying to define a CLR integration UDF that calls unmanaged C++ code contained in a .dll. I have the following two signed assemblies: 1) 'wrapper' - this assembly is basically a wrapper class writen in C++ managed extensions code that calls a legacy library written in unmanaged C++ 2) 'provider'- this assembly offers services some of which are contained in the 'wrapper' assembly. This class is written in C# and its assembly is marked as unsafe since it is calling unmanaged code The problem is that when I run the assembly creation statement: CREATE ASSEMBLY [Provider] FROM 'c:\Development\Provider.dll' WITH ...Show All

• Visual C++ Embedding an edit control into a tab control

  I want to embed four different edit controls into four different tabs. How do I do that Please include more details What technology are you using What have you tried so far yourself Thanks, Ayman Shoukry VC++ Team ...Show All

• Visual Studio Tools for Office COM ADDIN Not working in client mechins

  I have developed COM ADDIN in frame work 2.0 and outlook 2003, it is working fine in some Mechines, not in some mechines, The application not even lode the dll. Can any one help this, what can i do to solve this problem. Thanks in advance chand. Hi, I am guessing you're using VSTO for Outlook and the reason is probably you didn't set the CAS policy on deployment machines correctly. You should check the Outlook resource list and also the deployment project for VSTO Outlook solutions . ...Show All