Command Line Execution
I have this command-line which I do execute it manually.I am curious if anyone can help to execute the command-line from an asp page using vb.
View RepliesI have this command-line which I do execute it manually.I am curious if anyone can help to execute the command-line from an asp page using vb.
View RepliesIm trying to use teh command line, for now i just want to do something realllly basic like opening a txt file. and then later i can do some more advanced stuff, but for now i just want to know if i can use the command line, right now i just have Code:
<%
Dim oShell,sCommand
sCommand = "test.txt C:"
Set oShell = Server.CreateObject("Wscript.Shell")
oShell.Run sCommand, , True
Set oShell = Nothing
%>
What is the proper syntax to run this command line in ASP?
wzzip.exe File.zip File.txt
Does anyone know how to execute command line in ASP?
View Replies View RelatedI want to know IExplore.exe command line options, basically I want the command line equivalent of the following line:
Window.open(strUrl, winID, "toolbar=no, scrollbars=yes, location=no,
statusbar=no, menubar=no, personalbar=no resizable=yes, left = 50, top =
25");
I'd like to send a variable generated in the script back to a batch file.
I can run the batch file by using objShell.Run(lock.bat filename). My
batch file lock.bat runs fine with the argument "filename", the
problem is that "filename" is actually a variable that is created in
the script and I want the value passed to the batch file, not the
label. Any ideas/sampe code
I am running a dynamic site using MySQL and ASP and wish to back up my MySQL DB on a daily or weekly basis to a remote server/MySQL DB. I know how to do this from the command line using MySQL:
mysqldump -u username -p password --databases myDatabase | mysql -u username -p password -h remote.server.com
But i need to be able to issue this command from within an ASP page. PHP has various methods for executing command line queries such as exec() & shell_exec() but I don't know any using ASP.
Can someone give me some sample code on how one would go about executing a
command line "command" from within an ASP form?
We need to run an application called GnuPG which allows us to encrypt an
email.
Preferably some documentation directly on this would be good but any other
docuemtnation on executing a command line "command" would be great!
I need an ASP code that will pass some variables as options to a command line.
Let's say I need to execute a program with some options and I need the user
to select the otions from the web interface.
The command line will look something like this:
Program.exe /usename:username /password:password /options:option1,option2,option3
The the user will access a web page and it will be asked for the username , password and
it will be able to select the options by marking them on the page.
After the selection the command line will be executed with the selected oprions.
If somebody can point me to some example code or any hints to get me started I would
appreciated it.
It is possible to specify also the credentials the "program.exe" should run under?
I am using command line utility of wzzip.exe in asp and vb script. When I try to use wzzip in asp, it sometimes works fine and sometime hangs. It doesn't give any error.
The server that the process is running on, if I logoff from that server, wzzip.exe hangs, however when I just "disconnect" from the server, it runs fine. This happens when I try to use wzzip.exe from my user interface. The code to invoke the shell is in a dll which resides in MTS. I am using the following wzzip command in asp.
cmd.exe/c "c:Program fileswinzipwzzip.exe -a
servernamefolderfilename.zip servernamefolderfolder_to_be_zipped
When I run it manually command line, there are no problems.
I have a similar job which I have in vbscript, that job runs without any
issues.
I am getting the above error when trying to execute the following code:
View Replies View RelatedI had created a macro to read data from an excel sheet and write the values to a text file. I had used "ActiveSheet.Range("GB" & k).Value" command to read the values from the excel.some cells in the excel sheet is having two lines value and four lines data, the text file is generating that value in a single line. (Ex. the cell value in address column is in four lines and should display in four lines in the text file generated from the macro)
Can i do something in the excel sheet or in vb script to read the address value line by line and write line by line in text file?
I have an online application. I get the following error when a user selects an option from one drop down list but doesn't select an option from another drop down list. Here is the error:
Microsoft OLE DB Provider for SQL Server error '80040e0c' Command Text was not set for the command object. Code:
I have an online application. I get the following error when a user selects an option from one drop down list but doesn't select an option from another drop down list. Here is the error:
Microsoft OLE DB Provider for SQL Server error '80040e0c'
Command Text was not set for the command object.
Line 87
Line 87 = rs1 = conn.execute(finalSQL)
Here is the page causing the error. Code:
I keep getting this error. I searched the forums, and found one. It said to basically replace elseif with else. It worked for that person.
I tried it and it didn't work. So what i decided to do was, remove all of the if statements and keep one. Even with just one if statement i get the same problem. Does anybody know what is wrong? It worked fine, up until i added the if statement. I need them there though for a reason.
Personally i think, it;s not getting the value from the request form, and hense it isn't picking anything up. What do you lot reckon? Code:
I have an encrypted .txt file created by asp. Its formatted with lines etc. Title followed by description underneath. I need to read this into ASP now, and parse it line by line. On each line read, run the function to unencrpt and add line to a new file.
Its the line by line Im having trouble with. If i do the full textstream no formatting takes place coz im adding the fulltextstream all in one addline call. How can I loop through lines ?
An ASP script written in ASP.NET has worked fine on one computer, and since it has been moved to another, it doesn't.
The part that does not work deals with executing CMD.EXE. Here is a part of the code:
System.Diagnostics.ProcessStartInfo psi = new System.Diagnostics.ProcessStartInfo("cmd.exe");
psi.UseShellExecute = false;
psi.RedirectStandardOutput = true;
psi.RedirectStandardInput = true;
psi.RedirectStandardError = true;
psi.WorkingDirectory = @"c:SOME PATH";
System.Diagnostics.Process proc = System.Diagnostics.Process.Start(psi);
System.IO.StreamReader sOut = proc.StandardOutput;
System.IO.StreamWriter sIn = proc.StandardInput;
sIn.WriteLine("SOME COMMAND LINE PARAMETERS");
...and instead of executing like it did on the last server and displaying the output, it creates a web page with the following output:
Microsoft Windows [Version 5.2.3790]~(C) Copyright 1985-2003 Microsoft Corp.~~c:SOME PATH>SOME COMMAND LINE PARAMETERS"~~SOME PATH>EXIT
...followed by the rest of the web page as it did before.
What I figured is that for some reason this script on the new server instead of executing the command, it just sends it as an output to HTML.
I have tried to readjust .NET security, then to adjust the folder permissions (I gave EVERYONE permissions to all the needed folders). Nothing helped.
I have got a problem executing a query. The driver indicates an error in Internet Explorer : No value given for one or more required parameters It refers to the recordset definition. I have tested the query in my DBMS, it works.
SOURCE :
Dim objConn
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source= " & server.mappath (BDname) "
Dim StrSQL
StrSQL = " SELECT NOM FROM ATTRIBUT WHERE LIBELLE = TRUC"
Dim rcdSet
rcdSet = Server.CreateObject("ADODB.Recordset")
rcdSet.Open StrSQL, objConn , adOpenForwardOnly, adLockPessimistic
I currently have an asp page that ask for an email address and then with selection values runs a stored procedure.
Everything runs fine but the concern is that with enough records the processing limit will be exceeded by the web server and it will cause the page to crash.
Is there a way with ASP and MSSQL to send a request to process a stored procedure but have the processing of the asp continue while the sql runs its cousre? My sp will already email the user when processing is complete I just need the asp to send the request for it to be run but not try and run it while the next page loads.
The statement was made that the following code works.
Is This ture?
stringa = "response.write 1"
Execute(stringa)
Timed Execution for Access Database?
I was reading a book about access databases and sql, when i came upon the time execution part it simply said it could be done but did not go into details as to how. Does anyone out there know of a way to produce a time execution with a access database?
ex: ability to set an email to be sent out on the 1st of january at 5pm, and on that date/time it would send it out. I know that you can simply have a asp page check the time when opened and if it's the correct time use a function to send it, BUT is there a way to do it with out having to go to the page on that time???
Is there a way to execute sql queries besides using recordset? If so, can someone provide me with links to materials i can read online or post an example?
View Replies View RelatedI have an asp page that contains a simple insert statement and redirect i.e.:
Page1.asp
<%oconn.execute "insert into table 1 values(1)"
response.redirect "newpage.asp"
%>
I have to add some code to it to not allow execution of this script if the page was called from the <img> tag i.e.
<img src=http://webname.com/page1.asp width=1 height=1>
The page should be opened in browser in order for the script it contains to be executed. How do i acomplish that?
i do have a little problem.....i have 2 difrent functions in my asp pages. function1 and function2.
funktion 2 has to be executet 15sec after function 1 had been executet.how can this be solved in ASP, and is it impossible.
How do I execute a users program from a web page? When a user goes to a webpage - I want a link on that page that will execute a program on the users local hard drive - like say...notepad.exe . Everything I have tried will only execute it on the server.
View Replies View RelatedI have a problem: I have an ASP page who takes a lot of time in execution, but I want to "abort" it when the user make click in a link. I have heard I can use the Response.IsClientConnected, but I am not sure if this will work.
View Replies View Relatedhow can i stop execution. in betweeen a few lines of code. i dont want the complete execution of code and in middle i want to stop?
View Replies View RelatedIn an asp file, the statements are like this,
1. HTML Tags
2. Javascript
3. VBScript
4. HTML Tags
5. asp coding
6. Javascript
7. VBScript
8. asp coding
9. HTML
tell me the sequece of execution in an asp file.
I am doing a search application in ASP with SQL Server 2000. I am using a third party DLL to fetch the matched records in 1 sec, it’s working fine in the local machine.
I tried it in following OS
Windows 2000 Sever
Windows 2000 Professional
Windows 2003 Sever Standard Edition
But my client server is Windows 2003 for Small Business Server. My code is not working in this server. I don’t think this may be an OS issue This is the code I have used for search:
SELECT {score},* FROM tbl_customers_detail WHERE {udv001_index=0 order by f_order.FakturaNr desc,score}
Here score is the option given in the tool (Third party tool). This score is used to arrange the matched records in either ascending or descending order.
tbl_customers_detail – Table (It contains around 6 lakhs records)
f_order – is the order created for the field FakturaNr (This order is used to pass the particular filed as an argument for the dll.)
but I am receiving the following error
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'TBL_CUSTOMERS_DETAIL'.
/admin/searchmore.asp, line 136
I have connected with the exact DB contains the table tbl_customers_detail.
Basicly, when the page is in bad performance, the user will feedback to me, and later I tune it for better performance.
Is there any way or software to trace all the ASP pages' execution time in my site, so that I can tune it before user's feedback and have an overview of all my pages execution?
I'm using Asp 3.0 and windows 2000 and SQl server 2000 as back end My problem is every day morning 8 i want to take some data from the data base and send a mail to some mail ids which i retrieve from the database.
I want this to be executed at 8 Am every morning automatically. Is there any way to schedule the execution of the asp page at a particular time. Or any other ways r there like using vb script?
when I create a function like this one :Code:
Function fctCheckEmail(conn, email)
Dim rsEmail : Set rsEmail = Server.CreateObject("ADODB.RecordSet")
rsEmail.open "SELECT dbo.fctCheckEmail('" & email & "')", conn
fctCheckEmail = rsEmail(0)
Set rsEmail = Nothing
End Function
Im closing the rsEmail object at the end of the function, after returning the function value. Is the rsEmail Object will be actually close or the code will execute the return value and skip the rest of the code ?
This is backwards of what I usually want--normally if you have a long-running ASP script, it's a good idea to check to see whether the client is still connected so you can cancel execution.
However, I have a script that absolutely MUST finish one it's been started--is there a way to cause the entire script to execute, even if the client disconnects in the middle of the process? It doesn't matter if the script returns anything to the client, but once it starts saving values to the database I need it to finish .