Hi,
I 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