Post reply

BCP Error

  • July 2, 2004 at 10:24 am

    #85725

    Can anyone give me an idea of what this message truly means?

    ::Error::

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

    Thanks you

    Mike

  • July 2, 2004 at 10:56 am

    #513204

    Could mean several different things.

    1. The BCP format file is missing
    2. The BCP format file is corrupt
    3. The command calling the BCP is mis-typed
    4. The user attempting to run the BCP doesn't have permission to open the file

    Unfortunately, this is another of the nicely written error messages that we all know and love.....



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • July 5, 2004 at 9:34 pm

    #513371

    5. The file you trying to read in is locked - being edited or held open by the OS ??

     


    The systems fine with no users loggged in. Can we keep it that way ?br>

  • July 6, 2004 at 12:07 pm

    #513507

    It also could mean that the destination path doesn't exist or is incorrect (typo?).  I think I've also gotten it before when bcp.exe wasn't installed in the default directory.  Try using the full path there as well (i.e. F:\mssql\bcp.exe or wherever).

    Linda

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

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