DPalacino's Q&A profile

• SQL Server How connect SQL server 2000 with c#.net .....?

  Hello masters, help me yaar i am using dotnet 2003 and SqL SERVER 2000. BUT UNABLE TO CONNECT DATABASE using dataAdaptor(design time ) or sqlconnection any can help me gs whats the error lets see the connection string. make an empty text file called "c:\test.udl" - double click it and try to build a SQL Ole Db Provider datalink. . . can you get that to work Are the TCP protocols enabled in your machines client network settings and in the servers network settings ...Show All

• .NET Development Weird socket disconnect/dispose problem

  Hi, I have a StateObject that holds the working socket. Everything is fine when I don't debug except two exceptions. As soon as I put a breakpoint in my server code and look up the socket in the state object it is connected and not disposed. Now I step forward with the debugger and suddenly the socket is disposed and disconnected. How can that be Also, I have one method where I just pass the socket to another method. When it "arrives" at the other method it is disposed The client doesn't disconnect nor does the server kill the socket intentionally. Any ideas Thanks, Tom hm, after I rebooted my machine this ...Show All

• Visual Studio tasknavigated event

  I am using the tasklist object in my add-in and have an eventhandler for the tasknavigated event.  Here is the code in the handler: if (myTaskItem.FileName != "") { TextWindow myTxtWin; TextPane myTxtPane; myTxtWin = (TextWindow) applicationObject.ActiveDocument.ActiveWindow.Object; myTxtPane = myTxtWin.ActivePane; myTxtPane.Selection.MoveToLineAndOffset(myTaskItem.Line, 1, false ); myTxtPane.Selection.SelectLine(); navigateHandled = true ; } This code is working when I double-click and item in the tasklist or navigate the list with the arrow keys and press the enter key.  The problem is when I select next or previou ...Show All

• SQL Server EXCEPT Operator

  Hello everyone, I have two tables athat are structurally identical.  I wish to obtain rows that are in the first table that are not in the second one (e.g. the EXCEPT operator). EXCEPT is not supported directly in TSQL... Does anyone know how to do this ! !  Thank you for your time Chris SQL Server 2005 adds support for EXCEPT and INTERSECT set operators. So you can use it if you are running SQL Server 2005. Otherwise, you will have to use EXISTS like:   select * from first_table as t1 where not exists(  select *  from second_table as t2  where t2.key_col1 = t1.ke ...Show All

• .NET Development environment properties

  Hi all, how can I retrieve the following properties from managed code in vb   1. App Domain Name 2. Thread Name 3. Process ID 4. Process Name 5. Dll Name & Code Line thanks! Hi Param, At the moment as of v1.1, both the IDs will be same but Microsoft claims that they may change this. And in future version at runtime, the Win32 Thread Id can change during execution of a program. Regards, Vikram ...Show All

• SQL Server How to avoid Caching of Reports?

  Hi All, We have a Report wherein we specify the criteria and then generate the report. The issue is when we give a new criteria the second time and generate the report, we get the old result set that was for the previous criteria. How can we avoid this Thanks in advance. Sundar if you are calling the report via URL access then add in the rs:ClearSession=true command to the url ...Show All

• Visual Basic Certain Declarations

  Well i found out how to open up a Halo map in VB, my freind gave me this vb.loadhalomap and vb.loadhalomap(filename)   but when I put it in the open vb is underlined, my freind also said that i need Halo SDK, but i cant find that so is DirectX 8.0 SDk close to it so itll reconize the delcaritons   You wil need the Halo SDK. SDK stands for Software Development Kit . Specifically, you need the Software Development Kit designed for developing software for Halo. Check with your friend to see where he got it from, maybe you can get it from the same place. ...Show All

• Visual Studio 2008 (Pre-release) Using IIS as host

  Hi Is there is any reason to use IIS to host WCF applications Internet Information Services (IIS) The IIS hosting option is integrated with ASP.NET and takes advantage of features offered by these technologies, such as process recycling, idle shutdown, process health monitoring, and message based activation. On today’s Windows XP and Windows Server 2003 operating systems, this is the preferred solution for hosting Web service applications that must be highly available and highly scalable. IIS also offers the integrated manageability that customers expect from an enterprise-class server product. Thi ...Show All

• Visual Basic Stopping Alt+Ctrl+Del

  Hi all I'm writting a program for public payable networked computers for playing games. I've got the server/client billing and other stuff like that done. Problem is, when my program boots up, it displays a full screen form (on top of everything), which holds the login/programs they can use/play. I've managed to remove the Alt+Tab, Alt+F4 and other key combinations like that.  Although, i'm finding that Alt+Ctrl+Del still brings up task manager no matter what i do. I have a solution, that on program startup, it renames taskmgr.exe, (and the backup in dllcache), and it works (Doesn't launch taskmgr),  however, there is a window ...Show All

• Visual C# Hooking a closed event to Word document?

  I am opening a MS Word document using the following C# code. <code> Word.ApplicationClass WordApp = new Word.ApplicationClass(); // Use the open file dialog to choose a word document if ( this .openFileDialog1.ShowDialog() == DialogResult.OK) { object fileName = openFileDialog1.FileName; object readOnly = false ; object isVisible = true ; //Here is the way to handle parameters you don't care about in .NET object missing = System.Reflection.Missing.Value; //Make word visible, so you can see what's happening Wor ...Show All

• .NET Development SslStream and SSL protocol not recognized (i think)

  i wrote this simple apps to connect to an IRC server but it doesn't work :( using System; using System.Collections.Generic; using System.Text; using System.Net; using System.IO; using System.Net.Security; using System.Net.Sockets; using System.Security.Cryptography.X509Certificates; namespace provaSSL { class Program { static void Main( string [] args) { try { string certName = "" ; TcpClient sslClient = new TcpClient (); sslClient.Connect( "irc.discostars.de" , 7000); SslStream sslStream = new SslStream (sslClient.GetStream(), false , CertificateValidationCallback); ss ...Show All

• Visual Basic Need a VB6-to-VB.NET translation

  I have a block of VB6 code to be translated into VB .NET if possible. The block of code reads as follows: Option Explicit Private Sub cmdClose_Click() Winsock1.Close End Sub Private Sub cmdConnect_Click() Winsock1.RemoteHost = InputBox _ ("Enter remote host (IP address or name)") Winsock1.RemotePort = 1066 Winsock1.Connect End Sub Private Sub cmdSend_Click() If Winsock1.State = sckConnected Then Winsock1.SendData InputBox ("Enter data to send") Print "Sending data to" & Winsock1.RemoteHostIP Else MsgBox "Not currently connected" End If End Sub Private Sub ...Show All

• SQL Server Why is sort so slow?

  I set up a sample sort data flow that is attempting to sort 11M records totalling about 3GB. It ran for four hours and then I killed it. How can it be so terrible Am I missing some hidden tuning parameter David C Baldauff wrote: Improving Sort Speed: 1. Limit row count. 2. Limit row size. 3. Make sure temp directory is on a fast disk with plenty of space available. 4. Try not to sort on text fields. 5. Maximize available system RAM for the SSIS process to use. 0. Where possible, sort at the database level by using an ORDER BY clause and setting the IsSorted flag to true on the ...Show All

• Visual Basic Error in IPictureDispToImage

  Hi, I have an application in VB which is bieng upgraded to VB.NET. The application reads pictures and images from EXEs and Folders to place it in image lists. The aplication has a toolbar control onto which the contents of image lists are placed as icons. The VB6 Code looked like Tray.Icon = ImageList1.ListImages(imgIdx).Picture frmTimer.Icons.ListImages.Add , icoKey & CStr(iName), m_cI(iName).IconPicture(Me.hdc, ClosestIndex(iName, 32)) The upgrade wizard changed the code to Tray.Icon = VB6.IPictureDispToImage(ImageList1.ListImages(imgIdx).Picture) frmTimer.DefInstance.Icons.ListImages.Add(, icoKey, VB6.ImageToIPictureDisp(m_cI(1 ...Show All

• Microsoft ISV Community Center Forums copying links from specific cells in a worksheet to specific cells in another worksheet

  Would greatly appreciate any help with the following code - am having difficulty assigning the first inputbox range to a variable and making the code work. I have labelled the lines with the problems. thanks. Sub CopyPasteLink() Dim i As Integer Dim CopyCells As Range 'the cells into which links will be copied Dim TargetCells As Range 'the cells that copycells will be linked to Dim CopyAddress As Variant 'the address of the copycells Dim TargetAddress As Variant 'the address of the targetaddress i = 0 For i = 1 To 100 Set CopyCells = Application.InputBox("Click on the cells to copy", "Automating copying links" ...Show All