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

bcp error Expand / Collapse
Author
Message
Posted Sunday, February 24, 2013 10:26 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, June 26, 2014 1:17 AM
Points: 90, Visits: 239
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

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, June 26, 2014 1:17 AM
Points: 90, Visits: 239
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
Posted Sunday, February 24, 2013 11:23 AM


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: Monday, July 14, 2014 2:06 PM
Points: 3,865, Visits: 7,130
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"
Post #1423435
Posted Sunday, February 24, 2013 11:34 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, June 26, 2014 1:17 AM
Points: 90, Visits: 239
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

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, June 26, 2014 1:17 AM
Points: 90, Visits: 239
any help
Post #1423440
Posted Monday, February 25, 2013 12:41 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, June 28, 2014 2:49 PM
Points: 116, Visits: 346
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
Posted Thursday, February 28, 2013 10:52 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Saturday, July 26, 2014 8:57 AM
Points: 7,081, Visits: 12,575
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
Post #1425355
Posted Friday, March 1, 2013 9:40 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, June 26, 2014 1:17 AM
Points: 90, Visits: 239
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 »

Add to briefcase

Permissions Expand / Collapse