The bcp utility fails to export the data:



SQL Server 2000 bcp utility fails to export data with the below error message:


Operating-system error:

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

SE,SQL Support

Rakesh Singh & Mukesh Nanda

TL,SQL support 

Comments (0)

Skip to main content