BCP error: Unable to open BCP host data-file

by Joe Hunter 12. February 2010 22:21

Encountered this error a few times this week. Two possible solutions:

1) Ensure that the SQL server instance is running under Local System

2) Ensure that the BCP data file has no spaces in path.

Tags: bcp

IIS Host header namesVery useful feature to host several websites under one IP address in IIS, these directions are for I...Use Openrowset to select from Access into SQL Server SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'C:\my_mdb.MDB';'ADMIN';'' ...Open source asp.net social network appsBest option so far: http://social.codeplex.com/ Other suggestions: - http://telligent.com/ - htt...