Results 1 to 2 of 2

Thread: isql - BCP -

  1. #1
    Join Date
    Nov 2002
    Posts
    94

    Unanswered: isql - BCP -

    Hi,

    I am new to SQL server. I installed sql server 2000. I want to BCP out data from a table. also want to use isql to get into the server getting error,

    for isql :

    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()).

    can any one help, what am I missing here...

  2. #2
    Join Date
    Nov 2002
    Posts
    94

    Re: isql - BCP - issues

    Originally posted by ramshree
    Hi,

    I am new to SQL server. I installed sql server 2000. I want to BCP out data from a table. also want to use isql to get into the server getting error,

    for isql :

    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()).

    can any one help, what am I missing here...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •