pappascd's Q&A profile

• SQL Server SSIS - OLE DB - IBM DB2 - SQLDUMP - more dumps than works....

  I have a package which access a DB2 database and pulls data from a single table. I can't put a specific event on it, but the package has been causing a dump to occur on a rather regular basis. The really odd part is sometime when I add a data viewer on the output link of the OLE DB Source it works....then it starts to dump again a couple of executions later. There are not date/time values involved in the result set, just character strings. Default code page is set to 1252 and use default page is set to False....any ideas appreciated - this is really starting to drive me nuts! Thanks It is really hard to tell what could be causing these failures. Please report your problems on the connect site wi ...Show All

• .NET Development ADO Recordset Getting Closed in C#

  Hi, I am working with ADO / C# and am encountering a problem where I get an error: "Operation is Not Allowed When Object is Closed", when trying to access a recordset. I am making a stored procedure call ("GetNextCustNo"). The stored procedure updates a key table and then returns the next unique key value. The code below calls the stored procedure. If I change the stored procedure so it doesn't update the table, ie it's a straight select query there is no error in the following code. But as soon as I change the value in the stored procedure via either an update,insert, or delete it seems to close the connection. The same code was working fine in VB. Has any one encountered a similar problem. Thank you. ADODB. C ...Show All

• Visual C++ Lesser evil in linking?

  Hi, I have a native C/C++-program I should compile and link in VS2005. However, the program uses a dll that has been compiled in VS2003 and uses mfc71. So I'll have to include mfc71, which brings to my question, which is the lesser evil 1) Compiling and linking the program with VS2005, with crt8 and mfc71. 2) Compiling and linking the program with VS2005, but with crt71 and mfc71. 1) Works as far as I've tested, but Edit & Continue has this comment: c:\program files\microsoft visual studio 8\vc\include\crtdefs.h(1724) : warning C4656: 'threadlocaleinfostruct' : data type is new or has changed since the latest build, or is defined differently elsewhere 2) Seems to work, if I disable the C++ exceptions, otherwise there are linking erro ...Show All

• SQL Server SQL Server 2000 MSDE

  Hi We have sharepoint installed and as per the developer MSDE was installed by Sharepoint. I don't know much about Sharepoint but I would like to administer the 2 databases created by registering it with Enterprise manager. We have licenses for SQL Server 2000 Standard edition (per processor license). Is it okay for me to register the msde and manage it graphically rather than using osql commands. Thanks.   please be aware, if the operating system installed on that computer will be upgraded to Vista, then MSDE will not be supported. You may need to upgrade the MSDE to SQL Server 2005 Express Edition. See the following page for additional information: http://www.microsoft.com/sql/howtobuy/sql ...Show All

• .NET Development How do you trigger another program or software from an existing C# program?

  Hi, i'm very new to C# programming and i was hoping if someone could help me with this problem. I need to trigger a program/software from my existing C# program using a button but i don't really have an idea of how to go out abt doing this. I think that i'll have to look through the directory of the software in order to trigger it from my program. I hope i'm making sense here. Would really appreciate it if someone could provide some feedback. vannielou wrote: Hey guys, thanks alot! i'll try it out and see if it works. So sorry i have another silly qn to ask. I'm really new to this so plz forgive me! What do i put in the brackets Is it the directory/path of application i want to trigger Yes Com ...Show All

• .NET Development Update a access db's with VB express

  I have an access 2003 db's  but no of the methods of the help index can insert an element to the database. I've tried with data adapters. The dataset of the db's try to update but no can do. help   following the code Dim lect As IDataReader = Me .SistemasDataSet1.CreateDataReader sistemasDataSet.EstadisticasDataTable.Item(1).Rows.Add( "otros" ) 'sistemasdataset.tables("nombretabla o el indice de la tabla).row(i).colum("importe").tostring() + suma Me .EstadisticasTableAdapter.Insert( "joya" , "no ug" , "12 / 12 / 2006" , "tigre" ) other code on other button   Dim dt As New DataTable( "tblDemo" ) Dim coche As DataRow Dim i As Integer Dim j As Int ...Show All

• Windows Forms ContextMenuStrip behavior on a TreeView (repost)

  Reposting after getting Technet subscription set up: In VS2005 (SP1) I want to use a ContextMenuStrip as a context menu on a treeview, and found that doing a contextMenuStrip.Show() doesn't block while in the Show method like contextMenu.Show() does for the older style ContextMenu object. This causes a problem if the user right-clicks a node other than what is currently selected. With the contextMenu.Show(), the right-clicked node shows highlighted while the menu is visible and then again highlights the truly selected node again once a menu item is chosen or the user Escapes. With the contextMenuStrip.Show(), only the truly selected node is highlighted while the context menu is visible, which can confuse the user. Was this change by ...Show All

• Visual Studio @err,hr or its equivalent in 2005

  In older versions of Visual Studio (6 i know for sure , 7 i think) you could put the string @ERR in to a watch window to see the last error (as returned by the function) and you could put ,hr on the end of any HRESULT to get the string equivalent of the error, This was terribly handy. Is there any equivalent in the newerversions of vs Thanks, Eric- Just a note, i am able to put "@err,hr" in my watch window and it seems to work the same as before Are you having problems w/ it. ...Show All

• SQL Server CLR integration - Could not find Type '??' in assembly '??'.

  Hi, I'm new to Integration services and .Net programming but am trying to create a dll that I can access from Sql server 2005. The dll read's an xml file and carries out some processing. I've run the code as an console app and it works fine. I have created the assembly in sqlserver thus: create assembly PinCodeLoader from 'C:\PinCodeLoader\PinCodeLoader\PinCodeLoader\bin\Debug\PinCodeLoader.dll' with permission_set = external_access But when I try to reference the assembly from a stored proc create procedure dbo.interface_processPinCodefile(@filename nvarchar(1024)) as EXTERNAL name PinCodeLoader.PinCodeloader.Main I get the following error: Msg 6505, Level 16, State 1, Procedure interface_processPinCodefile, Line ...Show All

• Gadgets System.Shell.knownFolder/knownFolderPath - do they work?

  Using either knownFolder or knownFolderPath in the following code just produces the error "automation server can't create object". Has anyone managed to use either of these functions successfully <html> <head> <script language="javascript"> try{ var p = System.Shell.knownFolderPath("My Documents"); } catch(err) {System.Debug.outputString(err.name+" - "+err.message)} </script> </head> <body style="width:100px; height:100px; margin:0px;"> </body> </html> Okay, I have a question that might be related to this topic... I am using the code below in a gadget that simply links to My Docs. The problem I am facing is that I have only been able to link the ...Show All

• Visual Studio Express Editions Must I use managed code?

  I'm used to using Visual Studio 5 and 6 at work, and downloaded VC++ 2005 Express to use at home. I also downloaded the Platform SDK. I wrote a simple WinMain function that accessed a third-party COM component, and that seemed to be fine. When I came to add a dialog box, I was faced with lots of unfamiliar code, nothing like the normal Windows stuff I'm used to. Also, when I came to run it in debug, the ourput window showed a managed thread and a native thread. I don't really have time to learn a whole new technology, so can't I just build native Windows code like I'm used to Was the project Win32 or CLR I'm guessing that since you ran into a problem when you added the form (a.k.a CLR/Managed Code), ...Show All

• Visual Studio CRITICAL ERROR INSTALLING SP1 (released) FOR VISUAL STUDIO 2005

  Hi All, I have tried to install released version of SP1 for VS2005 Team System for Software Developer since last night with no success at all. This is the most troublesome for Service Pack, I have ever experienced so far. Now, some of my applications can't be used any more, e.g. VS2005, Windows Live Messenger, VSS, Paint.NET. Can someone from Microsoft or whoever help me Currently I am developing application and is near the target date. As I see in MSDN that SP1 has been released, I believe that released version from Microsoft will be easy to install and since this is SERVICE PACK, not new product. First time I encounter problem due to lack of space. I am quite surprised Service Pack need more than 2GB to install. So I have clea ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XBox 360 controllers for the PC

  Hi, I had a question about controllers that plug into the PC. I understand that only XBox 360 controllers are supported by XNA. I also understand (I think) that wired only controllers work as they need to be plugged into the USB port on the PC. Actually the last point is now not valid since I discovered the wireless controller for Windows and 360. But this isn't available until 2007. Does anyone know if this wireless controller is an actual controller or just a receiver for an existing wireless controller Cheers, Steve Ben Vanik wrote: Maybe the MSFT guys can do some recon on the hardware division and see what their release date is Maybe get Creator Club members a discount :) ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. World to screen conversion.

  Hi. Something weird when trying to covert world to screen coordinates. Vector3 res = Vector3.Transform(worldPoint, Camera.View * Projection); I get the result vector with values greater than 1. Aren't the values post projection supposed to be clamped Both the view and projection matrices are valid (and are used to display on screen). Cheers Hi thanks for the replys, turns out it was working perfectly, however a bug in where i drew the overlayed textures on the screen caused the incorrect positioning. Cheers Steve ...Show All

• Visual Basic Writing a script to close a program

  I am a Network Tech for a small company in Spokane.  We have an spam filter program installed at several clients locations and this program runs a database compact every night at 11.  If the program is open, the compact does not run and the program quits receiving the mail.  I have tried to develop a program that willclose the application, the folowing is the script I am working with: Dim wsh Set wsh = CreateObject("WScript.Shell") wsh.AppActivate "DynaComm i:mail" wsh.SendKeys "%{F4}" This works great if the app is running, but if not, the cmd.exe and Shut Down Windows apps will open and the workstation goes into the 'I'm about to shutdown' mode and quits responding until you manually go in and cancel the Shut Down Wi ...Show All