Andy Lindley's Q&A profile

• SQL Server SSIS Diagramming

  Hi, I just want to ask, is there a tool that can create a diagram supporting the SSIS package I have created I would like to know if there is any available tool that can do this task so that I can support my SSIS package documentation. For example, I have created a Data Flow task that transfer data from a source database to SQL server 2005 destination. I would like to create a diagram that summarizes the task it perform fr ...Show All

• Windows Forms how can I set the value of "SPI_SETFOREGROUNDLOCKTIMEOUT" to 0 using SystemParametersInfo()

  I want to set the "SPI_SETFOREGROUNDLOCKTIMEOUT" to 0 using SystemParametersInfo(). Please give the syntax and a small example program. ...Show All

• .NET Development Possible to pass System.Type and then cast an Object?

  Im trying to do something like this: public class isthispossible() { Inventory someClass = new Inventory; Type someClassType = someClass.GetType(); someMethod(someClassType); } public someMethod(Type ClassType) { Object someObject = new Object(); someObject = (ClassType)someObject; } I want to pass a System.Type and then cast an object to that type, using that System.Type I passed. Is t ...Show All

• Visual C++ How to handle header and footer in a report?

  Hi, I must first say that I only have a couple months experience in Visual C++. I've been reading a lots of books on the subject. Unfortunately, most of the time, the examples I could have on specific item was very "general" if I can say. With the other languages I'm using, I'm able to make reports with header and footer repeating on each page of report as well as an auto-incrementing page number, subheaders, subtotals/subfoote ...Show All

• SQL Server Error Calling SQLCLR UDF

  Running SQL Dev Edition on Win2K3 Enterprise Edition. I get the following error. Msg 6522, Level 16, State 2, Line 2 A .NET Framework error occurred during execution of user defined routine or aggregate 'AddressCorrect': System.DllNotFoundException: Unable to load DLL 'D:\CorrectA.dll': Not enough storage is available to process this command. (Exception from HRESULT: 0x80070008) System.DllNotFoundException: at UserDefinedFuncti ...Show All

• Visual Studio Express Editions How to use UTF-8 above 128!

  Hi all, My program needs a 3 byte output. I've managed to convert 2 of the Integers into UTF-8 format. But one of the Integers is 255, this is a constant not a variable amount. But it outputs 2 Bytes and not 1 as I need. So is there any way to convert 255 into a UTF-8 format Thanks for any help or advice. I've got my Null cable. And it's attached to this PC. And it outputs to Windows HyperTerminal on another PC. The other P ...Show All

• SQL Server Cannot import Oracle data with OLE DB

  I have a column in an Oracle source system with data type NUMBER(38,2). The value "-0.01" is causing problems when trying to import into a SSIS data-flow. The only way I can import this into my data-flow is by using a Datareader connection manager using the ODBC Data Provider. My DSN is using the Oracle ODBC driver. If I try and use the "Native OLE DB\Microsoft OLE DB Provider for Oracle" I get an error: " The data value cannot be converte ...Show All

• Visual Basic Support for VB6 and COM

  We currently use VB6 and have several applications that make use of COM objects. It works well and we're happy with it. What I'm wondering is, at what point might support for VB6 be dropped in favor of newer versions and, when we do eventually upgrade, should we be concerned that we may at some point lose support in the tool for COM programming (and if so, when) Thank you so much for any insight you can provide. ...Show All

• SQL Server SQL Server 2005 Express Installation Problem: Incompatible components from beta version of .NET Framework

  Hi all, Yesterday, I just downloaded the SQL Server 2005 Express (SQLEXPR.EXE) and tried to install it in my Windows XP Pro PC that is on Microsoft NT 4 LAN System. I got the following error:                                          &n ...Show All

• Visual Studio Unable to debug: The binding handle is invalid

  When i try to debug a C# application I get this error: Error while trying to run project: unable to start debugging the binding handle is invalid What can i do Thanks for your answers ZAiNT, Thank you so much for your help. To test native debugging: 1) File->New->Project... 2) Visual C++->Win32 Console Application 3) F10 Thanks, Gregg ...Show All

• Visual Studio Invoking MSBUILD from Inside an App

  So I have created some custom MSBUILD tasks (to deploy SQLCLR assemblies). They work fine when I execute them from command line: msbuild /t:taskname project_file. However when I try and execute from inside an application by using the Engine.BuildProjectFile, I can't get it to work. That's not the main problem as at the moment I am explicitly sending in params which should make it fail. The weird part is that I can not get any output back. I have ...Show All

• Visual Studio Express Editions The page cannot be displayed

  Hi. I am new to ASP.NET I am facing a problem when i try out the Visual Web Developer 2005 Express Edition Beta 2. When i try to view my ASP.NET page in the ASP.NET Development Server come together with VWD 2005, it show The page cannot be displayed and the url at the address bar showed http://localhost:1683/WebSite2/HTMLPage.htm I am using Windows XP SP2 Please help me on this, i reallt couldn't find any solutions on it. thank you. Andy ...Show All

• Windows Forms how can i close a form from another form?

  for example: Form1 loads first and when I click a button Form2 will display. What I want to do is to close Form1 which is the startup form when I exit Form2. How do I do that Hi, I've been looking for a solution to this for a while and have never even got near. Your solution is the first I've seen that doesn't involve writing code the size of 'War and Peace', (oh yeah, AND it works!!),so would you mind if I picked your brains a bit furt ...Show All

• Visual Basic UnAuthorizedAccessException in Web Control when take a frame - Windows Form

  Hi, I am using Web Control and parsing data from a web site containing iframes. When i try to access iframe in below code (C# code) IHTMLDocument2 document = (IHTMLDocument2) axWebControl .Document; String frameName = "body"; Object o = (Object)frameName; Object obj = document.frames.item(ref o); IHTMLWindow2 mainWindow = ((IHTMLWindow2)(obj); IHTMLDocument2 doc = (IHTMLDocument2)mainWindow.Document here an ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Setting a custom cursor image [MDX2]

  Hello all, I'm not sure if this post landed in the right forum, I'm sorry if it didn't. I'm developing a smallish Managed DirectX (2.0) application and I would like to change the standard mouse cursor image to my own image. I've created a small 32x32 image that I would like to have instead of the normal windows cursor. I guess this would change the cursor in other windows applications aswell during the time my application is running but that is ...Show All