Grant Dickinson's Q&A profile

• SQL Server A Clarification required on xp_terminate_process

  HI , I have a problem where i have to kill a windows process in my procedure. In sql server 2000 i could find a procedure called xp_terminate_process ( which takes process id as parmeter and kills the process) . but i couldnt find any replacement or another new one to do the same in sql server 2005. if any body have any idea or suggestion regarding how to go about this are welcome.. Thanks in advance Mohan I just can't imagin ...Show All

• SQL Server Need - help to create DLOOKUP with SSIS

  Hi, Does anybody knows how to create a DLOOKUP (dynamic lookup) in SSIS withour writing any kind of script I need to test records existance in destination from the source before inserting or updating in the destination (if the record exist in destination then update, else insert). Any help apreciated. I find the Lookup component works best for this. Jamie wrote an article that compares lookup as well as other ...Show All

• SQL Server VS.NET 2005 and CLR stored procedure permission sets.

  VS.NET 2005 automatically deploys a CLR stored procedure when you start a project with debugging. However, if the CLR stored procedure attempts to access external resources you will get a message stating: System . Security . SecurityException : Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed . I've isolated this to ...Show All

• .NET Development Bizarre GC behavior (while testing a WeakDictionary)

  I am encountering a bizarre GC behavior while testing a dictionary that I have designed. The designed dictionary is a WeakDictionary. That is basically a Dictionary where all values are kept through a WeakReference. The WeakDictionary does not prevent the values from being collected if they are not rooted elsewhere. Here below is the NUnit code that I am using to test the WeakDictionary. As you can see there are lines with REQUIRED. If those l ...Show All

• Windows Forms Preventing "owner" Form from losing focus when showing another Form?

  Hi, I’ve made a custom drop down control which inherits the ComboBox, for dropdown purposes. When the dropdown event is fired, I display a new borderless Form (form.Show()). The problem I have is that the "parent" form, i.e. the form having the dropdown control, is of course deactivated when the dropdown form is shown and this doesn't look very nice. I’ve tried alot of different things, like overriding CreateParams and setting th ...Show All

• Smart Device Development connection string error

  [code]      Dim rdaOleDBConnectString As String = "Data   Source=WINWIN;Initial Catalog=HOME; " & _             "User Id=<username>;Password = <password>" [/code]   Error Message = A required property is not specified. [ Property name = SubscriberConnectionString ]   can anyone tell me what is the error by the way what is DATA source and Initial ...Show All

• Smart Device Development Bluetooth, PocketPC 2003, VS.Net 2005 to Access Network DB

  We have a number of iPAQ 39XX units, some with bluetooth. Is it possible to build a web service which a bluetooth-enabled PDA can access by going through a workstation connected to a LAN Obviously, using WiFi, this should be QED. I need to show my boss the potential usefulness of PDAs to access DBs on our LAN, via web services before we invest in WiFi-enabled handhelds and more wireless access points in our workplace. I am excited about the ...Show All

• .NET Development Framework 2.0 breaks interop app

  VBScript code calls C# class library objects published to COM with ComVisible attribute. It works fine only when  1.1 runtime is installed. After installing 2.0, script breaks with 'unknown exception' when returning from CLR (property or (in other place) method is called, both returning managed object) Class library is compiled against 1.1 and 2.0 runtime (it doesn't matter) Both script and class library can be even debugged an ...Show All

• .NET Development Process.StartInfo.Arguments

  I am trying to GET the arguments that were used to start a process (console app). But it always seems to be returning empty string. Is there a way to get the command line arguments that were passed to start a process Example: Lets say I opened "notepad" using a file name on the command line. Then I need a way in .NET to get the file name value that was passed to this process. string sProcessName = "notepad" ; foreach( ...Show All

• Visual Studio Team System TFS over Internet - Receive TF31002 Unable To Connect

  I am running TFS in Single Server mode (ATDT on 1 machine) and am using the Workgroup edition that came with my MSDN license. Everything works great when connecting from VS Team Explorer on the server. I can't seem to connect with Team Explorer from my workstation machine. I am trying to connect over the internet, not local LAN. Can someone please point me in the right direction. thanks, Chris Chris ...Show All

• Windows Forms Form Designer Editing Guidelines (C++)

  We're doing a set of programs using Managed C++ and using the forms designer for all of are UI design. The problem I'm running into is I have to go back and add member varibles and other code that I wish to use as well as cl ...Show All

• SQL Server Running access from a vb.net program

  What I'm trying to do is from a vb program open up access the go to the tables section and delete some files then run a macro to copy new data to the file. But I can't get the menu selections to work. Here's my code: Sub GetAccess() Dim mnView As String = "View" Dim mnDesktop As String = "Desktop Objects" Dim mnTables As String = "Tables" Dim pcs As New Process() Const cT ...Show All

• Visual Basic Storing and Retrieving a Class/Structure

  Hi, I wish to create a very large array of a structure of the form: Public Structure FileData    Public FilePath As String    Public DateCreated As Date    Public FileExtension as String End Structure What confuses me is once I have generated the array of my structure, how can I work with it most effectively.  I need to be able to store it to disk and recall it into the structure form ag ...Show All

• Visual Basic Deleting a table adapter left me dead in the water

  I deleted a table adapter that I wasn't using and the result isn't pretty.  I can no longer get into the designer for one of my forms.  The errors I'm seeing are:   One or more errors encountered while loading the designer. The errors are listed below. Some errors can be fixed by rebuilding your project, while others may require code changes. The designer cannot process the code at line 522: Me.DistinctPromoCodeTypeIDTableAdapte ...Show All

• SQL Server Updating Columns - newbie

  Hi All I have to update a existing contacts table with data from a company table, the relationship between the tables is a id number and there is a pivot table in between. My first question ... do i use update or insert I have written the query below and it tells me 4 rows have been updated which is correct as i am using a test database with only 4 companys, but when i check the contact.company_name there is no change insert contact ...Show All