alex777's Q&A profile

• SQL Server SQL queries time out during backup

  Hello, I am new to the forum and hopefully someone can help me with the problem I have. Lately, I noticed that my sql statements are timing out during the time SQL server is running backup job. The errors I am seeing in the log are: Process 59:0 (724) UMS Context 0x06403BC0 appears to be non-yielding on Scheduler 1. Error: 17883, Severity: 1, State: 0 I am running SQL Server 2000, Enterprise (SP4) I believe this problem should have been fixed in SP3a. I even tried rolling back to SP3a, but still experience the same problem. Does anyone else have experienced this issue Thanks. We have 12 or more 17883s fixed post SP4. Review the following, it should help . http://down ...Show All

• SQL Server SQL 2000 view 50 percent slower in SQL 2005 ....Why or Why ?

  Hi, this view which is actually stright forward is running 50 slower on SQL2005 as oppose to SQL 2000...Any thought as to why.... Thank you in advance.... CREATE VIEW gltrx AS SELECT timestamp, journal_type, journal_ctrl_num, journal_description, date_entered, date_applied, recurring_flag, repeating_flag, reversing_flag, hold_flag, posted_flag, date_posted, source_batch_code, batch_code, type_flag, intercompany_flag, company_code, app_id, home_cur_code, document_1, trx_type, user_id, source_company_code, process_group_num, oper_cur_code, org_id, interbranch_flag FROM gltrx_all WHERE dbo.sm_organization_access_fn(org_id) =1 AND (dbo.sm_access_to_gltrxdet_fn ( journal_ctrl_num, trx_type) =1 OR posted_flag = 1 ) 2005 has had ...Show All

• Visual Basic Timeout on first load with SQL Express

  I have an application that on the first boot, almost all the time, it will give a timeout error for the database. Has anybody else had this problem, and is it possible to fix Thanks! can you show us some code it could be anti virus software kicking in or even the firewall blocking the port....any chance of disabling them to see what happens Can you also post the code Where is the SQL Server express you are connecting to ...Show All

• .NET Development TextBox new value disappears

  hello all, I am trying to update records again a certain user. when the user goes on the Update.aspx page, two Textboxs ( txtnewFname, txtnewLname) are filled with the data for that particuler user using a query(SQL Server). Now the user chanes his/her firstname and last name and clicks on Update button. But the old values loaded by the query are again sent to the database and not the modified values. Why does it so happen Anybody please help me! Here is my code: //Page Load Event Private Sub Page_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load 'Put user code to initialize the page here btnsubmit.Attributes.Add("OnClick", "return Che ...Show All

• .NET Development access to an excel file

  Hello, I would read data from a excel file in 2.0 .net application. How would I proceed I think I should create an ODBC data Source but I don't know how to reuse it from my aplication someone help me. I have written 3 tutorials on how to read and write excel spreadsheets using ADO.NET: Reading and Writing Excel Spreadsheets / Worksheets Using ADO.NET C# DbProviderFactory Import / Export Excel Spreadsheet Data into SQL Server Database Table Using SqlBulkCopy Reading Excel Worksheet and Column Schema Information Using ADO.NET 2.0 and GetSchema Regards, Dave ...Show All

• Windows Forms Automatic update of label text bound to a class property updated by another thread

  Hi, I'm having troubles with a data binding between a label text and a class property. I have a class like this: public ref class TestClass : public INotifyPropertyChanged { public: virtual event PropertyChangedEventHandler ^PropertyChanged { void add(PropertyChangedEventHandler^ value) { this->propertyChanged += value; } void remove(PropertyChangedEventHandler^ value) { this->propertyChanged -= value; } }; virtual void NotifyPropertyChanged(String ^info) override { propertyChanged(this, gcnew PropertyChangedEventArgs(info)); }; property unsigned int ToW { void set(unsigned int tow_){ tow = tow_; NotifyPropertyChanged("ToW"); } unsigned int get() { return tow; } }; private: unsigned int tow; event Pr ...Show All

• Visual C# Error in calling a method

  Dear all good day i ve 1 question, i make a function that open a form from another the method is as follows public static void DisplayForm( Form targetForm) { targetForm.Show(targetForm); } instead the classic way Form2 frm = new Form2(); frm.Show(); it have one parameter and it has from data type, when i call this function it fire the following error DisplayForm( Form2 ); 'Form2' is a 'type' but is used like a 'variable’ kindly instruct thanks all The error is correct. You COULD do this: DisplayForm(new Form2) but to be honest, I can't see any use in having this method at all. Apart from anything else, you call a method that just calls another method, ...Show All

• Connected Services Framework CSF2.5 - Session memory overflow problems

  We're using csf 2.5 session clustered active-passive; our session has 4 worker processes with a recycle of each process every 1740 minutes; when we have put in production this platform, everything has worked very well, but now we're finding any errors: - Session application's current memory consumption has moved up over first warning level. GetSessionIds and GetActiveSessions will be not accepted at this time. -Failed to send ReadMaps to the following participant: .... Error: The underlying connection was closed: An unexpected error occurred on a send. The total memory allocated for the worker processes is 2 GB, and often taken place overflow memory phenomena. Have you got any suggestions Thanks, Ale. ...Show All

• Windows Forms Graphics are being erased by other windows or off screen movement...

  I have am working on a program that monitors the download speed of ones internet connection and draws the speed to a graph. The graph is a simple line graph that is drawn using GDI+. The graph is updated in the WebClients DownloadProgressChangedEventHandler. The problem is that when I move a window or move the program off screen, the graph, or the portion that was covered or went off screen gets erased. I have tried doing gc->Save(); (gc=my graphics) but that has not done anything for me. Here is my entire code: (Note that the timer tick event, "UpdateGraph" doesn't do anything, that is fine) #pragma once namespace iDT { using namespace System; using namespace System::ComponentModel; using namespace System::Collections; using names ...Show All

• Visual Basic ActiveX EXE projects in .NET

  We have a VB6 app that we've used the upgrade tool to upgrade to .NET. The original VB6 project was an ActiveX EXE, with windows forms as the primary code components. This proejct is not working since we've updated it to VB.NET - the EXE is not available to be called through COM as a COM object, nor is it being registered in the registry. What do I need to do to my project so that it runs the Windows Forms that I need (with the code in them) and yet still be able to call it through COM from other applications I've seen the references to using the COM Class template, yet i'm not sure how to integrate it into my application with Windows Forms in it. Thanks for any help you can provide! Yes, I didn't realize this was an app ...Show All

• SQL Server Passing parameter values from web form

  I am sure this has been asked and answered many times, but I am not clear on what I need to do. I have a server report that accepts two paramenters: NAME1 and BKDT. When the user selects an item on the data grid, I want to pass those two values to the report and display the report. How do I pass these two values to the server report Thanks for the information. Thanks for the response. I decided to go with a local report, however I still would like to know how to do this. Can I get to the report parameters directly Would it be something like me.reportviewer1.serverreport.setparameters Or am I missing something ...Show All

• Visual Basic Problems in using unmanaged VB6 API in VB.net~~

  Hi, experts Currently I am working on a client-server application which I need to implement a 3rd party unmanaged VB6 API dll into a .net project. The only thing I know about this API is the functions it has and I know it doesn't wrap up by a class. Therefore, I am trying to write a wrapper class in .net so I can put it on the server for my application. Can anyone show me some hints for how to do it If it is possible, may you give me a simple example >_< Moreover, the parameter the function is passing is VB6 type, so I believe I have to define a structure in VB.NET. But I am having difficulty when I am trying to rewrite the following code. Type Record Name As String * 60 Sls(1 To 4) As String * ...Show All

• Visual Studio Team System Newbie: editing a branch

  I have a project A which I branched to B. Now I have to edit some files in B (the branch). I can do it in the Source Control, but changes are not "introduced" to the solution so I cannot compile and test. All documents I have read edit this way, but never compile!! What am I missing Which would be the best way to accomplish Another solution pointing to the phisical branch It looses source control. Many thanks I would suggest that after you take branch B, make sure you commit the branch. Then open up the solution (from branch B) and edit it as you normally would. You can then merge it back to your original branch if thats something you plan on doing,. ...Show All

• Audio and Video Development how do I marshall custom interface across the PE boundary?

  If I implement a custom interface in a filter and the filter works under the protected environment, how do I marshall the interface to be used by application What are other ways to communicate to the application from inside the protected environment Yes, I am implementing a MFT (video decoder). The decoder needs to send some userdata to application during playback. The application may need to configure the MFT during playback as well. ...Show All

• Visual Studio 2008 (Pre-release) Can't see ComboBox Items bound to XmlDataProvider

  I have a ComboBox bound to an XmlDataProvider. The drop down looks like it has all the rows but the items aren't visible. Can anyone help me with this <XmlDataProvider x:Key="CodeTableCache" XPath="/perform_batch_result"> <x:XData> <perform_batch_result> <tabular_select_result result_name="req_status"> <row> <attr> <name>req_status.occurrence_type</name> <value>R</value> </attr> <attr> <name>req_status.req_status</name> <value>TEST4</value> </attr> </row> </tabular_select_result> </perform_batch_result> </x:XData> </X ...Show All