Results 1 to 7 of 7
  1. #1
    Join Date
    Nov 2002
    Posts
    94

    Unanswered: isql - bcp problem

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

    Thanks,
    Ram

  2. #2
    Join Date
    Jan 2003
    Location
    México City
    Posts
    31

    Re: isql - bcp problem

    Can you connect QA or EM to the same server with the same user/password in the same station?

  3. #3
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    Is sql2000 the name of teh m/c and did you install a default instance?

  4. #4
    Join Date
    Nov 2002
    Posts
    94

    Re: isql - bcp problem

    Originally posted by Cesar Fraustro
    Can you connect QA or EM to the same server with the same user/password in the same station?
    I can connect to this Server thro' Enterprise Manager and Query Analyzer with no problems.

    Thanks for your reply. Please help.

    Thanks,
    Ram

  5. #5
    Join Date
    Nov 2002
    Posts
    94
    Originally posted by nigelrivett
    Is sql2000 the name of teh m/c and did you install a default instance?
    No, I did not installed default instance, Its not my machine name too.

    Please let me know what I am missing,

    Thanks,
    Ram

  6. #6
    Join Date
    Jan 2003
    Location
    México City
    Posts
    31

    Reinstall?

    I've just tested your ISQL command with no trouble in my station to our MSSQL7, so if you can open a DOS session in your station and then type:

    C:\> cd \mssql7\binn
    C:\> isql -Usa -SSQL2000 -Psa123

    and you got the same error (and you can connect to your server via EM or QA), I suggest to reinstall SQL client in your station, and don't forget to apply the same service packs you already done in your server.

    hope this helps,
    César.

  7. #7
    Join Date
    Nov 2002
    Posts
    94

    Re: Reinstall?

    Originally posted by Cesar Fraustro
    I've just tested your ISQL command with no trouble in my station to our MSSQL7, so if you can open a DOS session in your station and then type:

    C:\> cd \mssql7\binn
    C:\> isql -Usa -SSQL2000 -Psa123

    and you got the same error (and you can connect to your server via EM or QA), I suggest to reinstall SQL client in your station, and don't forget to apply the same service packs you already done in your server.

    hope this helps,
    César.
    Thanks for your reply. I got the same error after reinstallation of SQL client on my PC, I tried isql from command prompt, got error.

    I download evaluation Copy from microsoft.com , is causing a problem ?

    Please heeeeeeelllllllllllppppppppppp.

    Thanks.

Posting Permissions

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