bcp error

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » bcp error

bcp error

Rate Topic

Display Mode

Topic Options

Author

Message

Posted Sunday, February 24, 2013 10:26 AM

SSC Journeyman

Group: General Forum Members
Last Login: Friday, April 26, 2013 11:23 AM
Points: 76, Visits: 188

Dear Experts

I exported data table by bcp succesfully in txt file, I want to import this file in different sql server but this error occured

C:\Users\Dell>bcp medica.dbo.patient in d:\patients.txt -c -t -Shome\mssqlserver -Usa -PP@ssw0rd

SQLState = 08001, NativeError = 87
Error = [Microsoft][SQL Server Native Client 11.0]SQL Server Network Interfaces: Connection string is not valid [87].
SQLState = 08001, NativeError = 87
Error = [Microsoft][SQL Server Native Client 11.0]A network-related or instance-specific error has occurred while establishing a connection
to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote conn
ections. For more information see SQL Server Books Online.
SQLState = S1T00, NativeError = 0
Error = [Microsoft][SQL Server Native Client 11.0]Login timeout expired

any help,thanks

Post #1423425

Posted Sunday, February 24, 2013 10:31 AM

SSC Journeyman

Group: General Forum Members
Last Login: Friday, April 26, 2013 11:23 AM
Points: 76, Visits: 188

when I wrote on -Shome not -Shome\mssqlserver

this error occured

C:\Users\Dell>bcp medica.dbo.patient in d:\patients.txt -c -t -Shome\mssqlserver -Usa -PP@ssw0rd

SQLState = 08001, NativeError = 87
Error = [Microsoft][SQL Server Native Client 11.0]SQL Server Network Interfaces: Connection string is not valid [87].
SQLState = 08001, NativeError = 87
Error = [Microsoft][SQL Server Native Client 11.0]A network-related or instance-specific error has occurred while establishing a connection
to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote conn
ections. For more information see SQL Server Books Online.
SQLState = S1T00, NativeError = 0
Error = [Microsoft][SQL Server Native Client 11.0]Login timeout expired

Post #1423427

MyDoggieJessie

Posted Sunday, February 24, 2013 11:23 AM

SSCrazy

Group: General Forum Members
Last Login: Friday, May 17, 2013 8:50 AM
Points: 2,037, Visits: 3,759

Do you have a linked server set up and allowed remote connections to it?

______________________________________________________________________________
"Never argue with an idiot; They'll drag you down to their level and beat you with experience" Wink

Post #1423435

Posted Sunday, February 24, 2013 11:34 AM

SSC Journeyman

Group: General Forum Members
Last Login: Friday, April 26, 2013 11:23 AM
Points: 76, Visits: 188

do you want to enter my server remotly?

we can use program named by teamviewer

Post #1423437

Posted Sunday, February 24, 2013 12:25 PM

SSC Journeyman

Group: General Forum Members
Last Login: Friday, April 26, 2013 11:23 AM
Points: 76, Visits: 188

any help

Post #1423440

SQL Pizza

Posted Monday, February 25, 2013 12:41 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 5:14 AM
Points: 116, Visits: 293

Is SQL Server Browser runnning on the database machine?

Greetz
SQL Pizza

sometimes you dont see the pizza for the toppings...
seek and ya shall find...

Post #1423488

opc.three

Posted Thursday, February 28, 2013 10:52 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 1:49 PM
Points: 6,703, Visits: 11,733

Did you get it resolved?

A shot in the dark:

You specified home\mssqlserver

mssqlserver is the hidden instance name handed to default instances of some versions of SQL Server. Are you sure it is a named instance? Should you just be providing a server name in your bcp command line?

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1425355

Posted Friday, March 01, 2013 9:40 AM

SSC Journeyman

Group: General Forum Members
Last Login: Friday, April 26, 2013 11:23 AM
Points: 76, Visits: 188

yes, the problem was that I configered that the bcp is a case sensetive , when I wrote -c -T capital T , it is solved

Thanks for your concern

Post #1425591

« Prev Topic | Next Topic »

Permissions