Jesper Kleis Jensen's Q&A profile

• SQL Server Problems with SQL 2005 Export Wizard

  I am trying to transfer data from SQL Express to SQL Server 2005. The data is from Paypal Commerce Starter Kit from ASP.NET site. I have tried several options (Optimize for many tables, Run in Transaction). However the data is not exported. This is the error I am getting: TITLE: Operation stopped... ------------------------------ The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.". This occurs when CPackage::LoadFromXML fails. ------------------------------ ADDITIONAL INFORMATION: The package failed to load due to error 0xC0011008 " ...Show All

• SQL Server Remote connection issues

  My experience with SQL Server Express 2005 has been nothing short of a nightmare. It is installed correctly, and is running, I can connect through management studio express and have created a database, but only to instances running locally. If I try from another machine, it won't connect, saying that the problem may be due to the fact that by default, SQL Server does not allow remote connections. However, I have enabled remote connections (through TCP/IP and named pipes). I have added sqlserver as a firewall exception, to no avail, and disabled the firewall as well. Nothing seems to work. Ultimately, I want to connect to a database and execute queries from a VB program. I am a competent programmer but I am at my wits end. ...Show All

• SQL Server Instead of Update trigger not behaving like anticipated

  This update trigger will not change the status field in my table to an E. The value that it is adding to the datefield is 20. default value of that datefield is getdate. So I figured if the lastactivity time is < than the expiration time it would keep it as an A otherwise it would set it as an E. Here is the code: ALTER TRIGGER tu_LoggedIn ON dbo.LoggedIn INSTEAD OF UPDATE AS BEGIN UPDATE LoggedIn SET Status = ( SELECT CASE WHEN LastActivity < DATEADD ( minute , ( SELECT CAST (Value AS integer ) AS value FROM SecuritySettings WHERE (ID = 1)), LastActivity) THEN 'A' ELSE 'E' END AS lact FROM LoggedIn AS LoggedIn_1), LastActivity = ( SELECT CASE WHEN LastActivit ...Show All

• Visual C# Offsetting UserControl location...

  I am having this annoying problem that I do not understand. I have a UserControl and I am trying to change its Location . I want to say: this .Location.Offset(iAdjustX, iAdjustY); However the above does not work. It seems I need to do this: Point pt = this .Location; pt.Offset(iAdjustX, iAdjustY); this .Location = pt; I do not understand why I cannot just apply the Offset method to the the UserControls Location . Am I missing somthing here Thanks, Bob Hi What I try to sey is that if we can change Location point directly we don't know what else we must do. Must we do Refresh, Invalidate or something else That's the reason why we must call properties set method. ...Show All

• SharePoint Products and Technologies Cell Formatting Task Pane

  Anyone know how to get the Cell Formatting Task Pane to appear I closed it and now have no idea how to get it back! If you select the cell in the Quick Tag selector in the top bar of the design view, do you see the Data/Cell Formatting option I don't have a copy of the program handy at the moment so maybe I am just deeply confused. ...Show All

• SQL Server Error message returned when executing package via C# app on Citrix

  Hi, I'm at a loss as to why i am getting the following error: Retrieving the COM class factory for component CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E}failed due to the following error: 80040154 I am calling the package from a C# application which i have installed within a citrix environment. The application works without any trouble on my development machine but as soon as i run the code that executes the SSIS pacakge i get the error. Can anyone enlighten me as to what is causing this Many thanks in advance, Grant Hi Grant, Error 80040154 is the error you'll get when a class is not registered. Are you referencing any assemblies or 3rd party components that aren't installed on the citrix server Make ...Show All

• SQL Server Subscription cannot be found

  for some reason, it cannot find my subscription.  I've used this code just find for other subscriptions on my report server.  The subscription is there and it looks fine. The error: System.Web.Services.Protocols.SoapException was unhandled   Actor=" http://localhost/ReportServer/ReportService2005.asmx "   Lang=""   Message="System.Web.Services.Protocols.SoapException: The item '/Apex/sss_test' cannot be found. ---> The code:     Public Sub RunsssReport()         MsgBox("got here2")         Dim rs As New ReportingService2005()         rs.Credentials = System.Net.CredentialCache.De ...Show All

• Visual C# Open an C# Form in C++

  We have an C# form that need to be open in MFC C++ (Unmanaged), how can this be done easily If you have a small example of that it will be appreciated. Thanks xRuntime wrote: Wouldn't you be better off asking this in a C++ forum or IRC chat because the coding would be done in C++ more so than C#... I've done a good amount of C++, but I haven't dealt with MFC so sorry can't help... Yeah, you are absolutly right, I don't know what I was thinking.... ...Show All

• Windows Live Developer Forums Mouseover of polygons, what's the latest?

  I've read a few threads and was just wondering if anyone has developed a nice way to add mouseover to polygons and or polylines Thanks! We had big big thread some time last year with various ideas. In the end we identified an issue that had to be fixed in VE i believe. For my client at the time I had a simple div label next to each polygon and could easily have a little action menu appear. I'm still very keen to get this sorted so we can do exactly what happens on maps.live.com in terms of editing. (I have asked the VE team on serveral threads to lend us a hand with this, but never got a responce) If anyone has a good working solution please let me know too! And lets put it in the wiki for everyo ...Show All

• Visual Studio Tools for Office Including "OutlineNumbered" Bullets and Numbering

  Hi, I am performing Word 2003 automation using C#, VSTO 2005. The macro for Inserting bullets and numbering of type outlineNumbered is something like ListGalleries(wdOutlineNumberGallery).ListTemplates(5).Name = "" Selection.Range.ListFormat.ApplyListTemplate ListTemplate:=ListGalleries( _ wdOutlineNumberGallery).ListTemplates(5), ContinuePreviousList:=False, _ ApplyTo:=wdListApplyToWholeList, DefaultListBehavior:= _ wdWord10ListBehavior I need to perform a similar operation in C#, and the method for the same in C# is oWordDoc.Selection.Range.ListFormat. ApplyListTemplate ( ListTemplate , ContinuePreviousList , ApplyTo , DefaultListBehav ...Show All

• Visual Studio Express Editions Installing VC# Express after the Pro

  Hi, if one have the VC#2005 Pro installed, can then install the VC#2005 Express without damage the pro version (unfortunately, the express installation don't permit to modify installation directory that is the same of the professional). Thanks. There have been several questions about this already. Yes, you can install and run both VS pro and VS express side-by-side, just like you can have VS 2005, 2003 and 6.0 all on the same machine. ...Show All

• Visual Studio Team System Cannot add work items in TFS for Developers

  Hi I have just installed TFS for Developers, and cannot add any Work Items. I am the administrator of the project and when I right click to add work items I get a menu with 1 item which is disabled. The text of the menu item is "Error loading menu: Index was outside the bounds of the array". I have installed VS Tools for Office Runtime and have even tried repairing my VS Installation. I am running XP SP2 and have the latest windows updates installed. We have other teams who have installed the software and it works. Thanks Andre This is most likely because of registry key issues with our UI components. We thought we fixed it but looks like it still happens in some circumstances. To fix it, delete ...Show All

• Visual C# Intellisense in properties

  Hai I am creating a property on a form . After creating the object for this  form  from a  new form and search for ths property . i got  " form.propertyname " as a descriptive text like the 1 which we can see in .NET . Now i want to show a detailed description of this propery  when i select this propery from the new form. ..How is this possible.. Help me please Thanks Ratheesh     I believe you maybe talking about the Xml markups or something to this effect - the description about the property/method correct if so simply enter 3 forward slashes together just before the property/method name: /// Example I have a method: public void DoSomething(string p ...Show All

• SQL Server Always showing the parameter input area.

  Greetings, Is there a way to force the parameter input area to always show even when default values are specified I want to always display the parameter area even when I set initial parameters. Thanks Made progress! When I invoke the report via the url command the parameter area is always visible. When I invoke the report via the navigation functionality of a report item the report is rendered but the parameter area collapsed. Still dont know why.... ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Directx SDK (december 2006) viewer crashes on startup

  Well, the title basically describes what is the problem... I've uninstalled my directx sdk (october), rebooted to make sure things were clean. Then I installed the last SDK (december) and my viewer (directx sdk's viewer for .x and .fx files) simply stopped to work. Whenever I start it, it crashes with the 'send report' error. Any ideas what could've caused this " I am m3rcyful ag3nt on gamedev.net :) Check here . ...Show All