I have this stored procedure that takes a few parameters like date and merchant ID, and basically goes through a set of if-then statements to build a SQL SELECT string.
When we upgraded from SQL Server 7.0 to 2000, the stored procedure still worked from Query Analyzer, but not in BCP. It used to work in BCP just fine with 7.0. The error I get now is:
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]BCP host-files must contain at least one column
What's really strange is, if I instruct the stored procedure to simply print the SELECT string, then cut-and-paste it into the end of stored procedure code (assigning it to the variable that already contains the SELECT string), then it works from BCP.
Any help would be greatly appreciated.
Aston
When we upgraded from SQL Server 7.0 to 2000, the stored procedure still worked from Query Analyzer, but not in BCP. It used to work in BCP just fine with 7.0. The error I get now is:
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]BCP host-files must contain at least one column
What's really strange is, if I instruct the stored procedure to simply print the SELECT string, then cut-and-paste it into the end of stored procedure code (assigning it to the variable that already contains the SELECT string), then it works from BCP.
Any help would be greatly appreciated.
Aston
