How To Execute DB2 Commands Programatically For Backup
Sep 1, 2009
How to execute the DB2 commands programatically for Backup..Here are the commands that need to be executed for DB2 Backup.I am using IBM.Data.DB2 namespace, And as soon as we connect to Dbase in step 2 it crashes to QUIESCE.
1.CONNECT TO <DataBase Name>
2.QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS;The Exception Message I am getting [code]
3.CONNECT RESET;
4.BACKUP DATABASE <DataBase Name> TO "C:\" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 COMPRESS WITHOUT PROMPTING;
5.CONNECT TO <DataBase Name>;
6.UNQUIESCE DATABASE;
7.CONNECT RESET;
View 1 Replies
ADVERTISEMENT
Dec 31, 2009
catch statements - it works well just checking my disk drive for a file, if an error is thrown then I open the disk tray and ask them to put the disk in, click OK on the message box and it performs another check for the file, if this fails the button that starts all this is disabled on my main form (the code is shown below).
Okay, so my problem is I'd like to have the message box pop up and the have the drive open up (using an API which I have) either at the same time or in the order of: message box then drive open. I can see two ways to do this: Have the commands happen at the same time (Can you even do this?) OR Have the message box appear and then open the disk drive (but how I could achieve this I don't know as the message box waits for the user to click OK... I originally though of starting a timer just before and getting it to open the disk drive tray in the tick event,
Code:
Public Class Form1
'open cd-rom tray API
Private Declare Function mciSendString Lib "winmm.dll" Alias "mciSendStringA" (ByVal lpstrCommand As String, ByVal _
[Code].....
View 5 Replies
Jan 20, 2009
I need to execute AS/400 System Commands thru VB. What would be the way to perform this?
View 4 Replies
Feb 26, 2012
I am new to VB and am trying to write a program that will open cmd and execute commands when a button is clicked.[code]...
View 14 Replies
Jun 29, 2009
I want to make a program with a button and a textbox. When i click the button the program (don't know how) writes the text from the textbox in a process called test.exe. Test.exe is a cmd like window, there is only one place to write on it. How can i make it happen?
View 4 Replies
Sep 20, 2009
I know of the Shell method to run files, but how can I execute normal command prompt commands like nslookup, and capture the output as a string?
View 1 Replies
Jun 6, 2011
I trying to figure out how to execute commands stored in string, let's say i have string called "command" and a textbox, so i want vb to run command that i typed in textbox, e.g. i type in textbox "label1.text = "bla bla"", and then type like "msgbox.show". Is that even possible?
View 12 Replies
Feb 25, 2012
I'm evaluating the best approach to implement the following periodic task:
Get some users from SQL Server (2008) and then for each user enable licences in the Cloud (Office 365) using PowerShell.
My first thought was a console-based app in C# or VB.net but now that I realize that running a PS Script remotely using C# can be quite a challenge I'm starting to think in alternatives like perform all the stuff using PowerShell, I guess this is a better approach but I'd like to hear your thoughts on this.
View 2 Replies
Mar 2, 2010
I cant understand why this works (Start a service "test" on a remote computer):
Dim rCommand As String
rCommand = "c:pstoolspsservice \computer -u admin -p blabla start test"
Shell("cmd.exe /c" & rCommand)
[Code]....
The above code that doesnt work starts a virtual machine on VmWare Server. I have the exact same line in a .bat file and if i call the batfile from VB it starts the batfile and execute the commmand. I cant understand why this doesnt work without the batfil when i have no problem executing the PsTools command from VB-code.
View 2 Replies
Feb 2, 2010
i'm tring to execute some commands in cmd prompt in vs 2008. (with out using BATCH FILE)
[Code]...
View 4 Replies
Oct 9, 2011
I need a coding to execute multiple at commands simultaneously. when first command execute and get the response from the port and then the second command will be executed. how to write the coding. it is possible. i am using siemens gsm modem.
[Code]...
when i execute this coding i can't get the correct result because the port response will take some times.how can i identify the time delay. when i use thread.sleep(300) means this is also not correct for my solution. Because the port response will take more than 300 milliseconds?
View 1 Replies
Nov 18, 2009
I need to start a "Run" window(The one that opens when you press Windows+R or Start->Run) and run few commands in it from a VB.NET program.
View 5 Replies
Sep 11, 2010
I am working on a "de-bugging" back-end sorta thingy for my program, and I have a "dll" that executes most of the work for the program. For the ease of tech-support, I plan on trying to impliment a hidden back-door into the engine that is password protected and activated by a key-press. What I want to do is:when the enter key is pressed, have the dll run the sub that is listed in the enter key, for example:
In the dll:
Public Sub msg(ByVal text as string)
MsgBox(text)
[code]....
View 2 Replies
Apr 24, 2012
I'm implementing an application using vb.net 2005 with oracle 10g and I came across a functionality that should Select/Insert/Update/Delete data from three different tables in oracle.So I`m wondering if there is a way to prepare all the 3 commands (SQL Statements) separately and then execute them in one shot to the oracle, so in this way I can guarantee that all of them are successfully executed or all are failed to execute, and also I could gain more performance which is critical in my case.Thus I`m looking for a syntax in vb.net that helps me execute more than one OracleCommand in one shot to the oracle.
View 1 Replies
Nov 22, 2010
Just trying to execute commands in cmd.exe just a simple Net Stop [service] and get a error 5. I want it to run cmd in administrator mode. One way I have seen that you can by holding down ctrl & shift while clicking cmd.exe?
View 26 Replies
Jul 6, 2011
I was recently assigned to do some research on how to approach a project. Right now we have an old program written in tcl. From this tcl program ( running on VMS client computer), we are able to run unix commands to execute processes on a unix server. This is done via tcpip. Now, we are thinking of making upgrades to this system . We are wondering if this kind of thing was possible with Visual Basic. Are we able to run a VB program on windows computer to run UNIX commands on a server? If so, what issues might be brought up. If anyone has even the briefest guideline or tip on this,
View 3 Replies
Feb 25, 2010
[Code]...
how can i get this code to return all values instead of just the first value ?
View 30 Replies
May 26, 2010
How can I download a pdf and store to disk using vb.net or c#? The url (of the pdf) has some rediection going on before the final pdf is reached. I tried the below but the pdf seems corrupted when I attempt to open locally,
Dim PdfFile As FileStream = File.OpenWrite(saveTo)
Dim PdfStream As MemoryStream = GetFileStream(pdfURL)
PdfStream.WriteTo(PdfFile)
PdfStream.Flush()
[Code]...
View 2 Replies
Mar 4, 2010
I have a .NET dll which I use from a C++ program. Now I have to register the dll programmatically on a deployment computer. How do i do that (programmatically! not using regasm)? I remember, when I once called a VB6 dll from a C++ dll, I had to use DllRegisterServer and DllUnregisterServer. Is that still so with a .NET dll? It seems I have to somehow add the dllregisterserver function to the .NET dll.
View 3 Replies
Jun 22, 2011
I have a customer that needs to convert XLS files to XLSB. Has anyone done this programatically, (with or without an add-on --- doesn't matter --- just need to be able to automate it)? I'm looking for a way to automate this.
As a side note, the customer is asking about this because they use Sharepoint, and it seems it has a way to analyze XLSB files quicker and easier than XLS??? I'm working to improve my Sharepoint knowledge, but in the meantime, I'm trying to find an answer to this XLSB issue.
View 2 Replies
Dec 26, 2011
Me.StuDetComboBox.DataSource = StudentsDet.BindingSource
Me.StuDetComboBox.DisplayMember = "StuName"
ComboBox Bind Programatically Like Above Right ?
View 8 Replies
Dec 11, 2010
I'll try to make this simple, using VB.Net on Windows Vista:How do you change key bindings programatically?I'm thinking it has to do with the registry so if it does just give me the registry key names(i know how to change the registry already)If it helps, the reason I want to do this is to change the Windows media center button so that it opens my program rather than WMC.
View 3 Replies
Oct 25, 2011
I have a window form and a ComboBox is placed on that form. I want to open combobox programatically on keypress event.
View 14 Replies
Dec 14, 2009
I'm working on a script in vb.net windows application and I need to import a table from one access database into another access database. I wanted to know if this was possible to do w/ out having to create the table and then loop through all the records to insert them into the table? In other words, is there some method that will allow me to import the table dirrectly as it is?
View 5 Replies
Jun 18, 2012
I've written an interface with a 3rd party web service in VB.NET. The final step in that interface involves the 3rd party delivering to us (as a stream) a PDF document. After streaming is complete I save a copy of the PDF on our servers, so that our users can view the PDF by clicking on a link in our system. The PDF opens fine in Acrobat X, but when I try to open it programatically I an error saying that "the file is damaged and could not be repaired". I can also open the file in IE just fine, with no issues, and the same code that displays this PDF works just fine on lots of other existing PDFs that predate the 3rd party interface.
I have emptied out temporary internet files as suggested in some posts I saw online. I also opened the PDF in Notepad++ and the %PDF tag is first, and the %%EOF tag is last, so there's certainly no corruption visible in the document source that I can see. Below is the (very standard) code we use to open PDFs into a separate browser instance on our site:
PDFFile = System.AppDomain.CurrentDomain.BaseDirectory & Request.QueryString("LetterPath") & Request.QueryString("Letter")
Response.Clear()
Response.ClearHeaders()
Response.BufferOutput = True
[code].....
View 1 Replies
May 16, 2012
I am reading values from a database (boolean) and if true, I want it to check a checkbox,and if false, keep the checkbox unchecked. The lines look like this: blEnergy.Items.FindByValue(1).Selected = track_usageIn this case, track_usage is a boolean value.This way does not actually create the check mark in the checkbox like I wanted it to. What is the best way to do this?
View 1 Replies
Oct 28, 2011
im trying to find a better way to end the application im working on right now programatically, sometimes a user simple wants to end it all and since in the properties of my project the program is set to only end after all forms have been closed, (oddly enough i close all forms and it still is executing so i use dispose method and then end) what would be the best way to end the application and free pc memory for everything attached to it? i use:
form1.dispose()
form2.dispose()
form3.dispose()
me.dispose()
End
as ive readed online, end simply stops the app and nothing else, which makes me think, does its data still persists in the ram? i want to clear everything and not leave useless resources anywhere.
View 3 Replies
Oct 9, 2009
I am trying to write a small app that searches the GAC for a dll. I have been trying to get this done but can't seem to find any resources online. I am using VS.Net 2008.
View 3 Replies
Oct 7, 2011
I'm trying to find a good VB.net example of setting a LaserJet to Duplex.
View 1 Replies
Feb 1, 2012
how to use the TIFF IFILTER programatically.
I just want to call it from the command line like this and get the OCR'd text back.
myprog filename.tiff
The windows 7 SDK has FILTDUMP which isn't source supplied, and anyway, when I use that I get
0x80004005
even when running as admin -
View 1 Replies
