Running BCP from a webserver

I am executing BCP within a web application. SQL Server
client is not installed on the web server there although
we have copied the BCP.exe and BCP.RLL, an error message
displays saying it is missing the Resource Library. What
are my options to get this work?
Robert Complusman (anonymous@.discussions.microsoft.com) writes:
> I am executing BCP within a web application. SQL Server
> client is not installed on the web server there although
> we have copied the BCP.exe and BCP.RLL, an error message
> displays saying it is missing the Resource Library. What
> are my options to get this work?
The simplest would be to run the SQL Server install on the web server,
and install "Tools and utilities only". Now, whether this is
compliant with your license, I don't know.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
|||Hi
Maybe you would be better using Bulk Insert?
You may also want to consider using a DTS job to get (FTP) the file and put
it onto a different server, then process it.
John
"Robert Complusman" <anonymous@.discussions.microsoft.com> wrote in message
news:1974701c44cc6$df510140$a001280a@.phx.gbl...
> I am executing BCP within a web application. SQL Server
> client is not installed on the web server there although
> we have copied the BCP.exe and BCP.RLL, an error message
> displays saying it is missing the Resource Library. What
> are my options to get this work?
sql