FlemmingLaugesen's Q&A profile

• SQL Server Copy Database Wizard Error- SQL Server Agent cannot execute the SSIS package

  I am trying to copy a database from our company's external SQL Server(production) to our local SQL Server(development). The Copy Database wizard fails on the step "Execute SQL Server Agent Job". Following is the error in the log file.. Please advise InnerException-->An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) Oops. I thought you were using transfer database task in SSIS. I think you are at the wrong forum. I assume you initiated copy database wizard ...Show All

• Windows Forms How to add User & Pass to ConnectionString in app.config?

  Hi, I excluded the sensitive data (username-password) from my ConnectionString , how can I add it from any C# class when needed i.ex: string username = textbox1.Text; string password = textbox2.Text; Hello, As you are allowing user to enter the userid and password and not going to store in configuration, what you might do is: Create the connection string in application configuration(appSettings) and while using the connection string, replace the userID and password of the user before assigning the connection string to connection object. Hope this helps you. ...Show All

• SQL Server SSIS Auditing example

  Greetings SSIS friends, Do any of you guys have a link to a website with an example of how to create a solid audit system for SSIS packages Thanks for your suggestions in advance. dreameR.78 wrote: Hi guys, To be honest with you, having read the white paper and various other articles on the web regarding data quality checks and package auditing, I find myself more confused than ever. I wouldn’t even know where to begin or how many tables I need for my auditing. I will attempt to explain to you what my requirements are but please don't get me wrong. I am not after a spoon feeding session or anything but a general discussions with some ideas based on your own experiences. My SSIS package us ...Show All

• Windows Forms How to stop an autoscroll event on a panel?

  Hello, I have a problem with getting an autoscrollbar to end up where I want it. Things to know about the prob: I have an imagebox inside of a Panel for (inheritance of) autoscroll capabilities. The imagebox is named panel2 for my own conventions and the panel will be named panel1 Panel2 (the imagebox) is set to fit to the size of Panel1 (the Panel). All of this works great... I have broken up an extremely large image (width wise, not mem size) that is to large for autoscroll to handle which caused my prog to crash. The original image (the really big one)will be called bmp_temp. Each of these smaller image pieces I will call testimage0, testimage1, etc. and will save them to myBmp. I have set the following: panel1.Auto ...Show All

• Internet Explorer Development Printing: override default "shrink-to-fit" with "100%"?

  Hello, I am having a problem with the default "shrink-to-fit" functionality on our website. Is there a way to control this behaviour from javascript I would like to be able to set it to 100% in onload() event so that the users do not have to "fiddle" with print preview. Regards I too am having issues here. I have a CSS sheet designed for proper printing, it looks great in IE, however that "shrink to fit" thing is a pain. ...Show All

• .NET Development Call Primary Key in SQL statement

  Is it possible to create an SQL statement somthing like "WHERE PRIMARY KEY is something" Primary Key being the primary key of the table. I need to have it find it in the SQL statement because it can change depending on which table I pass to the function. There is no generic definition that defines PRIMARY KEY , so you will have to know what field is the primary key. The proper syntax is to say: SELECT fielda, fieldb, key FROM myTable WHERE key = 'something' Also as a side note, you could also say WHERE fielda = 'somevalue' even though it is not a primary key. It just would not be as performant without adding an index on that field. ...Show All

• Software Development for Windows Vista Wallpaper Fade Through

  I searched around this forum and didn't see anyone asking this. Ok, now I haven't gotten a chance to dig around in the Vista API yet, but my initial work with it seems to be indicating the wallpaper elements are very near to the XP version (again, haven't written the code to check). I am just thinking that it's about time we got ourselves a proper way to fade-through our backgrounds to a random one out of a selected folder or set of folders. So, I must ask, has anyone messed with the API in such a way to confirm that this is even possible (without the cheap tricks of XP that never worked smoothly) or has anyone seen (heaven forbid) an app that does this already And I mean does this well. Not by using HTML backgrounds or any of th ...Show All

• Visual Studio Tools for Office [VSTO v3 / Office 2007] Get value from a combo box content control

  Hello everybody, In a Word 2007 document, i'm using a combobox content control where items have been added programatically. On the ContentcontrolOnExit event I would like to display the value of the selected item. Here is what I've tried: void ThisDocument_ContentControlOnExit(Microsoft.Office.Interop.Word. ContentControl ContentControl, ref bool Cancel) { switch (ContentControl.Title) { case "CommerciauxDropDownList" : Word. ContentControlListEntry CommerciauxDropDownList = (Word. ContentControlListEntry )ContentControl; String SelectedId = CommerciauxDropDownList.Value; break ; default : break ; } } But I get an InvalidCastException on this line: Word. ...Show All

• Visual FoxPro Future of Visual Foxpro

  Hello friends, I have a general question. What will be the future of VFP The reason for asking this question is because, our company is planning a major commercial software development. So far we were very much satisfied with VFP. But now doubts are being raised whether we should base our investment on this platform or consider something new like VB.NET. Especially when we hear that the products will not be served beyond 2009!!! Any sincere opinion will be a big help. Thank you. I used to be a VFP-only developer. But with the advent of .NET plus user requirements where a web app is most appropriate, I started using ASP.NET. Now, I still use VFP for small to medium LAN based apps. I believe it still has its uses. ...Show All

• SQL Server Dedicated Administrator Connection

  Hi: I am trying to connect to my local instance of SQL Server 2005 using Dedicated Administrator Connection by using Admin:Servername\Instancename and I end up with the following error. Dedicated administrator connections are not supported. I enabled the connection in the SQL Configuration Manager and still get the error. Any ideas on how to resolve this error . Note: SQL Browser service is running. Thanks Ak Thanks Ashvin. That did exactly confirm that I was connected using DAC. It returned one row. So my million dollar question is why cant I connect to DAC using ADMIN keyword. I tried all that have been suggested in this thread and still it says DAC connections are ...Show All

• .NET Development Help with the load balancer Problem

  Hi, We use load balancer for our asp.net web application. But it doesn't work as we expected. If the same client sent requests continuously,The big IP always direct client's requests to the same server. However, It works fine if the other user send the request at the same time, the big IP will direct to the other server. Can anybody help with that Thanks! Thank you Pranshu. I am saying the same client send multiple requests to us, these multiple request are complete different requests, the only thing in commmon is they came from the same client and send continuously, but they should be different request. And We already remove the sticky setting from the configuration. It is still not working. ...Show All

• Windows Forms Windownmediaplayer component versus disable control?

  I have a datagrid control and named "dg" and windowmediaplayer component name "wpl"; in form1_load event I wrote { this.dg.visible=false; } but in fact my datagrid still visible and if I try to right click tit's context menu I will got and  error about the datagrid is not visibled to do that. so how can I set this datagrid. visible=false and I see it nowhere in the form Thank for any help DongMT Im working with C# ...Show All

• .NET Development RSS Aggregator / Reader - Peter Bernhardt

  Hello: I'm trying to develope a RSS reader in ASP.NET (VB) and I see the code of Peter Bernhardt but it doesn't work with all the addresses, per example http://tcberglind.blogspot.com/rss.xml , anybody knows why Thank in advance. Mario Ruiz Try posting the same in http://forums.asp.net This is all for ASP.NET and for sure there you will find what you need. Regards, Rodrigo ...Show All

• Visual Studio Team System Missing TFS Reports

  I can't seem to find the Exit Criteria, Fix and Fix Bug Rates, and Quality vs Velocity reports when I create a project or download a process template. These reports are listed on the TFS product page as available reports with TFS RTM. Our setup is TFS RTM from a B3R installation. I checked the B3R process templates, and it did not possess the noted reports either. Should these reports be available with the install of TFS RTM Hi Matt, I don't think the upgrade added the missing reports, so if the project was created with B3R then the reports will not exist. If they were created with the RTM bit and the RTM version of the process templates then they will exist. I'm not sure if you can just upload the reports manually, ...Show All

• .NET Development C++ unmanaged DLL loaded from a C# .exe

  Im having trouble creating a C# application that will load an unmanaged C++ .dll. Is this a known issue or am I just not pulling the right levers 1) VS 2005 builds managed DLLs .. If you are trying to use C++ on VS 2005, refer to the following link to build an 'managed' C++ DLL(which I guess is not the case..): http://msdn2.microsoft.com/en-us/library/9yb4317s.aspx 2) If you are using VS 6 to build the unmanaged DLL, you may want to use the PSDK - http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=58670&SiteID=1 (ignore the porting stuff talked about in this link - because you are building all from scratch..) ...Show All