have this sql connection functionin a class
Class con1
Public Function ConnectToSql() As SqlConnection
Dim conn As New SqlClient.SqlConnection
conn = New SqlConnection("data source=" & Server & ";" & _
[code]....
What's the easiest way to check ADO.Net connection is working? my mssql database is on another pc.
View 3 RepliesI have an VB.NET application. This Application is permanently resident in memory and minimized to the tray area because we use it very often. The problem comes in when we VPN into a client's site. These VPN connections trash all other network connections to and from our machines.Then every time my VB.NET application refreshes its database, errors start occurring, because the machine has lost connectivity to the SQL server, however, these are not at the connection level, but only when the reader attempts to read.
I am checking for connection.open, but because of the SQL connection pooling, I just get a previous connection that was valid before the network was cut. Is there anyway to check if an actual SQL connection is valid, prior to re-issuing a connection from the pool?[code]...
I need to check whether If the Internet Connection Is available or not
If My.Computer.Network.IsAvailable = True Then
Return My.Computer.Network.Ping("8.8.8.8")
Else
Return False
End If
Above code returns Whether the PC connected to the internet, But I can't Check It through out the Software, I am only Having Single Form.
I made program which connects sql database via WiFi network. I have timer wich every 10 minutes updates textbox information from database. If Network connection will be lose, i do not whant to get any error and after that lose data wich is in textbox, until sql database connection will not be. How can i check if connection exists and after that update data from database? Something like that:
Conn = New SqlConnection(ConnectionString)
Conn.Open() ' if connection is lost there gets error
If Conn.State = ConnectionState.Open Then ' But this does not works
[Code].....
Im trying to check my internet connection using just a button how do i do that?
View 2 RepliesI'm writing a Silverlight 4 application and would like to check when opening the installed out of browser application, whether there is a valid internet connection (to then download some data from my website). I realise that I could put a try catch around a WebRequest but that seems a bit hacky to me.
EDIT: What I meant by valid internet connection is just connected to the internet
How I can check if the internet connection is working or not? i have to check every few seconds without getting stuck.
View 9 RepliesThis is the work of one responder for the most part, and is not indicative of the quality of most of the posts.But you can judge that for yourself.
If you are writing a program that is used to monitor the status of your network, then this thread may not be of interest.
If you are an application programmer that uses network resources to accomplish your goal, i.e. you are using SMTP, FTP, HTTP, NNTP, NTP etc., and you think that you need to check for a connection first, then read on.Follow up to this.Before getting all geeky let's take a little detour...
Five days a week I get up, eat breakfast, check my email, forums, etc., take a shower, get dressed, and then drive to school.Many of you probably have a similar routine.What is interesting about that is not what we do, but what we dont do,because of our expectations and experience.Here is what I dont do.
I dont stick my finger in the electrical socket to see if there is electricity for the coffee maker and toaster.I dont fire up the command prompt and ping some host on the internet to see if I have connectivity.I dont check the battery, tires, water level, clutch fluid level, washer fluid level, etc.,before I drive off.
All of that is based on expectation and experience.So why would you write an application that pings the internet before it did something (SMTP, FTP, HTTP, NNTP, NTP etc)???? Is your experience or expectation that the network will be down?To illustrate and hopefully convince you that, like Oblio, it is pointless, create a new form with three buttons. In the following examples I use a WebRequest / WebResponse as my 'Something'.Here is what some think is a good approach, the classic ping-then-do, what I think you shouldn't do.[code]....What is wrong with this code is that all of the network IO is being done without a Try / Catch block.
I want to check the connection of server path eg[ URL] whether exists or notI tried this System.IO.Directory.Exists("http://localhost/MyProject/ ")but it always return false.So does anybody know how to check it?
View 3 RepliesI'm having a problem with some users, my vb tools always check at the splash screen a response from a server with a simple:
Dim MyResult as string = oWebclient.DownloadString("www.mydomain.com/page.php")
This actually works for most users but in some clients the firewalls I think they block this call or bypass or something like that, I found that after telling the user to turn off the firewall everything works ok, now I have some users that according to them they don't have a firewall or they already disable and still they have the problem.
You can see from the image the error message they receive, so my question is do you know any kind of free tool that I can send to the user to maybe log what program or whatever is blocking the program to connect?
I have a little problem with checking if a sql connection is good.
Attached here i have a simple vb.net program that should check if the sql connection to the sql server is good. If i just run it once it works very well. But if i use it in a timer and check the connection to the sql server every 10sec it will only tell me that the connection is good (V=0).
I have tested the code with turning of the sql server service.
Dim connect As String = "Server=192.168.1.2;Database=Test;User ID=sa;Password=12345;Trusted_Connection=False"
Dim sqlconnection As New System.Data.SqlClient.SqlConnection(connect)
[Code].....
We want to developed services to sending fax which should check internet connection after every 10 sec and should be work on all windows operating system.
I cannot use any host like[URL]..to check internet connection because it increase network traffic.
how do i check for sql connection status constantly. Timer?
View 4 Repliesif i go to sql server configuration manager and shutdown the SQL server, the server will be down.
How do i detect for those changes using vb.
Public Sub CheckConnection()
Dim con As New SqlConnection
Dim objCmd As New SqlCommand
[Code]....
I cant make those work because the connection opens and close. WHat i want is to check if the server is alive or dead.
<Visual Studio 2008(VB.Net) + SQL server 2005>
I have an application for HR and I am trying to give feedback to users on login window wheather it is connected network and database.
I have create a simple app in vb.net that receive data from a bluetooth device ( data are simple strings like "90123.9mm"). Is there a way to check if the device has closed the connection ?
[Code]...
I looking for a solution for how to check if a connection to a remote computer exist or not using vb.net.
I 'm writing a program which will request data from a remote sql server. I need to check if the connection to the remote server exist, before open the connection or run the the sql command.
Check Point of Origin, Reject TCP Connection: Content removed.
View 11 RepliesI would like to a program I'm building on loading to check whether there is a internet connection and if there is to connect to a ftp site and copy a file from there to a specified directory
View 3 RepliesThe code i have so far inputs the users username and pas that they inputted into 2 textboxes. Next the user hits login and it submits the info. Here is where i have a problem. Some users are already logged in when they get to the site, this is a problem because i need to make sure they are logging in correctly. Here comes another problem, lets say they log in correctly, how can i know that the login was successful?
Simplified:
1) How can i find out if the user is already logged in so i can log them out.
2) If they are not logged in, and they log in successfully. how can i confirm that?
If there is any other way to login without web browsers?
'Code to enter the user and pass into the webpage
WebBrowser1.document.GetElementById("Username").InnerText = TextBox1.Text
WebBrowser1.document.GetElementById("Password").InnerText = TextBox2.Text
'Code to click login on the webpage
WebBrowser1.document.GetElementById("submit").InvokeMember("click")
When I am building my web-poject it is successful and giving no error but when I check the Error list too many errors are showing. One more thing that when I am taking even empty events the error increases
Errors in Error List are:
Error 1 Name 'nserted' is not declared. C:Documents and SettingsVisual Studio 2005WebSi
[code].....
Is there a Visual Basic Best of the Best showcase?I am talking about commercial programs that really shine.Where can I go to goggle at the the most successful VB apps around?
View 15 RepliesHow can I recover my last succesful build.When debugging the last build will run but I cannot edit anything due to errors in the current code.Does anyone know.Oh I am using VB.net 2008.
View 5 RepliesFor almost a week I am reading and trying to find a solution for checking connection state using a TCP Client (using socket class) In my scenario I have a TCP Client that is connected to a server (it is not controlled by me) and i want that from time to time to check the connection state, and reconnect if necessary.I have read a lot of information on the internet but i did not find a suitable solution.Briefly, these are the methods that i have found on the internet and try to implement.But unfortunatelly, i have found some scenarios where the TCP Server is closed and the TCP Client is still saying Connected 1.Example from MSDN
[code]...
I am Using Visual Basic 2010. I want to check My Connection Status. Connected or not in Remote Server Connection (SQL Server 2008 R2). How To Check Connection Status..?
View 1 Repliesi want to make condition statement in my function. i use this method : [code]if i try to insert a data already in the database, the function will directly go to the updateDatabase()the problem is, if i try to insert the data that currently not in the database, the function will directly go to update database as well.
View 1 RepliesI share my internet connection with other users through LAN. There's some one who keeps cutting me off from time to time to increase his download speed.I know that there is some orders that can be written in the command line to reconnect to the internet after every cut but I don't know them.I started teaching myself programming under VB 2008 Express as a hobby few weeks ago. I was wondering if there is a way to write a program in VB to check the connection condition every few milliseconds and reconnect again to the real gateway till the attacker get bored.
View 25 RepliesI am using a MS Access database as the backend of my VB.NET application. I am entering users details into the database using an INSERT INTO statement:
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & config("DatabasePath") & ";")
cn.Open()cmd = New OleDbCommand("INSERT INTO blah blah blah...", cn)
dr = cmd.ExecuteReader
[Code]...
database - Checking if INSERT INTO statement was successful
View 11 Replies