dbTalk Databases Forums  

Running BCP from a webserver

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss Running BCP from a webserver in the microsoft.public.sqlserver.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Robert Complusman
 
Posts: n/a

Default Running BCP from a webserver - 06-07-2004 , 02:37 PM






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?

Reply With Quote
  #2  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: Running BCP from a webserver - 06-13-2004 , 06:18 PM






Robert Complusman (anonymous (AT) discussions (DOT) microsoft.com) writes:
Quote:
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 (AT) sommarskog (DOT) se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp


Reply With Quote
  #3  
Old   
John Bell
 
Posts: n/a

Default Re: Running BCP from a webserver - 06-14-2004 , 11:15 AM



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 (AT) discussions (DOT) microsoft.com> wrote

Quote:
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?



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.