SQL Server 2000 bcp utility fails to export data with the below error message:
There is no OS level error
Specified server name attribute could not be found
You have a Sybase installation on the server which includes bcp.exe utility. The ‘Path’ environment variable contains the tools\binn path for both Sybase and SQL Server and the binn path of Sybase lies in front of the path of SQL Server. This ended up calling the bcp.exe of Sybase instead of SQL Server
Check the Path under the Environment variable
1. Edit the ‘Path’ under the Environment variable by putting the SQL Server 2000 tools\binn path ahead of Sybase.
2. A better option would to use the absolute path when invoking the SQL Server 2000 bcp.exe.
The customer must be aware that if we implement the first option this can cause the Sybase bcp.exe to fail as it did for SQL.
Gurlen Singh Sodhi
Rakesh Singh & Mukesh Nanda