Sometimes my MySQL-commands hangs forever without throwing any exception. I've tried setting both command- and connection timeout for my connector, but it still hangs sometimes.Does it exist some kind of timeout block? Like, if the command hasn't been executed within X seconds, then continue.
View 2 Replies
provide an example of a client server app using the System.Net.Sockets class that:
(a) supports multiple client connections
(b) that implements some sort of command-response timeout feature (by that I mean, once a client connects the server sends the client a message [e.g. Message A] and waits without blocking communication with other clients for a response. If a response is not received within a defined period it tries again perhaps and if there is still no response then it disconnects the client. If a response is received then it sends another message [e.g. Message B] and so on....Whilst this is going on the server must be able to accept connections from other clients).
If anybody has done something like this before and is willing to share their knowledge I'd be grateful. I've been trying for ages to get the timeout feature working correctly to no avail. I haven't posted what I have already because frankly it's a mess. I tried an ArrayList of timers (one for each client) that I started and stopped as messages were sent and received, but the timer elapsed event kept firing after I thought it should have stopped which may have something to do with the various threads involved with the asychronous communication I was trying to use (I really dont know).
It's really the server end that I'm having problems with because the client app only has to deal with messages coming from a single source. At this stage I don't care if it's done using synchronous or asychronous communication. I've trawled the web for every example I can find and but I can't find one that implements this kind of command-response timeout with multiple clients - i.e. most of them just show how to listen out (server) and connect (client) and how to send a message, i.e. there's no sequence of messages or timeouts.
I am having a problem with a SQL server query giving a timeout error. I read about setting the timeout value of the command object but in my DAL, I do not see how to do that. Here is how I create the command object
Public Sub Init()
If ConnString = "" Then
Select Case ConnStringID
[Code]....
How can i check if a value exists in mysql lets say if user: "Nick" exists."SELECT CHECKIFEXISTS (Value) FROM..." ???
View 3 RepliesI'm not sure if this is a VB.NET error or SQL Server. But I get the above error with following stack trace:
[SqlException (0x80131904): Timeout
expired. The timeout period elapsed
prior to completion of the operation
or the server is not responding.]
System.Data.SqlClient.SqlConnection.OnError(SqlException
[code]....
I am working with synchronizing 2 databases (SQL Express and SQL Compact Edition) using VS 2010. It works fine when the program first running. However the SQL Command "Timeout expired" Exception occurred when the code has been executed for several times. The error message is:
[Code]...
I found the following code on another site that works great for what I need. Is there any way I can add a timeout in this code? I can't figure how to do it.
[Code]...
I have a routine that will connect to a tcp server and then disconnect which works perfect. It checks the connection to another program on another pc which is what I need. But if the computer is not on or the ip address is not valid, it takes a bit for it to time out and continue on.
how to add a timeout of 2 seconds to the following code?
Private Function CheckServer(ByVal IP2 As String, ByVal Port2 As Integer) As Boolean
CheckServer = False
[Code]...
I have a Windows Service that is behaving strangely on Windows 2003 systems (works fine on XP, Win7). If the service is started manually within the OS, then everything is fine. However, if the system is rebooted (with the service set to Automatic startup), then an "At least one service or driver failed during system startup" dialog is generated once the boot completes. If I check the event log, there is an event 7022 with the following text:
[Code]...
VS 2008
I am not sure how much work there is to inheriting from the web client class.
Currently I am using it in my project. And I can't change to anything else. The customer would like to have a timeout after a certain period of time. The web client doesn't have this.
So rather than re-invent the wheel, I am thinking of inheriting from the web client and adding this property.
I use a downloadstring (instance.downloadstring) with instance as the'System.Net.WebClient'.
View 1 RepliesBoth of these properties have a default value of 30 seconds but I am setting them to something much shorter (8) and my application does not seem to recognize the timeout. Even if I allow the default value of 30 seconds to elapse I still am waiting on the timeout. I am trying to use the connecttimeout to notify my client application that the remote sql server is not available before I try and execute a sql transaction.
I am not sure why this is not working though, the sqlexception for timing out has worked for me before and all I did was set a non-default property. The only change here is that this is a MDI type of project, which shouldn't matter.
[Code]...
I caused the VB.NET2008 IDE to do something extremely odd and unintentional with some code I was writing. As some of you know, I mostly write programs for industrial equipment. On one of our products, I needed to make certain forms automatically close after a timeout period. To do this, I began programming a usercontrol with a Timer on it (interval = 1000) and a ProgressBar. Timer.Enabled was set to the Enabled event so I could toggle it. When the control counted to it's timeout period, it would call Me.ParentForm.Close
So I build my project, and drop it on a form in the IDE and I see it begins counting! Huh... I had no idea timers were active in the IDE. I wonder what happens when it hit's it's trigger? I figure probably nothing since Me.ParentForm was actually the designer. When it triggered, the whole IDE crashes without save. I tried it twice now. Here's my
[Code]...
im doing a login i have finish it but you can close it by using alt+f4 so i need to block the alt key im using vb 2008
View 2 RepliesI'm making a program but I don't want people to abuse it, it loads a site and then refreshes it. People can abuse this by getting views for a game and what-not. What code can I use so that the webbrowser only loads the homepage and not some thing like
View 4 RepliesIs it possible to use VB to see if a certain URL exists. For example see if [URL]
View 3 RepliesI have a block of code in an application I have written. I have tried two different variations.Below are examples of the method I used: [code]
The second example adds only three more lines of code. Yet, the app would run at about 10% of the speed as it would in the first sample.
How can i make the computer to block while the user is doing a save to the application i'm building?
View 5 RepliesI have this block of code that splits txt/csv files. It is working just fine but its a but "ghetto"
[Code]...
I want to create a block list for my web browser project. I want to create a listbox that the user can add websites to then when the web browser is ran on the main page if the web browser try's to connect to a web page that's in the list box it will be redirected? I've tried using this code :
[Code]....
When I exclude a block using #if #endif in VB.Net there is no visual evidence that the block has actually been excluded unless I indent the block and it does not return to the left margin. I checked the active settings for Fonts and the Excluded Code colorization is identical to that of C# and C++. However, the block is not colorized at all. VB clearly knows the block has been excluded, but I cannot figure out how to get the block highlighted as it is in C# and C++.
View 3 RepliesDo both of these algorithm work only with a 128bit size block size?
View 3 RepliesI've created the following function and thrown it inside of a timer:
[code]...
It works, but it keeps trying to open media player for each process it looks like. I need to continuously run the function so that Media Player opens when it's closed.how to make sure it opens only once when the process doesn't exist?
Controls: textbox, combobox and button
I want to have a condition to find out if the value I enter in the textbox exists in the combobox. The combobox reads a text file.
I am filling a listview control with a big number of items but i came across an problem, the repeated values. In those items i use .Text and .Tag so i can relate some hidden values per item. I have been trying to use the items.find() with no luck since it looks like to search for keys, which i don't really have. Every item has different .Tag values but it can happens that they have the same .Text Is there any way to remove or just not add items based on a .Text search in the ListView?
View 13 RepliesIm just trying to determine if a website exists when i navigate my webbrowser. via messagebox.Ive tried this so far but it wont work:
Private Sub WebBrowser1_DocumentCompleted(ByVal sender As System.Object, ByVal e As System.Windows.Forms.WebBrowserDocumentCompletedEventArgs) Handles WebBrowser1.DocumentCompleted
If WebBrowser1.DocumentText.Contains("Action canceled") Then
[code]....
I am using VS 2008 and MySQL. Which one of the following methods is efficient or a proper one to check if record exists or not before making an attempt to insert.
1. HasRows Property.
2. Select Where Exists
3. Select Count(*)
Or if there is any other appropriate method ( which i am not aware of ) available to do it in vb.net ?
I'm checking is a file exists as follows.
If txtGradeObs.Text = "" Or Dir(txtGradeObs.Text) = "" Then
MsgBox("Specify the Grade job of Obstructions", vbExclamation, MsgBoxTitle)
Exit Sub
End If
I get an error if the drive does not exist - i.e. G: rather than C:. It used to work in VB6. How can I get it to work.
I am trying to create a function that will determine if a worksheet within the active workbook exits. I have searched many web sites without any luck. Here is the coding I have currently:
HTML
Function SheetExists(ByVal sheetname As String) As Boolean
Dim oWorkbook As Excel.Workbooks
[Code]....
It errors out at Dim oWorksheet As Excel.Worksheet = oWorkbook.Sheets(sheetname).
The error message I am getting is "Object variable or With block variable not set."
At the moment when a user logs into my system it checks to see if a job exists, if so the records are put into a datagridview. However, if there are no jobs in the database I get an error.
[Code]...
