BCP will not work - I can not get a connection - any thoughts?
bcp "server.dbo.view for horizon" out "c:\mytest.txt" -c -t, -U [user] -P [pw]
The user is a a SQl server suthentication account with read access from the view.
SQLState = 37000, NativeError = 4060
Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database requ
ested in login 'server'. Login fails.