casey2727's Q&A profile

• SQL Server Retrieving IP address of current client's connection

  MS SQL 2000: I can retrieve "host" name of the current connection from "sysprocesses" system table(select host from sysprocesses). But is it possible to get the IP address of the client connection instead of host I could not find any stored procedures or extended procedures that would let me retrieve such information. thank you in advance. Hi, there is no such call AFAIK. But you can use the follwing procedure to evaluate your IPAdress: CREATE PROCEDURE getIPAdress ( @Hostname VARCHAR ( 255 ) ) AS SET NOCOUNT ON CREATE TABLE #Results ...Show All

• Windows Forms Listview Bug? inconsistent scrollinfo (specifically nPage) setting for listview

  see bug details http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx feedbackId=f49fdbfe-fe7c-4dc3-84e9-c7a065e9bed0      Does anyone know a workaround ...Show All

• Microsoft ISV Community Center Forums Excel - squares appear when sending info from textbox to cell

  Hi there - Hope someone can help! I have a simple database in Excel, driven by VB. I have a textbox in a form that, when updating the record, enters the info from the textbox into a cell (ie, range("a1").value=frmdata.txtnotes.text. The textbox uses multiline, and when it updates the cell, squares appear where the enter key was pressed in the textbox. It is identical with the .value property. Does anybody know how to transfer the contents of the textbox, removing the squares but retaining the text format Thanks in advance, Chris Range("A1").Value = Replace(frmData.txtNote ...Show All

• .NET Development Forcibly unload an interop assembly w/ blocked unmanaged thread?

  I have the situation where I think my 3rd-party unmanaged COM object, which has opened a critical system resource, is blocked on a thread or something. In C#, .NET 2.0, I call FinalReleaseComObject() on my object, which returns 0, and then set the varible to null. I tried forcing a garbage collection and it didn't work (I know, it's bad, but I'm trying everything). Watching it run via depends.exe, I see all my other 3rd-party COM DLLs unload but not the one in question. Another twist is that this is a .NET 2.0 user control hosted in IE6. For some reason, I thought that IEHost would have shutdown the appdomain and thus forcibly unloaded ...Show All

• Visual C++ Funny response file for manifest tool 2nd invocation

  Nikola Dudar's blog says that linking is done twice if the manifest file is different that the one put in the target by default. My manifest file is different, so mt.exe and the linker are run a second time. On the second invocation, mt.exe runs with a line like: /nologo /out:.\debug\Prog.exe.embed.manifest /notify_update /manifest .\Prog.fixed.manifest .\Prog.fixed.manifest .\debug\Prog.exe.intermediate.manifest Why is my manifest file, Prog.fixed.manifest, merged twice Niel-O Actually, I messed up. It is the first invocation that uses this response file. ...Show All

• .NET Development Connecting to SQl 2005

  Hi, I have built an application in C#, using VS.Net 2003 and .net framework 1.1. i am trying to connect it to a SQL2005 database, which is held on another machine within the same network. I keep getting an error reporting that the sql database does not exist or can be not accessed. The connection string is OK. Do I need to install .net framework 2 on my local m/c, or is there something else which I need and if so what Thanks Jason You might be having network issues, security issues, server configuration issues or your connection string is in fact not OK. I've outlined troubleshooting connection issues here f ...Show All

• Windows Forms Allow Click Once Deployment only for registered Users

  I want to deploy a application by Click Once Deployment. But only users I give a password should be able to install the software. So I thought about protecting the URL with IIS access rights. But how will then work updating the software. I guess the user will have to type in his password every time the application checks for new updates Has anybody already experiences with such a scenario and can explain his experiences I believe I remember reading somewhere that this is only possible if you use Windows Integrated Authentication. In that case, the user may have to re-enter credentials when updating, but W ...Show All

• Windows Forms Handle pop up windows in WebBrowser control

  Hi all, how can i handle pop up windows opening with the webbrowser control Especially those opened by a window.showmodaldialog javascript function Thanks in advance This is a c++ solution: http://www.codeproject.com/atl/popupblocker.asp maybe you can create something from it. ...Show All

• Visual Studio Emailing a report

  I have a locally hosted report in an ASP .Net application.  I am rendering this report to a text stream so that I can send it via email, but I think there is probably a better way to do this. What is the best way to programatically email a locally hosted report Emailing reports is not a scenario directly supported by the local processing mode of ReportViewer. Report Server supports this feature directly, so upgrading to Report Server is recommended. ...Show All

• SQL Server Serious limitation in SQL server installation

  I am trying to install the server in a non-system drive.  I have to install the server in a diffferent folder like (E:) instead of the default C: due to existing partition that I have to continue to have (due to reasons that include security). Even though I selected this drive and every thing else (Program Files etc) the same, the install program still asks for over 2 GB on C drive. I checked each of the install options and found that most of this space is required by Books and client services which themselves need 1GB.  So I can do without them for now.  But then how do I get them installed   I can accomo ...Show All

• .NET Development Best encryption/decryption for strings

  I am looking for the best way to encrypt and decrypt a password. I looked into RSA but it gets too messy when you can only encrypt one letter at a time and get a byte[ ] back etc... Anyone know anything easier whether it is a built-in encryption/decryption or some class typed up from scratch Pref. something where you hand it a password and it encrypts the password into another string and vice versa but is just about as secure as this built in RSA. Thanks! ~Lauren What do you mean by "one letter at a time" e.g. string text = "abcdef" ; Console .WriteLine(text); // encrypt RSACryptoServiceProvider ...Show All

• Visual C# Assertion Failed error from MonitorDocumentsService during project load

  When loading a solution containing several projects (converted from VS2003) I get the following error message twice: Assertion Failed: Abort=Quit, Retry=Debug, Ignore=Continue  X at MonitorDocumentsService.OnBeforeDocumentWindowShow(UInt32 docCookie, Int32 fFirstShow, IVsWindowFrame pFrame) If I try to debug it just shows disassembly code and doesn't help. If I select Ignore, I can continue and things seem to be OK. Any ideas where to look Thanks! David I have the same problem under Windows XP, Visual Studio 2005 Team Suite. I have never installed VS2003. To re ...Show All

• Windows Forms CHild close when parent form closes

  Hi all, I have a parent form that instatiates and shows a child form. Is it possible to have the child form close when the parent form closes  Is there a setting I should set for this to occur. Thanks for your time in this.  I would have to agree that the web browser control is over complicating this issue. You certainly <b> ...Show All

• Visual C++ Which thread??

  I have an app which is soon to be multithreaded - calling a function with each of n threads (the same function). This is done in a for loop, however when the function is entered I wish to know which thread it is that is entering it, as depending upon the number of the thread I wish to grab different values from a class. Is it possible to pass a value to a function through the thread call i.e. passing the count from the for loop to the function in the call: t=gcnew Thread(gcnew ThreadStart(this, &MyClass::MyFunc)); as I can't seem to find a way to do it. Thanks, IxxI Thanks Nishant, I shall look at that ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. about the mouse input in sampleframework

  Hi all, Is there any way to know the location of the mouse and show the mouse location on the screen from time to time What should I do if I draw a texture in the sampleframework, and when the user clicks the mouse button at the texture, the samplework takes some actions immediately Should I need to calculate the boundary of the texture and then check whether the mouse is inside the boundary Thank you You can read the mouse coordinate in .Net the same as you would in any .Net application. You read the Cursor.Position. If you want you can use DirectInput to get the same information. However s ...Show All