tags:

views:

11

answers:

0
Q: 

Running BCP.exe

Hello,

I have a system installation consisting of two servers, an application server and a database server.

I need to bulk upload csv files generated at the application CSV files from the application t the database server, so I am simply the bcp.exe application.

The database server is SQL server 2000 enterprise edition, the application sever has sql sever express 2005 ( for native client ) and I took the bcp tool from an SQL server 2005 installation and moved it to the application server.

Whenever I try to call the bcp from the command line it returns

"SQLState = HY000, NativeError = 0 Error = [Microsoft][SQL Native Client]Connection is not enabled for BCP" when I searched for this error I, technet I found the following:

The application using the BCP API must set the SQLSetConnectAttr or SQL_SS_COPT_BCP attribute before connecting.

The thing is I am not writing and code or calling any API, I am just using bcp.exe frmo command line.

does any one have an idea about this ?

related questions

sql server 2008: bcp_sendrow, issue: invalid time format
howto use bcp_bind to insert dateTime values in sql server (2008) ?
BCP Utility
SQL Server BCP utility not updating all rows under Vista (Windows Server 2008)
Handling datetime with bcp and format file
BCP utility corrupts data
Can't get windows task scheduler to run scheduled console application.
Use bcp to import csv file to sql 2005 or 2008
Copying large amounts of data into a SQL CE database
How to export SQL Server 2005 query to CSV
Exporting SQL Server data with redistributed components
Tool to do line content only compares
How to Export SSIS data on SQL Standard and Import with Bulk Insert on SQL Express?
What is the best way to save XML data to SQL Server?
How can I use the BCP Command in Linux?
How do you use a binarywriter to write the correct MS SQL native format for the Money data type?
What bcp format file that I'm gonna used to insert 59 columns?
How to save data from a semicolon delimited file using Bulk Insert in SQL Server 2005 and BCP 9?
Successful Implementations of NAnt bcp (SQL Server) Task?
sql server bcp xml data
SQL Server BCP insert additional columns
Best way to export/import MS Sql 2008 Geography data
BCP out Error in SQL2000: SQLState = 37000, NativeError = 4060
Can a BCP version 8.0 format file have a column name that is a SQL keyword?
How to export data from SQL Server 2005 to MySQL