error using bcp

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » error using bcp

error using bcp

Rate Topic

Display Mode

Topic Options

Author

Message

pavan kumar posani

Posted Monday, June 18, 2007 7:11 PM

Grasshopper

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

Sugesh Kumar

Posted Monday, June 18, 2007 10:31 PM

Hall of Fame

Group: General Forum Members
Last Login: Saturday, November 10, 2012 8:18 AM
Points: 3,461, Visits: 346

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

Aboobucker Sidique

Posted Monday, April 07, 2008 11:25 PM

Forum 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

vidhya sagar

Posted Tuesday, April 08, 2008 4:20 AM

SSC-Addicted

Group: General Forum Members
Last Login: Tuesday, March 19, 2013 2:45 AM
Points: 416, Visits: 521

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

Aboobucker Sidique

Posted Wednesday, April 09, 2008 11:28 PM

Forum 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

jezemine

Posted Wednesday, April 09, 2008 11:58 PM

SSC-Addicted

Group: General Forum Members
Last Login: Wednesday, January 11, 2012 9:54 AM
Points: 470, Visits: 588

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

Aboobucker Sidique

Posted Thursday, April 10, 2008 3:03 AM

Forum 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 »

Permissions