Results 1 to 7 of 7

Thread: Bcp

  1. 08-08-2003, 05:43 AM #1
    olutimi
    olutimi is offline Registered User
    Join Date
    Jul 2003
    Posts
    142

    Bcp

    While I was doing BCP data to an output file, I reciveed the error SQLSTATE 08001 Native Error =17 which means unable to connect to data store.
    Please help gurus out there.


    Regards
    Reply With Quote Reply With Quote
  2. 08-08-2003, 08:00 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    What's id used to connect to sql in bcp?
    Reply With Quote Reply With Quote
  3. 08-08-2003, 08:23 AM #3
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Post the bcp command you used.
    Reply With Quote Reply With Quote
  4. 08-22-2003, 07:07 AM #4
    olutimi
    olutimi is offline Registered User
    Join Date
    Jul 2003
    Posts
    142

    BCP

    Thanks.

    I have resolvd the problem (userid) It is Working ok.


    Regards
    Reply With Quote Reply With Quote
  5. 08-22-2003, 07:42 AM #5
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    Could you post the complete history of what happend and how you resolved.
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  6. 08-26-2003, 03:49 AM #6
    olutimi
    olutimi is offline Registered User
    Join Date
    Jul 2003
    Posts
    142
    Please find below the code i used.

    exec master..xp_cmdshell 'bcp pubs.dbo.authors out c:\bcpOutput\authors.txt -c -T -S\Username\ServerName -Uuserid -Ppassword'

    Any refinement would be appreciated.

    Thanks.


    Regards


    Olutimi
    Reply With Quote Reply With Quote
  7. 08-26-2003, 08:56 AM #7
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Seems you are missing -o option that specifies output file.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules