Yes, you are right. Database name does not need to be there. I added S option only when it was not working.

The real reason for it not working...

The output what I get is

usage: bcp {dbtable | query} {in | out | queryout | format} datafile

[-m maxerrors] ...