Running isqlw/bcp/any exe from windows 2003 using web application

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi,

I have developed a web site for my client on .net 2.0 framework using
asp.net 2.0. This web site will be hosted on Windows 2003 server.

Web application runs the batch file on the user button click. This
batch file runs isql, isqlw or bcp utility of sql server to pull the
data from database. This command generates the .csv file by executing
the query.

Initially this web app was hosted on Windows 2000/XP server and it
worked fine. It had generated CSV file using isqlw but moment I hosted
everything on Windows 2003 and it cannot generate the .csv file. The
batch file is still getting executed so its not a problem in executing
the batch file. The problem is it cannot execute the isqlw command.

On windows 2003, I am using a service account for the application
pool. Now what I don't know is how to give an access to this service
account to execute the isqlw.exe or bcp.exe or to that matter any exe.

Has anyone done like this?? Can any one help me on this?

Help is really appriciated.

Prateek Baxi

.

Quantcast