Brian Bergh's Q&A profile

• SQL Server problem reading tab delimited flat file source with missing tabs

  I have a tab delimited flat file with say 60 columns. All columns can have null values. The file contains a blank tab for nulls. Now, if a row has null value for last 10 columns, ideally, there should be 10 blank tabs padded to the end of that row. But, this is not the case with this file. There is line break after 50 columns of that row, in the above example. Extrapolating this behavior, most of the rows have null values for last 'x' columns where 'x' is variable for each row. When I try to customize a flat file connection for this file, SSIS is not padding up the missing tabs. In the example above, it should insert ...Show All

• Visual Studio Team System Build and Publish Problem

  I am bit new to TFS and currently leading a project to be migrated to TFS. We have 8 Projects in a single solution. 1. Interface (1st Win Forms Project) 2. Adapter (Dll for project 1) 3. Interface (2nd Win Forms Project) 4. Adapter (Dll for project 2) 5. Web Services (Used for both Win Form Projects) 6. Data Access (Used for both Win Form Projects) 7. Schemas (Used for both Win Form Projects) 8. Database Project (Used for both Win Form Projects) Normally we give our tested code to CM (Configuration Management) group and he breaks these 8 projects in 4 different solutions. 1. Solution 1 (Interface and Adapter ...Show All

• SQL Server SQL Server 2005 Trigger fires per statement or per Record

  Hi In SQL Server 2005, does TRIGGER for DML fire per statement or per Record If both, can we define the way it should fires. thanks / ramanuj Once per DML statement. You need to build triggers that expect >1 row in the INSERTED and/or DELETED tables. Sometimes it takes some doing, but once complete it is really a very efficient way to write triggers, since operations happen once. It can takes some wrapping your head around though :) ...Show All

• .NET Development which security method to use?

  The web service could potentially be consumed by different platforms so what method of security should be used and please provide some examples or links to start from. Thanks. Hello, The most interoperable form of security for ASP.NET Web Services will be basic authentication over https. For WSE, you can use the Username over Transport or Mutual Certificate 1.0 security schemes, but of which use WS-Security 1.0. You may need to disable WS-Addressing support in WSE if you want to interoperate with platforms that do not support WS-Addressing. Again, take a look at this MSDN site on interoperability: ...Show All

• Visual Basic Java custom settings registry value

  I have been digging through the IE documentation all day, but can't seem to find a clear answer on which registry value changes the enable "Run unsigned Content" and enable "Run signed Content." You can get there by going: Internet options | Security | Trusted Sites | Custom | Java Custom Settings | enable run unsigned content | enable signed content Any help would be much appreciated! Hi - This is a VB.NET forum and I don't think we have the right folks to answer this question. You might try an IE or ASP.NEt group. Best, Paul ...Show All

• Visual Studio 2008 (Pre-release) Client user name in ActiveDirectory environment

  Hello, I am using NetTcpBinding to connect a client to a server. Both computers are registered in the same Active Directory domain. On the server side I would like to know the name of the logged in windows client user for the current service request. How can I accomplish this Regards, Christoph   If you're using WS-SPNego then you can use this on the server to get the client ID: OperationContext .Current.ServiceSecurityContext.PrimaryIdentity.Name Alternatively, you can send the username inside the envelope as a header. Thanks, Scott ...Show All

• Windows Forms How to change a data row color based on a field value in run time?

  Hi all, I have no idea how to do this, can you give me some idea Let's say one of the field is status of the data, if its value is "OK", then the row is displayed GREEN color in background of the whole row, otherwise it is RED color in background.   Thanks for anyone help. Is there a solution for this in the datagrid .net 2003   tnx Remco ...Show All

• Visual Studio 2008 (Pre-release) Bind to property outside DataContext

  I'm building a custom ListView. In one of the cell templates I want a ComboBox. Now, the parent control of the ListView has an instance of a class with two Lists (Transactions and Categories) as it's datacontext. The ListView is then bound to the Transactions list. However, I want this combobox to get its items from the other list. Is there any way to do this If you are building a custom list view then I would suggest adding a property to the list view that holds the collection you want to use, then bind the enclosing element's property to that property, and use template binding to bind that to the template ...Show All

• Windows Forms Problems binding a combobox!

    Hi there,        i read so much about the problem i have now that i cannot understand what's wrong anymore. My problem is that i want to bind a ComboBox with a datatable or datasource (i tried both) and the combobox only shows me ONE item AS a selected value.  my code is this:      ComboBox1.DataSource =  ...Show All

• Visual Studio VS Common IDE Package failed to load

  I have been using Visual C++.net standard version 2003 on a Windows XP Home. It has worked quite well, so I decided to upgrade to Visual Studio 2005 Standard to get additional features. I uninstalled C++.net and installed VS 2005 upgrade. Now I get the "Visual Studio Common IDE Package failed to load" error (5 times) on startup. I have looked through the posts in this forum, and have tried just about everything I could find to solve this problem. Nothing seems to work. Any help would be greatly appreciated. I have not tried uninstalling/reinstalling yet. Max Is that the complete messag ...Show All

• SQL Server Failure installing SQL Server 2005 SP 1

  Windows XP Pro SQL Server 2005 Express SQL Server 2005 Standard I installed the service pack for SQL Server Express first. Then I tried to install the service pack for SQL Server. I got the error message, "A recently applied update, KB913090, failed to install.", while it was upgrading the Setup Support Files. Jonathan Allen Log follows... 04/22/2006 10:52:34.781 ================================================================================ 04/22/2006 10:52:34.875 Hotfix package launched 04/22/2006 10:53:47.546 Attempting to install instance: SQL Server Native Client 04/22/2006 10:53:47.578 Attempting to install t ...Show All

• Visual C++ GetThemeRect fails

  I am calling GetThemeRect to work out the size of the part my code wants to draw. I pass in a valid theme handle, part and state ID, and 5002 for the prop ID ( which is TMT_DEFAULTPANESIZE, I need this to work by delay loading functions from the dll, so I can use VC6 with no SDK updates ). I get back a failed HRESULT, with the value 'Element not found'. I've tried a variety of values, and always get the same result back have the same problem have code.. RECT rct = {}; HRESULT hr = CRSXpStylesManager::GetThemeRect (hTheme, BP_CHECKBOX, state, TMT_DEFAULTPANESIZE, &rct); hTheme is valid state is 1(CBS_UNCHECKEDNORMAL) and.. i re ...Show All

• Windows Forms How to make a form close after 5 seconds?

  How to make a form close after 5 seconds use a timer control, set the first tick at 5 seconds, hook the tick event... and close the form within it. but if you don't mind freezing the UI .. then System.Threading.Thread.Sleep(5000); will suffice ...Show All

• Visual Basic XP and VB-DOS port access???

  I used to run VB-DOS in a dos window inside Win98, no problem, but now under XP it looks fine but, alas, the INP and PORT commands, used to read and write to addresses controlling AD and DA cards, are having no effect; they're ignored. Is this inevitable Or is there some driver or some trick that should be used Please Advice, Sverk Sverk If your using VB for DOS then this is a very old product and no longer supported. These forums are for VB.NET applications. So I'm not sure your going to get much help in these forums and cant really suggest any place for VB for DOS as it such an old product. ...Show All

• Software Development for Windows Vista Getting ready to install Vista

  Hello, On a new hardrive so can you tell me the best set up please i.e. do I need two partitions etc and if so what sizes. Sorry if I posted this in the wrong place but I am new to the beta program and these forums. Thanks for your time. Hi, You do not need 2 partitions if you are not going to do a dual boot (XP and Vista for example). What size For the PDC build, some said that you need at least 8.5GB of free space before the installer continuese setup. However some said that after installation of x64 of 5219, Vista has used up 15GB. So on the sizes, i would say, allocate 20GB (since you will also need to ...Show All