Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Location
    Melbourne
    Posts
    144

    Unanswered: BCP SQL Server 6.5

    i need to get some data out from a SQL Server 6.5

    i tried using the BCP

    bcp iac.dbo.sf_profil out c:\test.bcp /c /Slocal /Usa /Pabc123

    bcp iac.dbo.sf_profil out c:\test.bcp /c /Svots138svr09 /Usa /Pabc123

    bcp iac.dbo.sf_profil out c:\test.bcp /c /S(local) /Usa /Pabc123

    but still was unable to run

    the error message
    DB-library error
    unable to connect : SQL Server is unavailable does not exist

  2. #2
    Join Date
    Dec 2004
    Location
    California, USA
    Posts
    93
    Are all three command lines failing? The first one seems to be referencing a server named "local" instead of the (local) server. Also, when in doubt, explicitly use the name of the local server.

    Not to be completely anal-retentive but are the user and password valid and capable of accessing the database and objects?
    Whoever imagines himself a favorite with God holds others in contempt. - Robert Green Ingersoll, lawyer and orator (1833-1899)

  3. #3
    Join Date
    Nov 2005
    Location
    San Francisco, CA
    Posts
    506
    Quote Originally Posted by jcwc888
    i need to get some data out from a SQL Server 6.5

    i tried using the BCP

    bcp iac.dbo.sf_profil out c:\test.bcp /c /Slocal /Usa /Pabc123

    bcp iac.dbo.sf_profil out c:\test.bcp /c /Svots138svr09 /Usa /Pabc123

    bcp iac.dbo.sf_profil out c:\test.bcp /c /S(local) /Usa /Pabc123

    but still was unable to run

    the error message
    DB-library error
    unable to connect : SQL Server is unavailable does not exist
    In sql server 2000 ,
    With default format,you could run
    exec master..xp_cmdshell 'bcp test.dbo.jojo out c:\test.txt -c -T -Sservername -Usa -Psecrectcode'

    Joydeep
    Last edited by rudra; 03-13-06 at 20:52.

Posting Permissions

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