scorpion007's Q&A profile

• SQL Server SSIS (SCD problem)

  I am trying to compare the records in Table A with Table B. Both have a primary key of keyId. What I want to do is compare the keyIds in Table A with Table B. If there is a match, I simply want to update Table B's columns with Table A's column values, BUT, I do not wish to compare anything other than primary keys. I just want to pass forward / update A's values to B where there is a pk match. Thanks in advance. You are better off using a lookup task than an SCD. Its faster too. Lookup the key id of table A in table B. If there is a hit, send the row to an OLEDB command that will update the rows in table B. Hope that helps. ...Show All

• Visual Studio 2008 (Pre-release) MarkupExtension to Connect WPF to CAB Serviecs

  We a re working on a project that integrates WPF and the CAB (Composite UI Application Block). One thing we would really like to do is connect CAB services to our views using markup. A prime example of why we'd like to do this is in data binding. Consider the following : xmlns:xt = " clr-namespace:FxBindSource.MarkupExtensions " xmlns: sv = " clr-namespace:FxBindSource .Services " … < ObjectDataProvider   x:Key = " UserCollectionDS "   d:IsDataSource = " True "   ObjectInstance = " {xt:Service sv :IUserProvider} "   MethodName = " GetUsers " /> The idea is simple: create ServiceExtension which inherits from MarkupExtension and have ServiceExtensi ...Show All

• SQL Server BULK INSERT "AccessDenied" on remote text file.

  OK, Ive read many posts on this problem but have seen no resolution. Here's the deal. When on the actual SQL box (There's 2 in the cluster) the bulk insert works fine. No errors and the event log on the machine that is hosting the text file shows that the account that SQL runs on has accessed the file. This account is a DOmain account and is in the Local Administrator of the SQL server and the remot box hosting the text file. Thats great if you want your developers testing and accessing your SQL box as Administrators. We don't work that way. Our developers connect via SQL Management Studio and test ther stuff that way. That's where the problem rears it's ugly head. When anyone runs a Bulk Insert command that accesses a text file t ...Show All

• Visual C# dateTimePicker = DateTime.Now & "Time"

  Whats the most efficient way to : Fire an event on a certain Day, Date and Time... Im using a dateTimePicker...for the day, date. Time is in comboboxes, start and end. ("1 AM") Just started...formatting is getting crazy...there must be an easier way. I have the "event" taken care of. Need something like: If(dateTimePicker.Now == DateTime.Now) ////Fire event Just not familar with DTP...regarding Time etc. ...Show All

• Visual Studio Express Editions Need Book

  I am using visual C++/CLI. So please does anybody knows a book to lern ADO.net and C++/CLI Ricardo 8a Here some links http://www.amazon.com/Pro-Visual-C++-NET-Platform/dp/1590596404 http://www.learningtree.co.uk/courses/uk510.htm And C++ has no good mechanism of interaction with ADO. Some mechanism y ou should make it youself! Be c areful ! .NET platform is a "p aradise" for hackers ! ...Show All

• Visual C++ I need to wrap a struct in .net that is used from a c dll

  Ok I have a c dll that I have the header file to. I need to wrap it so that the the c style structs are : 1. Exposed to calling .net dll's (C#.net) 2. Types are 1 to 1 eg. struct S in the header needs to be available as struct S in C# or other managed languages. What I have now is a .net managed c++ wrapper that works fine. What I do not have is a translation for exposing the various pointers and references as managed type so the other languages can consume it without going to "unmanaged" code. The current code does NOT use .net clr extension so all of the current code is considered pure c++. All comment will be greatly appreciated. Some one else could probally give you bett ...Show All

• Visual Studio 2008 (Pre-release) where is the OptimisticConcurrencyException exception?

  Hello, I'm trying to recompile lot of my May 2006 CTP code with the new March 2007 Orcas release. I've found lot of differences that I'm going to write down in a next post on my site. Btw, I'm not able to find the OptimisticConcurrencyException exception class with its Resolve method useful to change the behavior of LINQ during an optimistic concurrency. Anyone knows which is its new name Thank you in advance. Try ChangeConflictException. Charlie Calvert has a (partial) list of differences from the May CTP: http://blogs.msdn.com/charlie/archive/2007/03/01/february-ctp-now-available.aspx ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Creating a basic Terrain

  Hi everyone! I just downloaded game studio express and have successfully imported a mesh. Now, I'm ready to start building my game. I've decided to try and tackle some concepts 1 at a time and then incorporate them into a game. The first concept I'm trying to tackle is creating Terrian. I've searched quite a few places, but most tutorials I find simply create a random height terrain and render the color of the terrain based on height. What I'm wanting to do is import an image file and lay that on top of a grid. The most important consideration I have for the future is moving models over the terrain and adjusting the models x location to match the terrain height. This is all clear as mud. Any help or direction I would greatly ...Show All

• Visual C++ A Problem with feof()

  I am trying to build a program that, among other things, loads data from a binary data file, I use fread() in a while loop with condition !feof. every thing loads fine but the last part of the file loads twice creating a duplecate element at the end of the list. Does anyone know why this is and if it can be avoided; hear is my source code for the loading function: afx_msg void EditWindow::OnOpen() { if(head) { while(current->next) { current = current->next; } while(current!=head) { current=current->prev; delete(current->next); current->next = NULL; } delete(current, head); head =NULL; current = NULL; } ReadOutIn o; FILE* loadPointer = fopen("Level.lvl", "rb"); if(loadPointer) { while(!fe ...Show All

• SQL Server Full text search installed but ni languages supported :(

  Hi, I Have the same problem, i execute the T-sql statement select * from sys.fulltext_languages and i get zero rows, i uninstalled and installed again and nothing happend i still have zero when executing that statement, i try another computer and there evrything went fine!.. i do have Microsoft Net framework, and everything but i still can get this to work! help please!!! Hi Ikeer, Fulltext Search is not installed by default. You should confirm that you actually selected if from the feature list when you installed it. If you just took the defaults (i.e. clicked Next until you finished) you didn't install it. You'll need to launch maintenance mode from Add/Remove Programs and select Ful ...Show All

• Windows Forms Invalid ResX input!!!! Please help!!!!!!!!!!!!Urgent

  I got a error message this morning, "Resource transformation for file 'object.resx' failed. Invalid ResX input" I searched on the microsoft website, nothing useful, Please help me out. thanks a lot. BTW, I tried to find 'RegenResx conversion tool', but I couldn't find it anywhere. again, thanks for the help. ...Show All

• .NET Development Authorization by domain/computername role

  Is it possible to have a clients computername equal to the domainname to authenticate to I have for example the following snippet of my .Net remoting server configuration: <channel ref="tcp" port="20061" secure="true" impersonate="true" > And I set security actions by using declarative security. For example: [PrincipalPermission(SecurityAction.Demand, Authenticated = true, Role = @"oDomain\oRole")] public void DoSomething() { .. } My question now, is the following. Is it possible to have a client connecting to this remote object, having his computername as oDomain and a group on that machine named oRole. And would this client have access to DoSomething() Regards tj. Ok, Thanks. So it doesn't check ...Show All

• SQL Server How to group this table??

  Hi guys I need to aggregate a table to three different levels but I need the results in a single table. Here is the sample data IndicatorName DHBName PHOName Practice PracticeName Numerator Denominator ABC SAM a PracticeA QW 22500 22.5 BNN SAM b PracticeB SSS 22500 22.5 dddd JONES c PracticeC FFFF 22500 45 ssss Alter d PracticeZ QW 22500 22.5 rrrr Sam a PracticeA FFFF 52500 60 ABC GINI b PracticeA ASDFF 45000 45 BNN Hoe c PracticeD Tahunanui Medical Centre 45000 15 Now I need to group this ...Show All

• Visual Basic Can't get Microsoft Regular Expression to work

  I have urls that may start with "http" or "https" where I want to get the last parts of the url. For example, in "http://pear.nadd.tron.com/engg/resources/dwglogs/sum/sumpdf/joesl.pdf", I want to get just "resources/dwglogs/sum/sumpdf/joesl.pdf". The first part is always one of two ways depending on whether the url has "http" or "https", and that is always followed by "://pear.nadd.tron.com/engg/". I want everything after that. I can't see a way to extract the last part of the url I want with SubString and/or IndexOf, so I tried using regular expressions. However, I can't get the example in the Microsoft help file to work (http://msdn.microsoft.com/library/default.asp ...Show All

• Visual Studio Express Editions Download link returns blank page

  If I try to download Visual Basic Express using IE, the subsequent page simply displays blank without a download run/saveas window. I can download using the AOL browser. Anyone know what in IE prevents this from my trusted MS site I'm running McAfee Antivirus and Spysweeper. Sounds like a popup blocker. Try disabling your antivirus software. -Tim <MSFT> ...Show All