Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


error using bcp


error using bcp

Author
Message
pavan kumar posani
pavan kumar posani
Grasshopper
Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)

Group: General Forum Members
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-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


Sugesh Kumar
Sugesh Kumar
Hall of Fame
Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)

Group: General Forum Members
Points: 3471 Visits: 358

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
Aboobucker Sidique
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
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
vidhya sagar
vidhya sagar
SSC-Addicted
SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)

Group: General Forum Members
Points: 418 Visits: 620
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
Aboobucker Sidique
Aboobucker Sidique
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
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
jezemine
jezemine
SSC-Addicted
SSC-Addicted (481 reputation)SSC-Addicted (481 reputation)SSC-Addicted (481 reputation)SSC-Addicted (481 reputation)SSC-Addicted (481 reputation)SSC-Addicted (481 reputation)SSC-Addicted (481 reputation)SSC-Addicted (481 reputation)

Group: General Forum Members
Points: 481 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
Aboobucker Sidique
Aboobucker Sidique
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 24
The server is running and I am able to connect with the same credentials using QueryAnalyzer
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search