error using bcp

Question

Post reply

error using bcp

pavan kumar posani

SSC Veteran

Points: 270
More actions
June 18, 2007 at 7:11 pm

#372239

Hi iam getting the following error when iam using bcp
C:\>bcp scp2.dbo.Inventory_Target_Level out \\kzo-sqlclup1\adexa\quantum_inv_tgt
_lvl.dat -f \\kzo-sqlclup1\adexa\quantum_inv_tgt_lvl.fmt -S kzo-sqlclup1\nwt214
-U quantumuser -P g00fy
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Unable to open BCP host data-file

please help me to resolve this issue
Its really urgent
thankyou
pavan posani

Viewing 7 posts - 1 through 6 (of 6 total)

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

Sugesh Kumar One Orange Chip Points: 27311 More actions · Answer 1

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=120&messageid=237238

The link above will solve the issue. Try and let us know.

Pavan,

My kind advice. You have posted your query as such and it has your user name and password in it. See to that you dont reveal such inform to others than the concerned persons. It will surely harm the security of your system.

Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com

Aboobucker Sidique SSC Veteran Points: 216 More actions · Answer 2

I am getting this error while using bcp in 2005

SQLState = 28000, NativeError = 18456

Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'SA'.

THe bcp command worked fine when we used SQL server 2000.

THe sql server 2005 connects with SQL authentication mode+windows authentication mode

Vidhya Sagar SSCrazy Eights Points: 8216 More actions · Answer 3

[font="Courier New"]Hi Aboobucker,

Can you check the password for SA used in BCP is correct?? You can check the below link for 18456 error and description based on the severity.

http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx[/font]

Regards..Vidhya Sagar
SQL-Articles

Aboobucker Sidique SSC Veteran Points: 216 More actions · Answer 4

My command is this

bcp testdatabase.dbo.[dimension_72] in E:\HR.txt -S chennai\SQL2005 -USA -PSA -f E:\HR_unq.fmt -e E:\HR_unq_error.log -o E:\HR_unq_bcp.log -t "" -r

THe error is as follows:

SQLState = 08001, NativeError = -1

Error = [Microsoft][SQL Native Client]SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].

SQLState = HYT00, NativeError = 0

Error = [Microsoft][SQL Native Client]Login timeout expired

SQLState = 08001, NativeError = -1

Error = [Microsoft][SQL Native Client]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

I have set SQL server 2005 to accept remote connections as instructed in microsoft site.

then also same error

jezemine SSCrazy Eights Points: 8059 More actions · Answer 5

are you sure the server is running? are you able to connect from the same client machine through another method using the same credentials, such as SQLCMD or SSMS?

---------------------------------------
elsasoft.org

Aboobucker Sidique SSC Veteran Points: 216 More actions · Answer 6

The server is running and I am able to connect with the same credentials using QueryAnalyzer