Hi,

What all should I check / set in order to connect to the SQL server using isql / osql / BCP nothing is working for me from the command prompt.
getting connection error as follows :

isql -Usa -SSQL2000 -Psa123

DB-Library: Unable to connect: SQL Server is unavailable or does not exist. Unable to connect: SQL Server does not exist or network access denied.
Net-Library error 67: ConnectionOpen (Connect()).


for BCP :

bcp ##abc1 out abc1.out -Usa -SSQL2000 -Psa123

SQLState = 08001, NativeError = 17
Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
SQLState = 01000, NativeError = 67
Warning = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).

need to fix it today.

please reply.
thanks.