Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

error using bcp Expand / Collapse
Author
Message
Posted Monday, June 18, 2007 7:11 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, October 29, 2009 2:35 PM
Points: 18, Visits: 22

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-sqlclup1wt214
-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

Post #374804
Posted Monday, June 18, 2007 10:31 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, June 28, 2013 8:25 AM
Points: 3,461, Visits: 347

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
Post #374822
Posted Monday, April 7, 2008 11:25 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 14, 2008 12:07 AM
Points: 6, Visits: 24
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
Post #481300
Posted Tuesday, April 8, 2008 4:20 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 9:10 AM
Points: 416, Visits: 568
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


Regards..Vidhya Sagar
SQL-Articles
Post #481381
Posted Wednesday, April 9, 2008 11:28 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 14, 2008 12:07 AM
Points: 6, Visits: 24
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
Post #482772
Posted Wednesday, April 9, 2008 11:58 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, October 18, 2013 4:06 PM
Points: 471, Visits: 589
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
Post #482779
Posted Thursday, April 10, 2008 3:03 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 14, 2008 12:07 AM
Points: 6, Visits: 24
The server is running and I am able to connect with the same credentials using QueryAnalyzer
Post #482857
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse