Ken_Bussell's Q&A profile

• SQL Server maintenance plan stops with a xpstar.dll is missing msg

  Hi, I used to have a maintenance plan for my database, I just realized that the backup wasn't taken for more than 2 weeks . and when ever i try to view the Jobs or the maintenance plan i get this error msg : cannot load the DLL xpstar.dll, reason126:(the specified moudle could not be found). I looked under the Bin directory and couldn't find the xpstar.dll file and i'm sure i didn't delete it .so what should i do could i just copy paste the file or i need to reinstall the SQL Can you check whether SQLAgent has been started correctly, also confirm what account has been used to start SQLAgent service. It seems the XPSTAR.DLL is missing and try to find the file from any other location in the server ...Show All

• Visual Studio Exception occured on closing Report Viewer

  Hi, I have a problem that if I close report viewer before it has displayed data completely, it throws an exception that "<Application.exe> has encountered a problem and needs to close.". Also asks to send report to Microsoft. I have used Try-Catch block, but it is still thrown. Please help me on this. This is a known bug in the viewer control. You can work around the problem by adding the following code to the FormClosing event: ReportViewer.CancelRendering(System.Threading.Timeout.Infinite); ...Show All

• Visual C++ winuser.h error

  Everytime i try to include winuser.h i get this: C:\Program\Microsoft Visual Studio 8\VC\PlatformSDK\include\winuser.h(42) : error C2146: syntax error : missing ';' before identifier 'HDWP' C:\Program\Microsoft Visual Studio 8\VC\PlatformSDK\include\winuser.h(42) : error C4430: missing type specifier - int assumed. Note: C++ does not support default-int C:\Program\Microsoft Visual Studio 8\VC\PlatformSDK\include\winuser.h(42) : error C4430: missing type specifier - int assumed. Note: C++ does not support default-int C:\Program\Microsoft Visual Studio 8\VC\PlatformSDK\include\winuser.h(43) : error C2146: syntax error : missing ';' before identifier 'MENUTEMPLATEA' C:\Program\Microsoft Visual Studio 8\VC\PlatformSDK\include\w ...Show All

• Visual Studio Express Editions the transaction manager has disabled its support for remotenetwork transactions.

  Hi pal's... I had developed application in C#.Net1.1 Version1.1.4322 in windows2000. The application is executing fine when i installed and runned in same OS. But i am facing mentioned problem when running in WindowsXP-version2002-Service Pack2. the transaction manager has disabled its support for remotenetwork transactions. Our archetecture as follows: -MS-SQLserver2000Database running in different system of Windows2000. We are connecting to the system through LAN. -Our .Net application is also running on Windows2000 with com+ service -SetUp package is built on Windows2000. ===========following exeception Occred====== See the end of this message for details on invoking just-in-time (JIT) debugging instead of th ...Show All

• Visual C++ how to copy all elements of a 2d array to another 2d array?

  I just know the copyTo function is only suitable for 1-d array . But how about 2-d array is there any faster and easier method that can copy all elements to another 2d array without using any loops to go through each elements thanks!! I guess you mean to use memcpy to copy the massive of memory space for a 2-d array to another memory space that has already allocated correctlly. For example: int a[2][5],b[2][5]; for ( int i=0;i<2;i++) for ( int j=0;j<5;j++) a [j] = i+j; memcpy(b,a, sizeof (a) ); // This will copy entire a to b Be careful that b has been allocated with enough space. Is this what you want regards, rico ...Show All

• Windows Forms Bug in VS.NET 2003?

  Ok I had some time to make a sample project to demonstrate what I feel is a bug. Either that or I am doing something wrong here. http://www.myshack.net/fotty/VSBugSLN.zip Here is a link to a simple windows form app project and class library project (both part of same solution) Zip contains only the uncompiled project files. the class library contains 1 class which extends to textbox class (just makes the font red, this is just to illustrate the fact that its a class inheriting from a control) the windows forms app contains just 1 form, and references the class library project. Open the project, and compile it in debug mode prior to viewing form1. This is because the class library DLL needs to be compiled before it can be used on the fo ...Show All

• SQL Server Missing records when using Lookup

  Hello, I am using SQL 2005 Integration Services and have a package created which selects data from a table on a remote database server to insert into a database on my local machine. I have a couple of lookups to get foreign key values for the insert. When I run this, it runs successfully but I notice I am missing rows when I check in the db. If I run the query from the data source straight in query analyzer, I receive the correct amount of rows but running the packing in etl does not insert the correct amount. There are no errors raised. I removed the lookups from the package and created joins in the data source query to join on the remote tables using a linked server. This then inserted the correct amount of rows. As a test, I added ...Show All

• Windows Forms Datagridview ColumnCurrency cell

  Hey everyone, Being a relatively new person to C# and .Net Forms in particular, I'm probably about to ask a neophyte question, and therefore apologize in advance if this is the case. That being said, I'm seeing strange behavior in my DataGridView component. One of the cells is formatted as a CurrencyColumn. In this column, when a user input a value using the keypad, the cell doesn't recognize the period on the keypad. However, the cell DOES recognize the period on the main keyboard. Is this normal behavior I'm sure there's something simple I'm overlooking, but I can't seem to find it. Thank you for your advice, Fletch ...Show All

• SQL Server Script Task debug error

  Good afternoon - Info: Microsoft SQL Server Management Studio 9.00.1399.00 Microsoft Analysis Services Client Tools 2005.090.1399.00 Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158) Microsoft MSXML 2.6 3.0 4.0 5.0 6.0 Microsoft Internet Explorer 6.0.2900.2180 Microsoft .NET Framework 2.0.50727.42 Operating System 5.1.2600 I am trying to debug a script task within a SSIS package by setting a breakpoint within the design window of teh script taks and I get the following error: EventType : clr20r3 P1 : dtattach.exe P2 : 9.0.242.0 P3 : 434f5e26 P4 : microsoft.sqlserver.scripttask P5 : 9.0.242.0 P6 : 434f5e02 P7 : 4f P8 : 0 P9 : pszqoadhx1u5zahbhohghldgiy4qixhx Oth ...Show All

• SQL Server Error message: Error 0x800706BE while loading package file "D:\Packages\Tora\dSales.dtsx". The remote procedure call failed.

  Hello, I have a bundling package that runs about 20 other packages. It has been working fine for a while but a couple of days ago it fail with the following message, Error 0x800706BE while loading package file "D:\Packages\Tora\dSales.dtsx". The remote procedure call failed. I’m running the SSIS packages in an 64-bit environment. Thankful for help with this! //Patrick How are you running that package: BIDS, SQL Server Agent, dtexec Make sure nothing has changed in the environment, like permissions to get access to the dtsx files, changes in the location of the files, privileges of the account executing the package, etc ...Show All

• SQL Server How to determine the last time a table was accessed ?

  I'm trying to do some housekeeping. I want to delete user tables from database(s) that have not had any activity... I cannot seem to find a mechanism for accomplishing this. sysobjects only shows the createdate, not the last time a user table had a SELECT, INSERT, UPDATE or DELETE operation performed on it. Anyone know how to do this Thanks (P.S. this is the second posting of this question today, as I went to my threads and I do not see the original post - sorry for the duplicate, but as I say, I do not see the original so am re-posting). randyvol Satya - First and foremost thank you for your reply. Next - what !! WOW! I just naturally assumed that SQL Server would do this. I ca ...Show All

• SQL Server Thanks Siva

  Thans Siva, After long time i viewed ur comment.I had left that project due to internal reasons. i have again come into that project.it is working....but data is not populating...only pivot table is coming onto client browsers.Thanks SivaSatyanand ...Show All

• Architecture Using Object Relation Mapping Tools

  I am planning to use Object Relation mapping tool in our project, presently we zeroed on Nhibernate. Just before implementing i want to seek advice on the below points Any cons of using OR mapping tools Any known issues Any performance issues TIA, Sudheer. You can also take a look at a paper I wrote on O/R mapping pros and cons http://www.rgoarchitects.com/blog/content/binary/ORMappin.pdf   ...Show All

• Smart Device Development Background Key Press Listener

  Hi again, I just wrote this, and it dissapeared, so I'll write it again and hoepfully it won't turn into a double thread. I basically want to my program sitting in the background doing it's own thing, or just idling about, and be able to press a key and have this key jump to a function (or perform some action) in my background program. I've looked at RegisterHotKey, but from what I understand, this just puts a message into the message stack. I would rather jump to a function without having to contanstly check the stack. Even something that triggers when the message stack is added to is fine. I basically want a Java type ActionListener. Anyone have any ideas or direction It'd be VERY appreciated... I'm ripping my hair out over ...Show All

• Windows Forms displaying pictures from textboxes

  how would i display a picture that corisponeds to the textbox entry ex. if you enter apple it would display a picture of an apple edit:  in vb On (for example) TextBox1 KeyPress event: { if (e.KeyChar == '\r') { // when you press enter key LoadImagePicture(TextBox1.Text); TextBox1.Text=string.Empty; } } private void LoadImagePicture(string picture) { switch(picture) { case "apple": pictureBox1.Load("C:\\Documents and Settings\\admin\\Escritorio\\Proyectos .NET\\C#\\Images\\est.gif"); break; [... etc .. etc.. etc.. ] } } Regards. ...Show All