Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2006

    Unanswered: Unable to load bcp resource DLL. BCP cannot continue

    I get the message when loading the bcp. I check the path variable and the sqlserver BINN directory is there, but twice. If I try opening the command window and write bcp, I get the error, if I enter the whole path c:\...\80\tool\binn\bcp there is no problem. I wonder what could it be?

    I've manually reinstalled many times but still having trouble.

    Thanx in advance

    SQL SERVER 2000 or SQL SERVER 7 (I've tried with both)

  2. #2
    Join Date
    May 2004
    maybe your path is referencing a different bcp.exe, not the one in the binn directory.

    you can test it by putting the path to the known working bcp.exe first in line in your PATH env var.

  3. #3
    Join Date
    Oct 2007
    This might be a terrible practice, but I use Sybase far more than mssql... so I just renamed the mssql version as "mbcp.exe." Again, I could see how this could be problematic down the line (especially if you forgot you did it) - but the technique has served me well for several years now.

Posting Permissions

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