Run SAP Transaction From Command Line App?
May 28, 2009
However, I've just inherited a problem and was wondering if anyone knows if I can solve it with a command line application written in .NET. Basically, we have a SAP transaction which has been written which imports data from a csv file.At the moment, it will be a manual process requiring someone to log in and run the transaction. Does anyone know if it's possible to action this from a command line app which we could then set up as a scheduled task?
View 1 Replies
ADVERTISEMENT
Mar 5, 2009
What is this kind of exception?
Error : Execute requires the command to have a transaction object when the connection assigned to the command is in a pending local transaction. The transaction property of the command has not been initialized..
This one causes the error: Dim oOperation As COperationOutputTypeBS
oOperation = COperationOutputTypeBS.GetOperationOutputType(txtOperationCode.Text)
View 1 Replies
Nov 8, 2007
Any ideas on how I handle the following error thrown in the SqlDataAdapter.Fill as a result of the BeginTrans in the callee?
System.InvalidOperationException = {"ExecuteReader requires the command to have a transaction when the connection assigned to the command is in a pending local transaction.The Transaction property of the command has not been initialized."}
[code].....
View 7 Replies
Jun 30, 2010
Public Sub ExecuteTransaction(ByVal connectionString As String) Using connection As New OleDbConnection(connectionString)
Dim command
As New OleDbCommand()
Dim transaction
As OleDbTransaction
[Code]...
View 1 Replies
Jun 6, 2012
I have beginner skills using VB (am using the Express edition to learn). I would like to know how to set up a conditional statement in a Windows Form (WF) app that would check if a specific command line has been passed by another separate app that launchesthe Windows Form app using command lines, and if not passed, then the Windows Form app would shut down (exit, close).So far, I can use:
For Each s As String In My.Application.CommandLineArgs
If s <> "xyz" Then
Me.Close()
[code]....
View 14 Replies
Oct 31, 2011
I want to know that do you still need to rollback your transaction if you haven't commit the transaction that was created earlier.
[Code]...
View 3 Replies
Oct 11, 2010
Public Sub Procedure(ByVal procname As String, Optional ByRef param() As SqlParameter = Nothing)
'Execute Store Proc In Database
Dim cmd As SqlCommand
cmd = New SqlCommand(procname, conn)
cmd.CommandType = CommandType.StoredProcedure
[Code]....
I have came out with a simple DAL, when i pass in stored procedure and param, it throw me exception as the following
"ExecuteNonQuery requires the command to have a transaction when the connection assigned to the command is in a pending local transaction. The Transaction property of the command has not been initialized."
View 1 Replies
Apr 30, 2010
First let me say that I am not sure whether or not this should go in this section or the API section, and if it needs to be moved I apologize. My issue is fairly straight forward, but for some reason I cannot get it to work.
I am trying to send a command to a command line and then submit the command. I have been trying without success to get this to work in v2008 Express and v2010 Express, Here is the code I am trying to us:
Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" ( _
ByVal lpClassName As String, _
ByVal lpWindowName As String _
[Code].....
View 6 Replies
Feb 24, 2010
I am using the following code to run defrag and to analyze if the C: drive requires defragmentation:
Dim analyze As Process = System.Diagnostics.Process.Start("C:WindowsSystem32defrag.exe", "C: /a /h /u /v")
This process runs through analyzing, runs it in normal mode & prints the progress to the command window.
My problem is that as soon as the process is complete the command window closes. I need it to stay open so that I can read the results.
View 3 Replies
Mar 11, 2010
I am trying to send a command to the external command line (cmd.exe) from the Windows form application that I'm writing in VB.NET (using VS2008).
I can only access the external program thru the command line (its not my program) and I must do so from a form app.
I am trying to use the following code. I am able to call a cmd.exe window, but I can't pass the command line my command.
Using mp As New Process
With mp.StartInfo
.FileName = "cmd.exe"
[Code].....
View 8 Replies
Feb 4, 2011
I am using a CheckedListBox that is populated with Filenames (full path, i.e. C:TestTest.jpg)When I have the files that I want in the CheckedListBox I wish to click a Start Button which will process the list one at a time using an exe program that runs on the Command Line. There are arguments that need to pass to the command line as well as the file location in order for the program to process.I currently have it working but the issue is the loop finishes quickly and it is left up to the CMD.exe to finish the process. What I would like is for the LOOP to wait until each file completes processing before passing the command for the next file in the CheckedListBox.There some reasons I wish for it to work this way.
1) I would like to have a button that can Pause/Restart the Loop.
2) I would like to have a button that can Stop the Loop so the whole process can end.
3) I would like to have the Loop remove each file one by one from the CheckedListBox after it has been processed.
4) I would like to display a Message once all the files have been processed.
5) And if it were possible I would like to report the status either by text or a progress bar showing where it is at in the process.
6) And the ability to add some error handling if possible.
Since the Loop finishes so quickly as it just passes the command to the command line using the & as a seperator it is the command line that is handling the rest of the process. Because of this there is not control over it in the GUI.The code I am using allows the Command Line text to display in the Form so it won't open up a seperate window to run CMD.exe. This is the desired affect as I would like everything to appear to run from within the Form itself.
[Code]...
View 6 Replies
May 9, 2011
I get this error at the Commit of a transaction in a desktop application:
This OleDbTransaction has completed; it is no longer usable.
Other posts I have seen with similar error suggests this can occur if it takes a long time, or contains large amounts of data. This is not the case here.Logging tells me it takes 140 ms from Begin to Commit and about 10 commands executed inside the transaction.It is using an Oracle database.This class is a simplified version of my database class:
Class MyDatabase
Private mConnection AS OleDbConnection
Private mTransaction AS OleDbTransaction
[code]....
Is it not allowed to run a select inside a transaction like this? Or can it be done by running the transaction in a specific isolation level (I see that the BeginTransaction method has an optional parameter for doing this) ? ..Or some other sollution..? In my case, it was not a problem to move the select to run before the transaction started, but what if you need to run selects that must run inside the transaction?
View 1 Replies
Apr 29, 2009
I've seen plenty of examples of transactions in the actual store procedure's SQL. But I'm wanting to do the transaction and keep track of it in code. I tried this but it says that my insertcommand's transaction object is null. How can I fix this?
vb Dim conn As SqlConnection = DBConnections.SQLServerConnection
conn.Open()
Dim params(1) As SqlParameter
[CODE]....
View 3 Replies
Aug 5, 2011
[Code]...
This one copied from microsoft web site, is this command working...? Error like " Executive Reader Requires.......Transaction property of the command has not been initialized..."
View 1 Replies
May 29, 2012
I am struggling to pass a parameter to a VB.NET application via a Windows scheduled task. It works perfectly in Visual Studio (passing a command line arguement via project properties).If I am calling a VB6 application, then I will supply the following parameters and it works:
Run: c:progra~1TestTest.exe TestParameter Start In: c:progra~1Test However, if I supply the same parameters in VB.NET, the program throws an exception when it tries to create an instance of a class in the Form.Load: System.NullReferenceException cannot create instance of object.
I have also tried the following:Run: c:program filesTestTest.exe TestParameter Start In: "c:program filesTest" This time the status of the scheduled task changes to "cannot start".What is the correct way to specify command line parameters in a scheduled task for a VB.NET program?UPDATE I found the solution on this web page:[URL}.. I am still confused as to why the program would not create an instance of an object when I used the 8 bit paths (i.e. progra~1)
View 1 Replies
Mar 3, 2006
I want to run the following command line program from VB.NET: rotor95.exe -d -k "password" -i "C:FileLocation" -o "C:FileLocation" The reason for this is that I don't want my users to have to drop out to a command line prompt in order to run a tiny program for 3 seconds. Typing in a 50 - 75 character file path twice isn't any fun either.
I tried using tooltask as discussed in the MSDN2 help but it appears to work with switches (/d etc.) but not parameters (-k "password"). I couldn't get the thing to work. See the following for the tooltask example:[URL]..light now I'm just using Shell("rotor95.exe -d -k "password" -i "C:FileLocation" -o "C:FileLocation") which works just fine but I'd like to use the .NET 2.0 super-whammy version of handling this problem if there is a better way to do it.
View 3 Replies
Sep 19, 2010
how to use basic FTP functions straight from the command line tool. and I started using Visual Studio to create "macros" for the command line tool (i.e. writing down specific functions to perform, write them to a txt file and then run Shell() to execute.)But what I want to know is if I can open a command prompt window and then interact with it. Say for example I'm writing an FTP class/object, I'd want to be able to keep a window up for my program to send commands to (And wishfully read data back from it.)Because it seems to me that whenever I use the Shell() command it just opens a prompt window and then closes it after my line of code has been executed. Is there way to interact with a command line window from Visual Studio? And maybe even scrape data from the terminal like with terminal emulator scripts?
View 1 Replies
Aug 22, 2011
I have a console application which reads .txt files. I want to be able to drag a txt file over my app and it would automatically open my app and show the text files contents. I think I have to use command line arguments like this:
Sub Main(ByVal cmdArgs() As String)
End Sub
Sub ReadFile(FilePath as String)
End Sub
But how can I pass the text files path to my ReadFile sub?
View 1 Replies
Jul 8, 2010
OK! I've written my application in all it's GUI glory. I now just want to be able to run it from dos/a command line/batch, with no GUI appearing? So it just runs (& does its batch process).
How can I detect if my application has been initiated from command line/dos?
How do I then not open up the application and show its GUI etc?
View 35 Replies
Dec 9, 2010
Printing Work Orders from with in a .NET scripted screenSummary of code:
Public Overrides Sub onload(ByVal e As ScriptonloadEventArgs)
Dim CWONO As String
SetValue("CWONO") = "WO_Number" '(This field is automatically created with previous code)
[code].....
View 3 Replies
Mar 9, 2009
I was wondering if it's possible to create a .vb source file from notepad and be able to build/compile from the command line without the need of a vb environment?
View 1 Replies
Jun 7, 2011
is there anyway to get the another application environmenat commandline argument
View 1 Replies
May 3, 2011
I have a forms app that contains a few forms. My task is to make it run invisibly when called from the command line with arguments.I have defined a Sub Main in a module and made it the startup item. I have an if/then/else that looks at args.length and if it equals 0 then I load the form and run the app normally. But how do I handle things when args are passed? I still need access to all the functions defined in my main form. Can I load the form invisibly and still "use" it?
View 14 Replies
Feb 8, 2010
When you open up a .txt file, the command line opens up notepad.exe with the argument %1. which opens the text file. i dont know about the function but i understand a little bit about it.
So what i wanted to do was create a .lxproj, and make it open up with my application. i have done this part so far with an installer that creates registry keys. but, what i would like to know is how to open the file. for a test i would like a message box to be displayed if the program is run by clicking the .lxproj. if its opened normally the messagebox doesnt display.
View 5 Replies
Aug 2, 2011
I am making a console application that will be prompted from a cmd. I want to be able inside my application to start an other program. Here is the line I am trying to use: %SystemRoot%Microsoft.NETFrameworkv4.0.30319MSbuild.exe /p:Configuration=Release test.shfproj This is making Sandcastle Help File Builder create a documentation with the test.shfproj i've builded previewsly.
[Code]...
View 2 Replies
Aug 25, 2009
I want to create a shortcut that do following:Link back to "my application"with command line parameter so that it will not do anything.
View 4 Replies
Oct 3, 2009
I'm making a program that has to execute commands in cmd.exe, but without actually opening it. I set RedirectStandardOutput to True, and I need a way to read the result of the command from the stream. Right now, I use ReadToEnd(), but there's no end to the stream, apparently. How do I read the result of the command?[code]...
View 2 Replies
Mar 25, 2011
I'm a bioinformaticist, I'm trying to teach myself how to develop programs that are easy for everyday users to automate programs used in biological research. I thought VB would be great for helping people be more familiar with bioinformatics. Unfortunately, I'm brand new to VB and am stuck with my first program.
All I want to do is have a window pop up where the user then selects a file from an OpenFileDialog box, and pass the filename to a bioinformatics program names msconvert. What I've been doing keeps giving me a message that seems to says, "Unhandled exception has occurreed in your application. . . . File not found."
However, as you can see in my code (below) I have a MsgBox that shows that the correct file HAS been selected, and I can get the whole thing to run from command line.[code]....
View 8 Replies
Oct 23, 2011
how can i make my own program must run with command line? if the program run without command line, it show some error msgbox..
View 4 Replies
Feb 11, 2012
I've been trying without success to get this working; I am trying to use 7zr.exe (7-zip) to archive things and the like in visual basic. There's a catch: I don't want the cmd window to show and most importantly. I keep getting errors.
To that effect, could someone please translate this to VB viable code (preferably using shell):
"(7zip path)" "e (sourcepath)" "-p(Password)" "-o(Directory)" -Y
I'd keep at it, but it's getting really frustrating.
View 12 Replies
