Post reply

BCP SqlExpress

  • August 3, 2008 at 5:22 pm

    #72775

    Hello, I use SqlExpress.

    My query is:

    exec xp_cmdshell 'bcp Cards..ArchivoPlano OUT "C:\Log_20080803.txt" -S"USUARIO\SQLEXPRESS" -T -t "" -c'

    error:

    SQLState = S1000, NativeError = 0

    Error = [Microsoft][ODBC SQL Server Driver]Unable to open BCP host data-file

    NULL

    What am I doing wrong?

    Thanks....

  • August 3, 2008 at 5:30 pm

    #852476

    Are you sure folder C:\ on server USUARIO is open for writing for your user?

    _____________
    Code for TallyGenerator

  • August 3, 2008 at 5:43 pm

    #852477

    I don't know, but i use other folder and it was successful.

    Thanks...

    But, how can i create the file in the folder c:?

    Thanks for your help...

  • August 3, 2008 at 6:03 pm

    #852482

    You better don't use C:\ ever.

    Giving users full access to C:\ folder on a server is not the bast idea.

    Use shared folders or URL locations.

    _____________
    Code for TallyGenerator

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply