Jack Robins's Q&A profile
SQL Server SSPI handshake failed with error code 0x80090308
Hi, I am using SQL Server 2005. I got the following error in event viewer. I tried to search on web the solution but failed. Does anyone have idea on that Many thanks :) Log]=Application [EventID]=17806 [Source]=MSSQLSERVER [Time]=02-07-2007 23:35:56 [EventMsg]=SSPI handshake failed with error code 0x80090308 while establishing a connection with integrated security; the connection has been closed. [CLIENT: 202.40.9.176] Hi Satya SKJ, Thanks for your info. It doesn't seem helpful to my case. The kb doesn't explain the cause particular to the error code, and I checked the installation of SQL Server but can't find any problem. Anyway, thanks a lot for your help. ...Show All
Visual C# Global access to arrays
Hi, I am a beginner at C# and am probably trying to run before I can walk! However, I need to build an application which has several Forms. I was brought up on the concept of only writing code once and using it everywhere. So, What I need to be able to do is to: Hold data arrays in one piece of code, say MyData.CS and access it from all of my Forms. Hold pieces of code,( like subs in VB ) which perform specific tasks and which are, again, accessible from all my forms. these may access the API or just do general stuff. I can write the code, but I just can't access it. So far, I have been able to handle single point variables in this way, but I don't seem to be able to do the same with arrays. Also, I can never access my 'g ...Show All
Windows Forms Delete a row programmatically in DataGridView
How can I delete a newly added row with code in a DataGridview I cannot find any delete method in any of the features of the DataGridView. I test for correct data in the _RowValidating event that sets cancel to true. But when the user leaves the row without correcting the value, I set e.cancel = True. But the row is still there with the invalid value in one of the cells. I want to delete the row if the data are not correct and the user navigates away from the row. Can this be done Is RowValidating event the correct place to do the delete How and where should I do it The DataGridView is bound to a binding source which is in turn bound to a datatable. There is no delete method in the binding source and the record does not ex ...Show All
.NET Development Running multiple frameworks...
We are currently developing asp.net applications in the 1.1 framework, but I want to get my company to make the move to 2.0. But our server guys are saying that they have major concerns running 1.1 asp apps along side 2.0 apps. So much so that they think the only way forward is to run the new 2.0 app (which I want to develop) on to a seperate production server. There issue is that if 1.1 apps and 2.0 apps are running together then the servers performance will suffer due to running multiple frameworks. Is there any truth in this I suspect not, but I need to find some more information on the subject ahead of a meeting I will be having with them next week. Can anyone help and shed some light on the matter. ...Show All
SQL Server can a database be made full after 15 entry's
Hello guys I was wondering if it would be possible to make a database full after 15 entry's and how would I go about doing that if it is possible I was given the following code but it seems to be giving me a bit of trouble Dim theSqlCommand as new SqlCommand(" SELECT COUNT( columnName ) FROM tableName ") theSqlCommand.Connection = new SqlConnection( connString ) Dim theNumberOfEntries as new object theNumberOfEntries = 0 theSqlCommand.Connection.Open() SqlDataReader theDataReader = theSqlCommand.ExecuteReader(CommandBehaviour.CloseConnection) if theDataReader.HasRows Then theNumberOfEntries = theDataReader.GetValue(0) End If theSqlCommand.Connection.Close() 'We have retrieved and stored the value of the qu ...Show All
.NET Development .NET Won't Connect to Sql Server
I'm running SQL Server on a remote machine. I can connect to it with no problem using Sql Server Enterprise Manager or Query Analyzer. I recently had to reinstall my operating system and reinstall Visual Studio .NET 2003. Before doing this I was able to connect to the database from within ASP.NET using the same EXACT connection string I'm using now. Since I reinstalled the O/S and .NET, none of my .NET applications that connect to Sql Server can connect. I'm not having any problems with connections to MySQL at all. I'm not having any problems connecting to Sql Server OUTSIDE .NET. I've made the ASPNET user have full control of the entire Framework 1.1 directory and all its subdirectories and files, as well as all directories ...Show All
Visual Studio 2008 (Pre-release) ListView move items up and down
I've got a ListView bound to an observable collection and I am able to move the items in the list programatically moving their index value in the list. But the selection is now a problem because the selection doesn't move with the item. What's the correct way of doing this Thanks Josh. There are a couple of other ways to do this that I thought of (your answer being the most obvious but it smelled wrong to have the MoveUp and MoveDown logic in my presenter and then have some selection logic listBox.SelectedItem = item; in my view. I thought about using the CollectionViewSource in my presenter / viewmodel. I am just trying to find a nice separation of concerns for WPF and finding myself just putting more ...Show All
Visual Studio 2008 (Pre-release) Problems with data binding a ListView to an ADO.NET DataSet
Hi All, I have been using a sample project posted by Beatriz Costa in this blog in order to familiarize myself with data binding to an ADO.NET DataSet: http://www.beacosta.com/2006/03/how-do-i-bind-to-adonet.html One of the things that I'm trying to add to this sample is the ability to do a new Query and re-populate the DataSet with a new set of Data. So I added this method in the code behind which is called from a Button in the XAML file: private void Query( object sender, RoutedEventArgs args) { ds.Clear(); ds.ReadXml( "c:\\example.xml" ); } For testing purposes, the "example.xml" is a dump of the original DataSet. So what I expect to happen after this Query is called, is for the ListV ...Show All
Visual Studio Installation Error.
Can't this company make software that just installs as it should Why am I getting the founding error when installing the trail version of Visual Studio Pro 2005 Error 1406. Could not write value to key \Software\Classes\.xsd\OpenWithList\devenv.exe. Verify that you have sufficient access to that key, or contact your support personnel. All other programs WERE closed and my anti-virus WAS disabled Mike Thanks for that. It is interesting. Have you tried, for testing purposes, to install it on a different user account, such as the "Administrator" account, just to see if that resolves the issue. It could be a corrupted user account or some other issue. Have you tried to un ...Show All
Windows Forms I need to disable default handling of Left & Right keys that move focus
When we have controls on a form, the tab key moves focus from one control to the next. But the Right arrow key moves the focus too (but keeps focus within the same panel). I need to disable the Right arrow key handling, as I need each Left and Right arrow to click their corresponding buttons (to scroll something else to which they are tied). I need the panel and/or form to NOT handle the left and right arrow keys as they do by default (move the focus to the next or previous control in the same panel). I have added 3 new buttons to a form. I have tried to stop the event handling of key presses to not handle these arrow keys. Nothing I've tried works. I tried using the OnKeyPress and OnKeyDown events. I've tried to set the handled propert ...Show All
.NET Development How to fill the objects by the help of xpath navigator
I have an xml file which consists of data which i want's to fill in with my objects Although I am able to load the document but can't able to iterate through all the nodes My xml file is < xml version = " 1.0 " encoding = " utf-8 " > < Exporters > < Exporter > < ExporterName > FirstExporter </ ExporterName > < ExporterFileName > First.xslt </ ExporterFileName > < IsEnabled > True </ IsEnabled > <!-- True || False --> < IsTransFormtionNeeded > True </ IsTransFormtionNeeded > <!-- True || False --> < CopyToFtpNetWorkLocal > F </ CopyToFtpNetWorkLocal > <!-- F for FTP,L for Local,N for Newtowrk - ...Show All
Visual Studio Express Editions Access/Jet DB querry
Hello, XPSP2 VB2005Expr Access/Jet database by code Database columns: Week Amount 1 123.00 1 23.00 1 5.40 2 1234.00 2 5.00 3 23.00 4 .... 4 ... 4 ..... 4 ..... 4 ..... 5 .... Is it possible to display > 1 151.40 (Sums of Amounts of 1s) 2 1239.00 (Sums of Amounts of 2s) 3 23.00 ------------------------------------- 4 --------- -------------------------------------- 5 --------- -------------------------------------- Is there a more efficient method to do this A Loop that increases ColNo and TextBox(Number) Private Sub RetSum(ByVal Table As DataTable) Dim Sum As Single = 0.0 & ...Show All
.NET Development Email relay problem
Hi I am working on a windows application and sending mails through it on some event. This application is being used at mutiple workstations simultaneouly. My problem is that when I send mail through client machine, I got following error: Mailbox unavailable. The server response was: 5.7.1 Unable to relay for user@domain.com My code is as below: Dim MailMsg As New MailMessage( New MailAddress(" from@domain.com "), New MailAddress(" to@domain.com ")) MailMsg.Subject = "My Subject" strMailMsgBody = "My Custom Text MailMsg.Priority = MailPriority.High Dim objSmtpClient As New SmtpClient(vMailServerName, vMailServerPort) objSmtpClient.UseDefaultCredentials = ...Show All
Windows Forms VB.NET - User input ????? Please help
Hi, Can I "filter" the user input and prevent only the insert of numerical caracters and also the decimal separator The textboxs are binded to a DataSet. I don't want the user to insert a specific format... I just want to allow the user to insert a decimal number, but also want to "filter" and garantee a correct input. For example, if the decimal separator is ",", then I shouldn't allow the "." caracter because this will give an error, true Basicly, I want to allow inserting numbers and the decimal separator... What textbox event is more adequate for this function How can I search on the textbox.text for a repeated caracter (ex: decimal separator) and how can i delete one carac ...Show All
SQL Server database trigger question
Hi I am trying to setup a trigger on a database where the trigger fires off a store proc when there is an insert. For some reason, its working on a database in Dev and not on a database in QA. the trigger is on an insert to a table, the trigger looks something like this create trigger XXX after Insert SET XACT_ABORT OFF -- this so that when the proc attached to the trigger fails, insert it anyway exec updatesomething if @@error <> 0 exec createAudit In dev, the row is inserted, but in QA the row is not. I did a trace, both have the SQL:BatchCompleted event of the insert sql statement, but in QA environment, the trace does not have the sql statement after exec updatesomething. it just stops at exec updates ...Show All