Post New Web Links

How to run a batch file with IIS and ASP.NET?

Posted By: Posted Date: September 29, 2010 Points: 0 Category :ASP.Net

Hi,

Apologies if my question is too broad but I eed pointers on how to tackle the following problem. Currently, I run a batch file that launches a series of automation tests on QTP (a test automation tool). The batch file contains a vbs script path and it takes three parameters. Each time smeone needs to run the automation, I have to do this manually.
What I'd like to be able to do is to allow other members of the team to access this functionality via an intranet web page. They would be able to login, choose the tests to run and then run them. My only other requirement is that the solution be based on .net and C# if possible. My current server is 2003 SP2.
What is the best way to achiveve what I want?
What is the recommended version of IIS and .NET framework to use?
How do I configure IIS to be able to run the vbs script?
I'm looking for a step-by-step approach if possible. I don't care if I have to convert the batch file into an executable or run the script directly, just as long as it is launched.
Thanks so much for your time.
B.

View Complete Post

More Related Resource Links

Run a batch file at server side

Hello, I am creating an intranet application which runs a batch file and create an xml file as result. Which i am using for further processing. My problem is when i am running my application from local machine batch file is running fine and creating xml,but when i am running it through iis nohting is happening,it meance process.start coudn't start command Prompt.I am using following code. I have given all permission to iis.Dim ProcessInfo As Diagnostics.ProcessStartInfoProcessInfo = New Diagnostics.ProcessStartInfo("cmd.exe", "/C " + Server.MapPath("~\myScript.bat")) Dim Process As New Diagnostics.Process ProcessInfo.CreateNoWindow = False ProcessInfo.UseShellExecute = False Process.StartInfo.WindowStyle = System.Diagnostics.ProcessWindowStyle.Normal Process = Diagnostics.Process.Start(Server.MapPath("~\Spandata\RunSpan.exe")) Process.WaitForExit(20000) Process.Close()

passing result from CS file to batch file?

Hello,I am trying to run a CS file within a batch file but so far nothing happens.. echo on cd \ net use z: \\CONFIGMGRTEST\SMSPKGC$\TST00014 rem FFCS-MultiPlatform.bat file rem a selection is made to know which program has to be launched rem SETTING THE LOCATION OF THE C# COMPILER SET framework=%SystemRoot%\Microsoft.NET\Framework\v2.0.50727 rem COMPILING THE CS FILE %framework%\csc Architecture-Processor.cs rem EXECUTING THE C# APPLICATION :32BIT C:\Source Files\Packages\FOREFRONT\x86\FFCS.bat goto END :64BIT C:\Source Files\Packages\FOREFRONT\x64\FFCS.bat goto END :END exit and the CS file is: using System; using System.Management; public class ManagementObject { public static void Main() { /// ManagementObject mo; mo = new ManagementObject("Win32_Processor.AddressWidth=''"); ushort i = (ushort)mo["Architecture"]; /// Test the Processor and populated the field to be tested in the batch file switch (i) { case 0: return "32 Bit"; break; case 9: return "64 Bit"; break; } } } How do I pass the 32 Bit and/or 64 Bit collected by the CS file to the batch file to be used to the if .... goto 32Bit or 64 BitsThanks,DomSystem Center Operations Manager 2007 / System C

Batch file for use with SSIS

Greetings all, I'm trying to run the following batch file outside of SSIS. DTEXEC /f "M:\Tim\SSIS\ImprtInvestOneNAVsGeneric.dtsx" /conf "M:\Tim\SSIS\EPIC.dtsConfig" \Package.Variables[User::FilePath].Value;"M:\Tim\SSIS" /SET \Package.Variables[User::SourceFileName].Value;"DIREXION_NAV.CSV" /SET \Package.Variables[User::DoneFileName].Value;"BIAUSC50.DONE" /SET \Package.Variables[User::SponsorID].Value;"56" /SET \Package.Variables[User::FileDescription].Value;"Direxion NAVs (USA)" /SET \Package.Variables[User::DBConn].Value;"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=M:\Tim\New Basket DB\EPICUDT_Development.mdb;User Id=admin;Password=;" /SET The purpose of this batch file is to allow our team to use the same SSIS package but with multiple file inputs. I am getting the following errors: - Requires a higher level edition. I've done some research on this and have found that you must have SSIS installed locallly (which I do, the services indeed running). I've also come across a 'fix' that says you can use the E

run dtexec on server from batch file on client machine

Hi I would like to enable a user to execute an SSIS (2005)ÃÂ package located onÃÂ a server.ÃÂ The client does not have any elements of SQL server installed on his machine so he cannot execute the package locally.ÃÂ At present he has to remote connect to the server and double click a batch file on the server that contains the dtexec script. I would like to have a batch file located on the client desktop that he can click, that willÃÂ run the dtsexec script on the server - as it will not work from the client machine.ÃÂ However every set of commands i try inevitably end up trying to run the package on the local machine, which obviously fails. Is there any way to have the client kick of the package and have it run on the server, without him actually having to directly remote desktop to the client? Thanks ÃÂ Guy

Excecuting sql batch file

I created a batch file to set db's online, that will be used after a server reboot in the event 1 or multiple db's do not come back online, my question is... I created this batch file in sql server 2005, and it will not work in sql 2000 or 2003, could I have done something wrong? Or is the issue that batch files are not backwards compatible? Thank you

Need help running sql as batch file that creates a list of borrowers

Our application database was recently upgraded from mssql server 2000 to 2008. I am unable to get a batch file that creates a list of updated
borrowers to run. It was running fine on Windows server 2000 (even after the upgrade to mssql 2008), but I
recently wiped that old server and installed windows server 2003. The
drive that the file lives on changed, so I changed the name in the
file, but it will not run. When I try to run it from a command prompt
I get the error:

'melcat_daily_borr_export.bat' is not recognized as an internal or
external command, operable program or batch file.

The text of the file is :
isql -S192.168.36.2 -Pmypassword -Umyusername
-iD:\Horizon\melcat\melcat_daily_borr_export.txt -b -h-1 -n -w800 -O
-ozv056pat%Date:~-4,4%%Date:~-10,2%%Date:~-7,2%.txt

I have tried running the command with the name in quotes, I have
changed the file to a .cmd rather than a .bat, all to no avail. The
sql that the file calls will run and return results. Yes I am using
my proper user name and password.

The text of the sql called is this:

use horizon
go

set nocount on
go

SET CONCAT_NULL_YIELDS_NULL OFF
GO

select
char(34)+convert(varchar(15),b.borrower#)+char(34)+char(44

Open a Batch File in Sql Store Procedure

I have to open a batch file automatically in sql. So i have used the below command.

EXECUTE master.dbo.xp_cmdshell 'D:\Databases\batch\123.bat'

Its worked for few times. After that its not working.

One time i have stopped before the process is complete.May be this is the issue.

Now its returns null value.

Can anyone help me how can i open the file in sql.

Thanks & Regards,

Visa.G

How to create a batch file using a stored procedure

Hi,

Please let me know how to create a batch file with some content in it, using a stored procedure in SQL 2000.

Thanks in advance.

Regards,

-Naren.

Calling remote batch file using Execute Process Task

Hi,

The requiement is to create excel file. I cannot run this code using SSIS vbscript task because this requires Microsoft.Office.Interop DLL which can not be installed on the dev / prod server. Hence using the SQL task the data exported to excel.

But now the excel is required to be updated to merge some cells. The approach we are thinking is to keep VBS file with required code to UNC path. Keep the BAT file running VBS file using CSCRIPT command in same location. Call the BAT file from SSIS package using Execute Process Task. This approach is tested in local system and also works on dev server. But somehow the sample code used to create excel is not creating excel to UNC path.

VBS code below

Const xlSaveChanges = 1
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = False
objExcel.Workbooks.Add
objExcel.Cells(1, 1).Value ="Test value"
objExcel.ActiveWorkbook.SaveAs(\\server.com\folder$\Demo\Excelfile.xls)
objExcel.Quit

The BAT used to call above VBS file is given below

cscript \\server.com\folder$\Demo\Excelfile.vbs

The above UNC path is used in execute process task package which runs fine. But the file is not yet created.

Appreciat

Creating Batch file to execute sql scripts

Hi friends,

i want to create batch file to execute all my .sql scripts.

I have all table ( all table scripts in single file ) ,Udds ( all udds in single file ) ,Stored procedures( separate file for each SPs ),Functions ( Separate file for each Functions ),Triggers and views scripts in .SQL file.

can anybody tell me how to create batch file for executing all these scripts in sql server ?.

while executing, it should ask Database name,server name, password. if these details are given then it should execute my all scripts in given database

, if any error thrown then that error and procedure name alone have to move to separate log file..

Please help me if this possible or any other easy way to do this..

Thanks - Ravi

How to call C# dll from a batch file?

Hi All,

As per the requirement I have written a C# code to access Active Directory and to fetch required data and to store it in a database. But this has to be scheduled everyday at the specific time. So I thought to create a batch file which can scheduled as well, but I stuck up with a question that can we call C# dll from a batch file? If we can how to achieve it? Please suggests me if anybody knows about this!

Cheers, Chetan

Not able to create scheduled task in windows server 2003 using a batch file

Hi,

I am working on a .net 1.1 windows forms application. We have windows 2003 service pack 2 as the server operating system which uses IIS 6.0.

We have a report generation section. User submits report from the screen(c# code) to run report on a specified time. This request will create a batch file with the AT command with the time specified by the user. This batch file will create an AT job in scheduled tasks window and this AT job will a call another scheduler. This scheduler will generate the report.

the AT command looks like T 16:32 /INTERACTIVE C:\Inetpub\wwwroot\mywebservices\bin\Schedulers.GenerateReport.exe

This is working fine in all servers except one server which uses windows 2003 standard edition. The problem is like it is not able to create the batch file and subsequently fails to create the AT job.

Is there any permission related issue by which it is not able to create the batch file from code.

Please advice me!!!

Key file creation with Batch Job

I have a batch job that pulls multiple files from FTP sites and saves them into a specified folder. I need the batch job to create a file that has all the names of the files I have downloaded. Is it possible to do this?

Passing Argument from Execute Process Task (SSIS) to a Batch File

Hi,

I have a batch process set up, which executes fine as long as the name of the file is built in. My Execute Process task in SSIS also runs this batch file with succes.

I would like to pass the name of the file as a parameter from the Task (SSIS) to this batch file. Looks like I am doing something wrong because it is failing.

This is the batch file:
C:
cd \Program Files\WS_FTP Pro\
wsftppro -s "local:D:\Folder1\Folder2\%1" -d HDMS:/To_HDMS/

--- The %1 is the parameter

The argument that I am passing in is in the 'StandardInputVariable'

Would really really appreciate some help! Thanks so much!

Vicky

failed when call batch file from SQL 2005 job

when i tried to call batch file from SQL job give me error

process can not created for job at step reason system can not find the file specified

howver when i run the commend from new query it work fine

xp_cmdshell ' C:\t.bat'

also i tried

xp_cmdshell ' \\servername \t.bat' but no benifit from inside the job

Could you please help me ?

Cannot run batch file from under IIS

I have a problem which is a recent development. We used to be able to run a batch file from IIS, but now we can't. I have tried several different approaches to this issue, none of them have worked. I tried to run the batch file under cmd using CreateProcess, CreateProcessWithLoginW, CreateProcessAs User, none of which worked. I now know that CreateProcesswithLogonW won't work on Windows 2003 Server. This is a C++ webservice by the way, running on Windows 2003 server using IIS 5.1. I have also tried running the batch file from a vbs script and calling the script in C++ using system("Scriptname") and that does not work either. I have run out of options, or at least the options that I know about. I learned that "EXEs in System32, which like CMD.EXE have "special" ACLs that prevent them from being launched remotely from IIS. CMD.EXE has further security checks inside of it to prevent being used to launch batch scripts launched remotely from IIS." So I have abondoned even attempting to run CreateProcess of anykind where I invoke "cmd.exe" to run a batch file. Which was why I tried the vbscript. I know this is a security issue. It has to do with either the NETWORK SERVICE account or the ASPNET account not having permission to do this. I have QA bre

Batch file to pass parameters - Masking password entry

Hi,

I am writing a batch file which would accept input parameters like username and password.

I would like to mask my password entry while typing it.ÃÂ Is there any way to do it?

Thanks,
Karthizen


Categories:

ASP.Net	Windows Application	.NET Framework	C#	VB.Net	ADO.Net
Sql Server	SharePoint	Silverlight	Others	All