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 have a program that copies files to several servers in succession. If one of those servers is unavailable for any reason, my program hangs for about a minute before it continues on to the next server. Is there a quicker way to determine if the path is available or not?
View 7 Replies<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.
For 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'm facing a problem after installation any software setup that has a database in access(mdb file) How to I transfer file path in our connection string.
View 3 RepliesAfter running the following sub (VS debugger), I try to detach the database in SSMS, but it shows the connection open still and won't let me detach. If I close program in debugger, the database shows no connections. I check the dataadapter's connection in the finally block and is shows closed. What gives
Private Function ClientMasterDBFiles(ByVal MasterClientDBConnection As String, ByVal DBName As String) As DataTable
[Code]...
I am trying to copy upload files to remote server i get below exception.[code]...
View 1 RepliesThis will happen at random, and I can always just catch the error and re-establish connection to the server, but I am confused as to why. When doing lots of inserting into the sql server, I only establish one connection that is public, instead of many little connections. I had my doubts on a public sql connection, but it's been running great, and I've seen no problems until this morning. Again, this random moment I hit an error that stated, sql connection state is broken. Is it bad practice to just accept this error, and when it happens, re-establish the connection?
View 7 RepliesThis emailing code wont seem to work in my program. I get an exception "The SMTP server requires a secure connection or the client was not authenticated. The server response was 5.5.1 authentication required."
Imports System.Net.Mail
Public Class emailStudent
Private Sub sendEmailButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles sendEmailButton.Click
SendMail()
[code]....
I have simple code that connects to Sql database... (well it doesn't)
VB
Dim objConn As New SqlConnection("Server=localhost;uid=***;pwd=***;database=***")
objConn.Open()
ERROR MESSAGE:A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)But looks like something is wrong with "localhost" thing. Any help? Where can I get name of (my) server?
I am tring to make the below application work with SQL Server 2005 Database Currently it works for test.mdb, which is in the same folder with the application. How shoud I modify the MapPath to work with SQL Server.
[Code]...
I want to connect to a UNIX file path over our network and grab some .log files. Is this possible? If some do I need to do anything more than what I would do if I was opening files from a local path?
View 5 RepliesPossible Duplicate: SQL Express Connection string - Relative to application location
I have a desktop application written in vb.net. The app uses an SQL Server express 2008 database (.mdf file).Currently i have the connection string as absolute path like this:
Dim ObjConnection As New SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=C:UsersPantheoDocumentsVisual Studio 2010ProjectsFood Manager 2012(new)Food Manager 2012Food_CustomerDB.mdf;Integrated Security=True;User Instance=True")
[Code]...
Possible Duplicate: SQL Express Connection string - Relative to application location I have a desktop application written in vb.net. The app uses an SQL Server express 2008 database (.mdf file).Currently i have the connection string as absolute path like this:
Dim ObjConnection As New SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=C:UsersPantheoDocumentsVisual Studio 2010ProjectsFood Manager 2012(new)Food Manager 2
[code].....
How do I extract the file path from the following connection string?[code]...
View 1 RepliesDim dbconn As OleDbConnection
Dim DBCommand As OleDbDataAdapter
Dim DS As New DataSet
dbconn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:COLORsitedataCUFORHDR.dbf;Extended Properties=dBASE IV;")
[Code]...
I prefer SQL server but im afraid in this app I have no choice. I think the .DBF file is v III dBase according to a thrid party .dbf viewer. The code explodes on the DBCommand.Fill(DS) line, telling me I have provided and invalid file path. The path is good to go.
Should I be using a driver with a different provider? When I remove the Extended Properties parameter I get an error unrecognizable database format - hinting in this case the path is correct.
In my app I have a dialog in which the user can select a database backup location. If want to warn the user if the location he/she selected is "probably not secure".[code]...
How can I get this kind of info about a selected folder? I know about the DriveInfo class, but it only handles drive letter, not UNC
I have a app config file with a filewatch file path as a setting. This way the user can change that file path easily on site. My problem comes into play when the file path, usually to another computer on the network is not valid, then I will get a not so nice microsoft error. I would like to catch this error, and put in a friendly msgbox to tell the user it's just an invalid file path. But the file watch is on my first form on the program, and having the catch on the onload of the form is not soon enough. I can catch the error on the form1.designer.vb, but I don't think your suppose to modify that. Cause when I do, bad things happen, like i'm not able to get my form in design mode.
View 2 RepliesTo write a new file to the hard drive Ive always used for example:- FileOpen(1, "C:\FileName.txt", OpenMode.Output) Trying this today I get an error message Access to the path 'C:\Check.txt' is denied.MSDN say I should use: - Dim file As System.IO.FileStream file = System.IO.File.Create("c:\test.txt")So although I couldnt see how to specify the mode I tried: Dim file As System.IO.FileStream file = System.IO.File.Create("c:\Check.txt")With exactly the same result Access to the path 'C:\Check.txt' is denied. It says I dont have permission.
View 5 RepliesIs there a code checking that whether a shared folder is available?? Or check whether ftp path is available?
View 2 RepliesI am trying to do something fairly simple.. allow my user to import thier data from Excel into SQL Server, where it can be used by the application.To do this, I'm using the fairly simple code that is common everywhere I look:
strFilePath = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fdlgFileOpen.FileName + ";Extended Properties=Excel 8.0"
connExcel = New OleDbConnection(strFilePath)
connExcel.Open()
[Code]...
Now, on my development computer this code works perfectly. The data imports, and I can go on my merry way.
On the TEST computer, this code throws the error: "ODBC -- Connection to {SQL Server} servernamesqlservername failed." This seems very odd to me, because I'm using exactly the same SQL Server and database to interact with the application, and all the other screens in the application work perfectly. The test computer CAN connect to this SQL Server, but it keeps throwing this error whenever I try import data from Excel.I've tried everything I can think of - using the server's IP address instead of the server name, sending the SQL Server administrator data along with the request, taking out the Trusted_Connection=Yes... nothing works. What is going on here? How can this code work fine on my computer, and hiccup on another?
I'm creating window application with VB.NET and flatfiles.the problem is how do i store the connection string in the app.config file that include the application.startup path?
<add name="cn" connectionString="provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath + "data;Extended Properties=text;" />
i got some error when writing to app.config.
"Missing attribute value on attribute 'Application.StartupPath'."
I have created a data source connection to an access db by using the wizard in vs2008. I have then used this as a data source for crystal reports. My user would like to put the database on a network and reference it there. Is there a way to set a new path for this data source during runtime?
View 4 RepliesI want to make a program which first of all check whether a serie of programs is installed, if a program is installed I would like to find the installation path, so I will be able to work with it further..My first though was to check in the registry, there is theinstallation path also mentioned right?Another possible way was to search all the harddrives for a specific .exe fil. If then the file is found, the program is installed, and you should be able to find the path to the found .exe file. This is more "secure", right? - Because not all program is registred in the registry right? (E.g. if you move it from another location, and doesn't install it).
View 7 RepliesTo write a new file to the hard drive I�ve always used (for example):-
FileOpen(1, "C:FileName.txt", OpenMode.Output)
Trying this today I get an error message� Access to the path 'C:Check.txt' is denied. MSDN say I should use: -
Dim file As System.IO.FileStream
file = System.IO.File.Create("c: est.txt")
So although I couldn�t see how to specify the mode� I tried: -
Dim file As System.IO.FileStream
file = System.IO.File.Create("c:Check.txt")
With exactly the same result� Access to the path 'C:Check.txt' is denied. It says I don�t have permission.
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].....