running batch file from ASP 3, IIS 6, windows 2003

senp · April 20th, 2015, 06:07 AM

Hi,

I setup an ASP 3 application in IIS 6 on Windows 2003 server. In a page it executes a dos batch file but does not execute it. It does not give an error either. The batch file is running fine when runs through the command prompt. It seems the problem is not in code but in the system.May someone please suggest me what is wrong.

The ASP code is like this:
<%@ LANGUAGE="VBSCRIPT" %>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual InterDev 1.0">
<META HTTP-EQUIV="Content-Type" content="text/html;
charset=iso-8859-1">
<TITLE>Test Nested Virtual Roots</TITLE>
</HEAD>
<BODY>

<%

dim WShShell, BatFile, Pth, RetCode

Pth = "D:\\finetest\\finetestin\\LD\\"

Set WShShell = Server.CreateObject("WScript.Shell")

WShShell.CurrentDirectory = Pth

BatFile = Pth & "simple.bat" +" " & "hello"

RetCode = WShShell.Run(BatFile, 0, true)

%>
<BR>
<P>

</BODY>
</HTML>

Simple.bat :
echo Parameteter = %1> Var.txt
Batch file and Var.txt exists in D:\finetest\finetestin\LD\

Thanks
Senp

senp · April 20th, 2015, 08:29 AM

The code will be like this :
BatFile = Pth & "simple.bat" & " " & "hello"
However that is not solving the problem.

Thanks,
senp

mat41 · April 21st, 2015, 07:02 PM

IMO there is nothing wrong with your code. As you have pointed out you can not use + like you have, it must be a &.

The code for doing this is simple, there are loads of examples out there. The most common issue is permission related but this will present its self at run time so its probably not your issue. Your issue does not appear to be with the .asp page.

I use windows schedules tasks to fire .bat file personally.

senp · April 22nd, 2015, 06:23 AM

Thanks Matt,
Could you please put some more info. (code please) as how you do it and also how to schedule a task for the batch file, I need to fire it when I open the page in the browser?

Thanks,
Senp.

mat41 · April 23rd, 2015, 12:10 AM

Using windows scheduled tasks (or cron jobs is think they are called in unix) are the unattended way to fire things. It gets fired without user interaction on a schedule. E.G daily at 6pm. This is not an option if you need your batch file to fire based on an end user action. Your code/approach is what I would do if I had this requirement.

To be honest in all my years classic ASP I have never needed to use a .bat file for anything. Can you not achieve your objective in a .asp file? Why does it need to fire a .bat file.

Lastly - I cant help you with your code. It looks good to go to me. Without an error or a specific issue I doubt may could

senp · April 23rd, 2015, 08:17 AM

Quote:

Originally Posted by mat41

Using windows scheduled tasks (or cron jobs is think they are called in unix) are the unattended way to fire things. It gets fired without user interaction on a schedule. E.G daily at 6pm. This is not an option if you need your batch file to fire based on an end user action. Your code/approach is what I would do if I had this requirement.

To be honest in all my years classic ASP I have never needed to use a .bat file for anything. Can you not achieve your objective in a .asp file? Why does it need to fire a .bat file.

Lastly - I cant help you with your code. It looks good to go to me. Without an error or a specific issue I doubt may could

Hi Matt,

Thanks for your reply.
I need actually to get some value from LDAP browser. For the one ASP page is using a batch file that calls Jar file to communicate and fetch data from LDAP. Batch file execution and getting value from LDAP was working fine in IIS 6 and Win 2003 sever, but may be some system update it stopped working. So, trying to find out the solution.

Now trying to communicate the LDAP server directly through ASp code:

var ldapurl = "LDAP://v******:**9/";
var ldapcontxt = "ou=***,ou=****,o=****,c=**";
var LDAPServerString = ldapurl + ldapcontxt;
var ldapuser = "cn=****,ou=****,ou=***, o=****,c=****";
var ldappwd = "********";

var objCommand = Server.CreateObject("ADODB.Connection");

objCommand.Provider = "ADsDSOObject";
objCommand.Properties("Encrypt Password") = 0;
objCommand.Open ("ADs Provider",ldapuser,ldappwd);

var strADOQueryString = "SELECT *****";
strADOQueryString += " FROM '"+Application("LDAPServerString")+"' ";

While running this piece of code is giving error:
Provider error '80040e37'
Table does not exist.

it's coming from this piece of code:
var strADOQueryString = "SELECT *****";
strADOQueryString += " FROM '"+Application("LDAPServerString")+"' ";

With the same properties and credentials I can see data through LDAP browser.

May you help?

Thanks,
senp

senp · April 23rd, 2015, 08:45 AM

Quote:

Originally Posted by mat41

Using windows scheduled tasks (or cron jobs is think they are called in unix) are the unattended way to fire things. It gets fired without user interaction on a schedule. E.G daily at 6pm. This is not an option if you need your batch file to fire based on an end user action. Your code/approach is what I would do if I had this requirement.

To be honest in all my years classic ASP I have never needed to use a .bat file for anything. Can you not achieve your objective in a .asp file? Why does it need to fire a .bat file.

Lastly - I cant help you with your code. It looks good to go to me. Without an error or a specific issue I doubt may could

Hi Matt,

Thanks for your reply.
I need actually to get some value from LDAP browser. For the one ASP page is using a batch file that calls Jar file to communicate and fetch data from LDAP. Batch file execution and getting value from LDAP was working fine in IIS 6 and Win 2003 sever, but may be some system update it stopped working. So, trying to find out the solution.

Now trying to communicate the LDAP server directly through ASp code:

var ldapurl = "LDAP://v******:**9/";
var ldapcontxt = "ou=***,ou=****,o=****,c=**";
var LDAPServerString = ldapurl + ldapcontxt;
var ldapuser = "cn=****,ou=****,ou=***, o=****,c=****";
var ldappwd = "********";

var objCommand = Server.CreateObject("ADODB.Connection");

objCommand.Provider = "ADsDSOObject";
objCommand.Properties("Encrypt Password") = 0;
objCommand.Open ("ADs Provider",ldapuser,ldappwd);

var strADOQueryString = "SELECT *****";
strADOQueryString += " FROM '"+Application("LDAPServerString")+"' ";

While running this piece of code is giving error:
Provider error '80040e37'
Table does not exist.

it's coming from this piece of code:
var strADOQueryString = "SELECT *****";
strADOQueryString += " FROM '"+Application("LDAPServerString")+"' ";

With the same properties and credentials I can see data through LDAP browser.

May you help?

Thanks,
senp