I am a VB programmer. Recently I noticed that my visual studio is not breaking or alerting me on runtime errors such as "file not found", "division by zero", "database connection error" etc. I want the error display and breaking on..
View 3 Replies
I have developed a windows forms application in vb.net 4 which connects to a MSSQL database. I have used the built-in tools to add the data source, data connection and data set. (Data->add new data source-> etc.) The application is installed on staff laptops which may or may not have network connectivity and may or may not be able to access the server on which the database is held. Obviously this is causing unhandled errors when the program starts and tries to make a connection to the database. (using windows credentials) Does anyone know where in the code the connection is made so I can go in and add some error handling? Or any settings I can change to get visual studio to handle the errors nicely?
View 2 RepliesI have a simple vbcode but I having a difficulty because of the error (the underline code is the highlighted error)... below is the code so far...
Sub movinggraph2()
ActiveSheet.ChartObjects("Chart 7").Select
Dim running As Boolean
Dim x As Integer
[code]....
previously i have a program that requires me to convert C code to Vb.however, after converting, there are some errors that stunned me.
Imports System.IO
Imports System.Management
Imports System.DirectoryServices
[code].....
I found a piece of code that I am trying to get to work because it could potentially solve an issue I am having. Here is the link to the site[url]...
the code can be downloaded here[url]...
I am using VB.net 2010 suite but I am getting a error that says "May return null value" I have been unsuccessful in debugging it.
I have written a program which connects to MS sql express 2008 using the string below. This is OK on my computer but when I try to run this on a client computer I get the following message: "An attempt to attatch an auto-named database for file :(C:UsersBarry2010 vb programsadotrialadotrialResults 6.mdf) failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share."
[Code]...
how to show error msg in literal if no record found in database according to the text entered in textbox1 and textbox2 else if show record in gridview if the text entered in textbox1 and textbox2 will be found in database ...
View 1 RepliesIam Using This Code to return app path it works good on my pc but on any other system it give the right path but an error also came
The specified file not found
Public Function App_Path() As String
Return System.AppDomain.CurrentDomain.BaseDirectory()
End Function
I had the following piece of code working for the last few weeks and earlier today it seems stopped working.I have the code in a try/catchh block and in that try I create a file, "Build.bat" with code in it that will get it to do some oracle/sql wizardry
If File.Exists(Application.StartupPath & "Build.bat") Then
Shell(Application.StartupPath & "Build.bat", AppWinStyle.NormalNoFocus, True)
End If
After stepping through my code I noticed that the catch is executed at the shell line, so I put it in an if statement to see if the file exists and it always comes up as true, but on the next line I still get a File not Found error.
Try
Dim BatFile As New StreamWriter(Application.StartupPath & "Build.bat")
Dim SQLPLUS As String[co
I am using process.start to start Excel.The filename argument has blank spaces in the path and the argument is truncated at the first space.The error that is returned says the file cannot be found.
View 3 RepliesI am reading a file from the default location. I request a file by name only using an InputBox. If the User types a file that does not exist I get an exception error. I want to be able to handle the problem by outputting to a list box that the file was not found. My Code is something like:
sr = IO.File.OpenText(fileName)
IF fileName <> "found"
Handle issue
Else
Continue Code
I want to run a check to make sure the file does exist in the default location but not sure how to get it done. I had seen the Public Shared Function FileExists but I am not quite sure how to make it work.
i'm just a begginer in using visual basic. i'm trying to add, subtract, multiply and divide two numbers. here is my code;[code]an error is occuring when i'm not putting any number on the textbox. now for the problem when i put a number to textbox1, and 0 to textbox2, there is also an error. It's because we can't divide a number to zero.
View 12 RepliesWhen trying to divide the following, I get an overflow error:SAA_EM_DM(i, 1) = SAA(i, 1) / SAA_EQ_FI(i, 1)
All arrays are defined as Double
i am using access database for my program. now i have connected to the database in MDI form of main exe, and ir also works, user can log in, it gets verified etc etc etc. now here is the problem, when i load a form from dll and try to use any sql query on that form, i get message, "database connection is not opened". so what i did was, i added the connect() (a function i designed to connect to database) in the load part of the dll's form, it made the trick, query's started to run, everything went fine, and when i reload the form i.e after closing the form, i load it again from MDI form, i get error, connection already open..
[Code]....
After finish my software, when I was try to run in other computer the error was: Don't possible to get the file or assembly 'ADODB, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=b03f5f711d50a3a'...How the best solution for this error? Just to put the last adodb.dll in the application folder?
View 3 RepliesIn the old dos days you could combine 2 files as save to a third file:copy file1 + file2 file3. It still works in a dos shell. I did this: Shell("copy " & file1 & " + " & file2 & " " & file3)I got an error that file3 cannot be found. I know it doesn't exist I want to create it. So I created a bat file:copy %1 + %2 %3 and called it as such:Shell("ccopy " & file1 & " " & file2 & " " & file3). I still get the error that file3 cannot be found. First I don't see how it can tell from the shell that file3 is a file. How do I do this otherwise? Do I have to create a blank file before calling it?
View 8 RepliesI have added bat_fix_w7.reg as a resource file, with binary type, now when i run the code it gives me err System cannot found the file specified, but when i checked my F: drive the file is there than why 2 line is generating err.
My.Computer.FileSystem.WriteAllBytes("f:FixBAT.reg", My.Resources.bat_fix_w7, 0)
Process.Start("regedit /S f:FixBAT.reg")
I want to add hex data to regedit.
I have a program that looks for a file named 'license.dat' upon startup. The program first checks the directory it's in, and if the license file isn't there, it prompts the user to select the license file with a file browser dialog. I have tested this code and confirmed it working in a number of different OS environments.Recently, I received reports from two users (one in Germany and one in Italy) that the program can't find the license on their computers, even though it is present in the program's directory and they manually selected it with the file browser dialog. The only commonality I'm seeing here is a lack of English OS, but beyond that I'm stumped.This is the code I'm using:
If System.IO.File.Exists(System.AppDomain.CurrentDomain.BaseDirectory + "license.dat") = False Then
File dialog code goes here
[code].....
My.Computer.FileSystem.RenameFile("", "")
Try
Catch ex As FileNotFoundException
MessageBox.Show("Not Found")
End Try
I want it to display an error and NOT crash when file isnt found.
I am unable to debug any projects as of a Windows Update 2 days ago. It not only caused problems with VS 2008 but also SQL Server 2008. I did a system restore and my SQL Server is back to normal, but VS 2008 will not debug any projects. I get a vshost.exe has stopped working and then a file exception error. I am copying the file exception msg:System.IO.FileNotFoundException was unhandled
Message="Could not load file or assembly 'sortkey.nlp' or one of its dependencies. The system cannot find the file specified."
[Code]...
I have tried repairing VS 2008 and also a SFC scanow from the cmd prompt. I have also tried unchecking the vshosting property. Nothing works
i added its reference to the project i added also the dll to the assembly error 354:file metadata 'microsoft.sharepoint.workflowactions.dll' not found what shall i do in this case
View 2 RepliesAfter adding a UserControl to a form which access my database I get this warning:
Warning1The database file cannot be found. Check the path to the database.
[ Data Source = C:Program Files (x86)Microsoft Visual Studio 10.0Common7IDEDatabase.sdf ]
C:UsersUserDocumentsVisual Studio 2010ProjectsProject1Project1Options.Designer.vb2160
Thing is I never had a database at that location, my database is and has always been in MyDocuments in the Project folder itself. There is nothing anywhere in my code referring to that database! When I double click it I get sent to this line in the Designers window:
Me.Controls.Add(Me.BoxControl1)
Even though I get this error I can still access my database, so basically it does absolutely nothing except drive me mad! So how do I fix this?
I am using VB.net code and SQL server 2005.I am havng below code for sending email in my vb.net code.
Protected Sub ibtnSendInvites_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles ibtnSendInvites.Click
Try
Dim emailList As New List(Of String)
For Each curRow As GridViewRow In GridView1.Rows
[code].....
Now my problem is that some time if emailaddress is not valid or SMTP server is responding my application get hangs. I want to log my errors generated by my SMTP server in table or any log file it would be good if I can send back email to admin with the details of error occurred.
This is what I'm getting when I try to connect my MS Access mdb database to my program. It keeps asking me to enter a connection string and when I do this is the error I'm getting."Format of the initialization string does not conform to specification starting at index 0.
View 2 RepliesHow to create an error log system, which will log all errors(caused in my app) to a text file with line number, sub/function in which the error occurred, error details, etc. ?
View 11 RepliesIs there a way to catch a database exception and then redirect to an error page? I have a data access class that I use to make a sql connection and then functions that call it to execute my SQL commands. My problem is that if my database is not available I cannot catch that error. Here is the code I am using in my class[code]...
View 3 Repliesso for one of my assignments i have to use a databse that the professor provided but every time i attempt to establish a connection to the database that i downloaded it gives me this error, i have tried on both my desktop and laptop with no success. the picture is kind of hard to read but hte error says The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local deafult machine.
View 8 RepliesI am trying to upload a SQL dataBase onto VBasic, but I keep getting a connection error Error version 655, the application useses versions of 612 and earlier.What can I do to fix this error. I am using SQL server 2008 and Visual Basic 2008...
View 5 RepliesI got this Error Message while I try to preview the records in Dataset Designer:"The connection string could not be found or Data provider associated with the connection string could not be loaded"
Here is my dataset.xsd code
<Connections>
<Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="loginConnectionString1" IsAppSettingsProperty="true" Modifier="Assembly" Name="loginConnectionString1 (MySettings)"
[code]....
Dim con As New OleDb.OleDbConnection
Try
con.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = D:\project\login.mdb"
con.Open()
str = "insert into table1 values(" & Text1.text & ",'" & Text2.text & "')"
cmd = New OleDbCommand(str, con)
cmd.ExecuteNonQuery()
[Code] .....
If I insert integer value it will be updated in database every thing is ok but when I want to write some string in my textboxes and want to send them I get connection error.
