Thread: Bcp
-
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
-
What's id used to connect to sql in bcp?
-
Post the bcp command you used.
-
BCP
Thanks.
I have resolvd the problem (userid) It is Working ok.
Regards
-
Could you post the complete history of what happend and how you resolved.
-
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
-
Seems you are missing -o option that specifies output file.
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
|
|