knvb's Q&A profile

• SQL Server Using fussy lookup in sql server 2005 integration services

  i have 4 different databases, in each one i have a table of customers i want to combine the 4 tables of customers from the 4 databases in a new table with eliminating similar records Check out Fuzzy Lookup and Fuzzy Grouping in SQL Server Integration Services 2005 @ http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnsql90/html/FzDTSSQL05.asp Thanks, Loonysan ...Show All

• Windows Live Developer Forums How to add Certificate in Trusted Root Certificate Authority

  Hi We have created our own CA Certificate and was to add it in Trusted Root Certificate Authority store for testing purpose But when we try to import the CA it gives us an error saying "the import failed becuase the store is read only" Please let us know if it can be imported in Trusted Root Certificate Authority store and if yes how ...Show All

• .NET Development Syntax Error

  I am trying to insert into a table that has an Autonumber ID field. The following is the code that I use to create the SQL statement followed by the ExecuteQuery command. Of course the Autonumber field is not listed in the SQL statement At the bottom I have copied the actual string value for strSQL_Write from the debugger. All of the field names are right. I recieve a Syntax Error in the INSERT INTO command at runtime. Any ideas strSQL_Write = "INSERT INTO tblOptionPrices (OptionID, Date, TradeDate, BestBid, BestOffer, LastTradeDate, LastTrade, Volume, OI, ImpliedVol, Delta, Gamma, VegaKappa, Theta, AdjustmentFactor) VALUES (" _ & intOptionID & ", " _ & strDate & ", " _ &am ...Show All

• SQL Server Execute Process Task using StandardInputVariable

  Greetings! I am using a Excute Process Task calling a selfwritten EXE and I'm trying to pass a command line argument to it. The code for the EXE is quit simple: Public Sub Main() Try Dim info As String = My.Application.CommandLineArgs.Item(0) MessageBox.Show("Info:" & info) Catch ex As Exception MessageBox.Show(ex.ToString) End Try End Sub According to the help files there are two ways to pass an argument, using the property Arguments, which I guess is for hard-coded stuff, and the StandardInputVariable for passing dynamic info. When I use the Arguments property everything works fine. I get the info messagebox with correct data. But when I leave that blank and instead use the StandardInputVariable proper ...Show All

• SQL Server Report parameters being searched for after they have been removed from all visible interfaces

  I've been building and testing my reports and have found that if I decide that a report parameter should be removed, removing the parameter causes the report to fail. If I remove a report parameter via the 'Report Parameters' menu, and I also remove the associated data dimension, filter expression and parameter check boxes, when I preview the report I get an error message. It appears the report is searching for the old parameter name even after it has been deleted. This leaves me with the option of either restoring the parameter as it was, or rebuilding the report from scratch. I've done some investigation and the parameters seem to exist within the XML code that underlies the report despite the parameters being deleted. Is there ...Show All

• Smart Device Development Resource DLL still active

  Hi all, We made a .Net DLL that is the managed end of an unmanaged - managed bridge. There is nothing in the DLL besides the wrappers to the unmanaged function calls and the P/Invokes. When I terminate the program the managed DLL stays active. Any ideas on why it would stay in memory Do you have to terminate a managed DLL in some way Alex, Nope. Everything is a command-response call, no threads. I did notice that it's only when I am debugging and the debugger terminates in an abnormal fashion, like an uncaught exception. It does not seem to occur when I run the program outside of the debugger or the debugger terminates the app normally. ...Show All

• Visual Studio Super slow installation for VS2005 SP1 beta

  Well, it’s not something new, there are people at Microsoft that work hard to make our life easier, like the Microsoft Windows Vista installer for example, an entire OS in 20 min; and there are some less experienced developers (my assumption only) who are given for some reason the task of creating the VS2005 SP1 installer. Whoever wrote that thing, he, she or they, can say whatever they want, but to take 2 hours to get the SP1 beta installed is just damn stupid, here are 2 hours by a million people in the world, a total of 2 million hours lost, thanks to a group of developers at Microsoft, maybe they could have spend 100 more hours to learn math, or to profile the installer, and could have saved the world a million hours ...Show All

• SQL Server Distribution Agent often dies with the following message. Why?

  Replication Distribution Agent often dies with the following log entry. At that hour little is ever going on so I am surprised that the error occurs. Failed Job -> JobName: Instance1-DB1-Instance2-33, StepName: Run agent., Message: Timeout expired. NOTE: The step was retried the requested number of times (10) without succeeding. The step failed.. Any ideas where to start Thanks 1. Did you run Distribution Agent in a SQL Agent job If Yes, can you try to run distrib.exe through command line 2. Was Distributor/Publisher/Subscriber started when you run the distribution 3. Do the SQL Agent job owner has the access right to Distributor/Publisher/Subscriber Thanks. This po ...Show All

• SQL Server SQL Server Manager Studio: Error when loading

  All of a sudden I am getting this error when I run SQL Express Server Manager Studio. any Ideas whay and how to fix it ------------------------------------------------------------------- See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.BadImageFormatException: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B) at Microsoft.Win32.Win32Native.SHGetFolderPath(IntPtr hwndOwner, Int32 nFolder, IntPtr hToken, Int32 dwFlags, StringBuilder lpszPath) at System.Environment.GetFolderPath(SpecialFolder folder) at Microsoft.SqlServer.Management.UI.ConnectionDlg.Personalization.get_ ...Show All

• Software Development for Windows Vista How to define workflow data by usind GUI?

  Greetings, I am a beginner in the field of WWF. I am about re-hosting the designer in windows application. The end-user will take the responsibility of designing the business process. but I need your help. I got some questions: t When I tried the re-hosted lab. The program doesn't allow me to rename the workflow and an error massage appeared and stop execution at this point public void UpdateTypeName( string oldClassName, string newClassName) { a throw new NotImplementedException (); } t I want the user to be able to define parameters (variables to be used within workflow) for all workflow at the beginning then he can assign each properties to the co ...Show All

• Windows Forms ListBox Problems

  I am coming to terms with ListBoxes (C#, VS 2005). I have a ListBox which I populated by way of a "Collection" in the Properties Box, with the values "0", "1", ... , "9". I experienced two problems. First, to get the "SelectedItem", "SelectedIndex" and "Text" values to change, I found I needed to double-click on the new value, even though the highlight moved to the new value after a single click. This is hardly user-friendly behaviour. Is there any way to get these properties to change on a single click Second, I could not find a way to cast the selected item (or the Text property) to an int variable, either implicitly or explicitly, or whether I tried the origi ...Show All

• Windows Forms very basic use of combobox

  HI I create this struct to load mi items in the comboBox, so far this is the only way I know to do it. struct Elemento{ string Text; string ID; public Elemento(string text, string id){ this.Text = text; this.ID = id; } public override string ToString(){ return this.Text; } } then I use this line to load the items comboBox1.Items.Add( new Elemento (MyItemName, MyItemId)); my question is: How can I get back the value of an item I did this but it does not work Elemento MyItem; MyItem = (Elemento )comboBox1.SelectedItem ; I know Im close but there is something missing. Is this the best practice to load or use a combobox thks hi Realy no Im not using a list to do bi ...Show All

• Visual Studio Team System Work Item DB Maintenance

  I am resposible for doing capacity planning for our TFS server. There seems to currently be no way to delete work items from the server which will cause our disk usage to increase forever. 1. Is there a plan for work item cleanup for a future version of TFS so long-lives TFS project can be maintained 2. If I delete a TFS project, does it delete all the associated work items for that project Along the same lines, what about maintenance of the database as the source code is concerned. Once again there is no way to delete anything, and in this case, not even deleting the project helps. I can't see having a database that grows forever. Or maybe I should run out and buy stocks in all the hard driv ...Show All

• Commerce Server Porting an SQL query from Commerce Starter Kit to CS2007

  I am trying to translate a SQL query (pasted below). written for Commerce Starter Kit into its equivalent for CS2007. Basically, this query is returning daily sales aggregate. Could some help me to translate this query I am quite new to CS2007. Also, will it be the same query for the CSharpSite and for StarterSite Thanks in advance, Joannes Lokad.com , sales forecasting provider select CSK_Store_Product.productID as [ProductId], CSK_Store_Product.sku as [Sku], CSK_Store_Product.productName as [ProductName], DATEADD(dd, DATEDIFF(dd, 0, CSK_Store_Order.orderDate), 0) as [OrderDate], Sum(CSK_Store_OrderItem.quantity) as [Quantity], row_number() over (order by CSK_Store_Product.sku) as [RowNumber] from CSK_Store_Product inner j ...Show All

• Visual Studio Team System Problem with Sharepoint using HTTPS in with Remote TFS

  HI, I have a dual server installation for TFS, I exposed to Internet and I configured the web server with HTTPS and SSL access. I have access to the projects, source control and work items, but I can Add new Team Projects, and the project portal is disable. the Documents and .... are not accesibles. I can have access to sharepoint either ( I suppose that it is because the same problem ) Can somebody help me. Thanks an advance, Roy You need to have a set of URL's that will work for both internal and external users. Once you look up the currently registered url's, you can try them from both internal and external clients to see if they work for both (it sounds like it won't for the external clients). If the currently ...Show All