I am executing a SQL Server 2000 DTS package using C# by following the code from this article [URL]. once the package is executed I am looping through each step to find out if any step has failed and get info about error if it has failed. I also use this information to find out if the package has succeeded or not (package failed if anyone step has failed).
[Code]....
I Just want to know is is possible to execute a ssis package from vb.net application?If so how to do that???
View 3 RepliesI am trying to run the application created in the example at [URL] The code errors at the line dtsDataReader = dtsCommand.ExecuteReader(CommandBehavior.Default)
the error is A requested parameter does not exist in the package. I have checked everything that i can think of in the package Also when I try to run the package using the dtexecui utility I two errors "Error: SSIS Error Code DTS_E_PRODUCTLEVELTOLOW.
[Code]...
Question: I catch generally unhandled exceptions with AddHandler System.AppDomain.CurrentDomain.UnhandledException, AddressOf OnUnhandledException
The problem now is, with this exception handler
[Code]...
Question: I catch generally unhandled exceptions withAddHandler System.AppDomain.CurrentDomain.UnhandledException, AddressOf OnUnhandledExceptionThe problem now is, with this exception handler
Public Sub OnUnhandledException(ByVal sender As Object, ByVal e As UnhandledExceptionEventArgs)
Console.WriteLine(e.ExceptionObject.ToString())
[code].....
I am wanting to use an application to package all my files together into a setup package. I have tried InstallShield 2011, but when i click on Visual Basic .net wizard, it tells me I do not have Visual Studio.NET installed on my system. I am currently using VB2010 Express How can I fix this... or is there a better application available for packaging?
View 2 RepliesWhen I using the Add-in of Package and Development Wizard to package my project,Run the first step button "Package".The error message is "Unexpected error number 380 has occured: Invalid property value"I'm using VB6 and XP'OS
View 2 RepliesI have an object, say Order where if an error occurs, it raises the ErrorOccurred event. If I'm running some code in say, the codebehind for a .aspx page with an public Order registered as WithEvents and I want to check to see if an error has occurred before I run more code, how do I do this? I can't simply check theOrder.ErrorOccurred. Do I have to create a local boolean flag that switches over in the event handler (OnErrorOccurred)?
Example:
Public WithEvents theOrder As New Order
Public Sub DoStuff()
theOrder.DoSomething()
If theOrder.ErrorOccurred Then
[code]....
I installed the latest version of Toad yesterday. When I restarted Visual Studio 2008, the project that is my installation package for my application would not longer load. The message I get in the output window is "The Visual Basic Deploy Deployment Package ({CCD045E8-6236-4B3D-B820-97F7DD14C77C}) did not load because of previous errors." When I try to reload that project, I get the following error: " The operation could not be completed. No such interface supported" I tried to repair the VS installation, but that originally failed. The Deployment folder under Common7Tools was currupted so I ran check disk. A few bad files and clusters were found and corrected and the second run of check disk ran clean. I uninstalled Visual Studio and then reinstalled it, but am still getting the same error. I tried reinstalling .Net 3.5 before the reinstall of VS as well. I tried creating a new installation project, but that failed as well.
View 1 RepliesI was having problems updating information in my SQL database using my vb.net application, but recently I found the solution. However now I have run into another problem which is shown in the code below:
Private Sub cmdupdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdupdate.Click
Dim conn As New MySqlConnection
Dim myCommand As New MySqlCommand
'#######
conn.ConnectionString = "server=" & frmLogin.txtserver.Text & ";" _
& "user id=" & frmLogin.txtusername.Text & ";" _
[Code] .....
The exception message is:
Fatal error encountered during command execution.
I don't know if this is simply a syntax error that can be fixed easily, or something to do with my database configuration.
Is there a command that will stop the execution of my program?
I have a service that is processes an exchange account via telnet every 10 minutes. During one point of execution the application could possibly have a response from the telnet session when there are NO e-mails in the folder, which would look something like this[code]...
So is it possible for me to just stop my application at that point since there's no point in continuing if there are no e-mails in the account?
I got a stored procedure that reads a table and insert those data to antoher table. That's the way how it works because the first table imports data from excel using a package with SSIS.In EF4 I imported the SP and create function import:This SP has 2 IN variables and 2 OUT varibales.The IN varibales are parameters and OUT variables are a message and the number of records created.[code]
View 1 RepliesWhen i try to run a msi using System.Process.Start("test.msi") in a vb app i get the following error. The installation package could not be opened. Contact application vendor. Msi file works fine when double clicked, tried System.Process.Start with text files and exe files and they work fine, problem only with msi files. Running vista. Also tried xp but no luck.
View 2 RepliesI have been working on an activeX control which works on serial port communication. Now I have completed the project and created its setup.exe using Visual studio 6 -> Tools -> Package and Deployment Wizard. Then I installed the control in another PC and in a new project included the control using project -> components. But when I click on the control in the toolbox and then include on the form it gives the following error : delete current link ? and on clicking OK, nothing happens. I tried searching a lot on google but didnt find anything. Another problem is that I have created a string array as a global array which can be accessed by all the methods.I am able to include the same activex control in my own pc when I have created the project. Here it works fine, I am able to access all the methods that I coded in the control, but the String array mentioned above can be accessed in other project. I tried writing Public before the array declaration but it give me the compile error : "Constants. fixed length strings, arrays, user defined types and Declare statements not allowed as Public members of object module." [code]
View 1 RepliesI am trying to get this contact form to work, but I get an error message saying: "failed to send message". The problem is the section of code near the bottom of the page where it executes this line of code: MailObj.Send(myMessage)'ve put dummy credentials in the snippet below but triple-checked my smtp un/pw and cant figure things out.
VB CODE
Imports System.Web.Mail
Imports System.Net.Mail
[code].....
What error handling should be used in VB.NET? Should one use the "On Error Goto ErrorHandler Exit Sub ErrHandler ... End Sub" pattern or should you use the "try {... } catch {...} finally {... }" pattern?
View 4 RepliesWhy am I getitng the following error? Object reference not set to an instance of an object. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.
Source Error:
Line 9: Dim entry As DictionaryEntry
Line 10: For Each entry In dictionary
[CODE]...
In my vb.net application if I have a known set of Error Strings i.e.
Failed because I don't know about it
Failed because I know about it but I can't find it
Failed for another reason
[code].....
I am just doing a bit of error handling. I am just check to make sure that a user has selected an option within a combo box (named cbtitle1) and if option has not been selected throw an error message to tell the user.this if statement is within a save button which once a user click save this error checking runs first then if combo box has an option selected the save goes ahead else it throws an error.I can stop the save function OK but I wanted to put a error icon in with the message box but I get an error when I add it.[code]
View 3 RepliesObviously error handling is a major factor in making a good application. If a error happens letting a user know what has gone wrong.But some times error handling may(i think) not be needed. Example.
Private Sub RemoveCheckedl()
Try
For Each Item As ListViewItem In lst.CheckedItems[code]....
also when error handling it's could to think about what type of errors could be made.
Catch ex As Exception
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error)
even though this catches the error and displays a msg, it may not be a great message for the user so he/she can understand.
I am working on an executable to load set of data into databases.I will be running it as a windows service. I will be doing several different checks to see if the fields exists in the incoming files. When i do the checks using if statements.I would like to stop processing when a major error occurs or when any thing is interrupted Like say windows crashed. I would like to create an error file with the error message in it for that particular file. I would be monitoring error folder everyday to check if there are any errors.
View 1 RepliesWhen debugging a program, instead of doing this on EVERY piece of code:
Try
MyFunction()
Catch ex as Exception
MsgBox(ex.Message)
End Try
Is there a way to apply that to everything error I encounter without writing it on every function/sub/etc?
I created a simple VB application in Visual Studio 2010.My computer, which I am using to create the program, is Windows 7 Pro, and SQL Server 2008 is running on a Windows Server 2008 Enterprise, which I have full access to.
I want to click a button and have an SSIS package execute.I looked around on the Internet and found examples, but they do not seem to work for me.I try to add a reference, Microsoft.SqlServer.ManagedDTS.dll, as a few sites advise, but it is not listed when I go to PROJECT>ADD REFERENCE.
I also type:
Imports Microsoft.SqlServer.Dts.Runtime but all I get is a squiggly green line, which when hovered over states "Namespace or type specified in the Imports 'Microsoft.SqlServer .Dts.Runtime' doesn't contain any public member or cannot be found." Below is some code I copied from one of the websites and pasted in my button click event (the path is correct), but a get blue squiggly lines under "Package" and "DTSExecResult":
Dim pkgLocation
As String
Dim pkg As
New Package[code]....
What can I do to make the SSIS package run when I click the button on the Windows application a created?
I am using try..catch for error handling. I am getting the message displayed as
messagebox.show (ex.tostring)
But it gives very long message.Is it possible just to get only the actual error or I could give my own modified message, based on what ex contains?
I am looking at implementing a Web Service API for our product. I have figured out how you go about the general architecture/fault handling within WCF. My question is a more general one of how to design the overall error handling system. For example I have a method called SaveCompany (companyobject). Each company name needs to be unique. Say you tried to save a second company called "ABC Inc.". Would you expect to get back a fault named "DuplicateCompanyFault", or would you expect to get back an error code, or something else? I guess the root of my question is would you prefer to receive faults to handle, error code, or some combination? These services are going to be consumed by multiple different entities outside our company on multiple non-.NET platforms.
View 2 RepliesI am creating function for search data using textbox and button. i want to put an error handling in my code which if the data was not found then it will appear in message box "Data is not found. For your info i am using visual studio and sql 2005. Here is my code and i also attach my picture
Private Sub Search_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnsearch.Click
Me.StaffBindingSource.Filter = "NAME = '" & Me.txtsearch.Text & "'"
[Code].....
I have an issue with handling errors in procedure calls in VB6.
View 6 RepliesI use a standard error handling routine in my methods that looks like the following:
Try
Cursor.Current = Cursors.WaitCursor
Cursor.Current = Cursors.Default
[code].....
I used the following code(with bug):
Code:
For n = 0 To 100
If saveLine(n).Substring(0, 8) = "heading:" Then
cboSelect.Items.Add(saveLine(n).Substring(8))
End If
Next n
The For loop only ran 5 times. It turned out that saveline(5) was shorter then 8 characters, so I changed the code which solved the problem:
Code:
For n = 0 To 100
If saveLine(n).Length > 8 Then
[code]....
VB 2010 neatly exits the for loop when the bug occurs. In this case it was easy for me to pick up the bug, because the combo box was not properly populated. What if it was not obvious that the for loop did not complete? It is quite scary to think that bugs like this are not displayed at run time.
We are developing an application for our shop floor. This program will be tracking material through the shop and we need to capture any errors the program generates, but we don't need to stop the program for all errors. I have some code to do a screen capture and put it in a database with exception.tostring data for debugging.
What we would like to do, is create an exception from the base class, but provide additional properties to allow us to set a severity and a user friendly error message. I would like to encapsulate this in a class that we would call in the catch of a try/catch, set the properties on the class, have the class record the data to the database, then raise the exception to the main program to display only the user friendly message and severity. The main program would then determine the severity and based on the severity stop the program or just display a discreet msg and continue to process.
Does anyone have an example of a custom exception class derived from exception that does something similar, or if I heading in the wrong direction, does anyone have a better solution?