Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 bcp.exe

Author  Topic 

VaSQL
Starting Member

1 Post

Posted - 2009-09-28 : 12:54:09
when I run bcp.exe from the command prompt I get this error message:
"it failed to start because sqlncli.dll was not found." I did a search on the server for bcp.exe and found 3 copies of bcp.exe. I just installed sql server 2008, there were older copies of sql sever. When I run bcp.exe from the binn dir of 2008 it works. Any way I can have bcp default to the 2008 dir when running bcp from the command prompt?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-09-28 : 13:06:23
Just change your path environment variable so that the 2008 dir is sooner than the other one.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page
   

- Advertisement -