genie_'s Q&A profile

• .NET Development disconnect event needed

  I have a situation where a client which receives data from a server at irregular intervals. The server only sends data and cannot receive anything. The client however needs to know when the connection with the server has been lost. In .NET C# is there an event that can be trapped for this purpose. I have searched for a while now and found anything. "if you post an async read on the Socket, the callback is called when the socket connection is closed - sort of an event." True in this case the EndRead will return a 0 byte count. Thanks ;-) ...Show All

• Windows Forms Change the localization language at runtime

  Hi I can update the UI culture of an application at runtime, by changing the CultureInfo.CurrentUICulture to want I want, but that has only effect on the new objects that are manipulated. I would like to know if there is a way to automatically update existing form objects to the new Culture, to have an immediate change on Menus, Menu Items, Labels, etc of my form. thanks ...Show All

• SQL Server OR operator in MDX

  The previous thread on this subject did not answer the question for me. I need to write an mdx query that returns results matching members in dimension A or dimension B. I need to be able to see the resulting members from both A and B. e.g. SELECT {[Measures].[CountofA]} on 0, { nonemptycrossjoin( dimA .AllMembers , dimB.AllMembers) from CubeZ where ({dimA.member)}, {dimB.member}) When I use the where clause, I get a message "...hierarchy has already been used on the Axis1 axis. I appreciate any help I can get. The statement that you built is not equivalent to the one I gave in example. To fix yours, it should be changed to the following: SELECT {[Meas ...Show All

• SQL Server forms in reporting services

  Is there a way to insert forms in reporting services. If so, how would this be done> Andrew, I know that you can't create forms in reporting services, but you can import a form in to the system. Do you know how that would be done. ...Show All

• SQL Server Login failed for user 'Domain\userId'. [CLIENT: <local machine>]

  I have a strange problem. I have installed sql server 2005 w/ SP1 (developer version) in my local. After the installation the event log shows the following error message: 2006-10-25 01:25:27.59 spid9s Clearing tempdb database. 2006-10-25 01:25:27.89 Logon Error: 18456, Severity: 14, State: 16. 2006-10-25 01:25:27.89 Logon Login failed for user 'Domain\userid'. [CLIENT: <local machine>] 2006-10-25 01:25:28.09 spid12s Starting up database 'msdb'. (Obviousely, I have removed my id for security reasons) The real problem is that I couldn't connect to local or any remote servers using my Sql Server Management Studio . I have spent a lot of time on the forum(s) to find an answer, but seems to me that it is an "unknown" ...Show All

• SQL Server Reset password

  How does one use SMO to reset a login password Thanks.. Server s = new Server ( "." ); Login l = s.Logins[ "Jens" ]; l.ChangePassword( "OldPassword" , "NewPassword" ); //Or the short one new Server ( "." ).Logins[ "Jens" ].ChangePassword( "OldPassword" , "NewPassword" ); HTH; Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• SQL Server No cubes can be found error

  In the data panel of the report designer component, every time I try to create or modify an MDX statement, I'm now getting a "No cubes can be found. (Microsoft.AnalysisServices.Controls)" error. Works fine on the Layout and Preview tabs. Just all of a sudden appeared. Working fine against relational sources. As a warning to all, Reporting Services and Analysis Services is definitely not a marriage made in heaven. Proceed with caution. I'm going to have to learn to delete my profile everytime something strange happens with SQL 2005. Somehow, my profile on my primary development machine was corrupted again. ...Show All

• Visual Studio 2008 (Pre-release) how to show page title in navbar?

  WPF browserlike app. I'd like to show the Title of the current Page in the Navigation Chrome of the NavigationWindow. But how I guess I need to provide a new ControlTemplate for the NavigationWindow, which is no problem, but I got no idea how to bind the Title of the current Page to a Textblock. < TextBlock Text = " {TemplateBinding NavigationWindow.Content.Title} " /> in the new NavigationWindow ControlTemplate does not even compile :( Thanks, Sam Where in my ControlTemplate for the NavigationWindow do I give the Page a name My Template looks like this: < Style TargetType = " {x:Type NavigationWindow} " > < Setter Property = " Tem ...Show All

• Windows Forms How to share an object instance through all forms just like vs6.0's global variables?

  Now I am doing a c#.net 2005 database project.At the begining, I want to design a login form and after user successfully logon, I will store its account and something else such as Sales Month selected. But I found that c# is purely object oriented language and there is no gloabl varialbe. I wonder how to do this. I have been used to web design and this is my first real winform project(Before only some simple projects). So there are many questions during my design. Another problems: After I new a child window in its Mdi parent, I want to transfer some information to the child, how can I do Now I am trying to define some members and methods to manipulate them in the child form, and so I can invoke the mothods to transf ...Show All

• Windows Forms VB2005 Add system Date to new record in Datagridview new

  Hello, When I push the add button a new row is added to my datagridview. How can I automatically insert the system date in the new row in the column 'Date' I hope to hear from you guys... It's not exactly code... go to your DataTable design, highlight the field you want to put the date in, and enter "=Now()" in its DefaultValue property. EDIT - This won't work.  I think the reply refers to the column setting of the DataGridView. ...Show All

• Software Development for Windows Vista Transaction Scope with datatable updates

  I have a VB windows app using a dataset with multiple datatables and a datagridview for the UI. Okay. I have the datatable. updates and inserts and deletes working. Now, I just want to wrap the calls to the different table updates/inserts/deletes in a single transaction so I can manage the errors and roll it all back. Is TransactionScope an option for me Using .net 2.0, VB 2005, ... I tried to add the System.transaction but it doesn't seem to know it. "Imports System.Transactions" ... does not load or find it. Is this just a stupid syntax or basic know-how that I'm missing I see SQLClient.SQLTransaction and I found an article that says I need to create a new transaction, ... it used OleDbTransaction = cn.BeginTran ...Show All

• .NET Development About SmtpMail.Send() Method

  Hi all, This is Hari, In my application I need to generate a report for different people and send it through mail as attachment, and my approach to this task is I will generate a report for single person ,And send it to his Mail ID and then I will delete the report and generates next person’s report and send it. To send the report I am using SMTP server. I am able to send the mails if all the mail ids are correct, if the mail id of a person is incorrect in between I am able to handle the exception but I am not able to delete the report of that person the error I am getting is "Internal system error. Access to the path.... "Even I am not able to delete the file manually .How can I come out of this plea ...Show All

• Visual Basic Stupid question....How do I instantiate a form from another form?

  I'm very new to vb.net. Just wondering how I can start up another form from another form's button. Thanks, and sorry for the newbie quiestion. You just must declare a new form variable and call to the .Show() method ;) Form2 MyNewForm = new Form2(); MyNewForm.Show();   Regards. PD: I'm sorry, i don't seen that this is a VB.NET forum, but i think that you understand the replie :) ...Show All

• SQL Server Database Mail SQL 2005

  I'm having a problem with database mail in SQL Server 2005. I have set up a default profile. My SMTP server is not a localhost instead i've fed SMTP ip address and port no. The same setting in Outlook express works fine for Incoming and outgoing mails. but in SQL 2005 i'm not able to send test emails. The following errors show up in the sql server agent log Message The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2006-06-13T10:47:27). Exception Message: Could not connect to mail server. (An established connection was aborted by the software in your host machine). ) Please help me out.... Hi, I would use something like ...Show All

• SQL Server SSIS Higher Level Edition error when run in a Sql Job

  Hi, I am receiving the following error in Sql Job agent when I try to run an SSIS package : The task "Create Excel File" cannot run on this edition of Integration Services. It requires a higher level edition. It then goes on to tell me : The Execution method succeeded, but the number of errors raised (2) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. I have tried reseting the error count to allow for the "errors" , but it stills fails. The job suceeds in Visual Studio, but not when scheduled in Sql Management Studio. Any suggestions Thanks, J. In regards to the blog post, I believe that is ...Show All