Post reply

bcp error

  • February 24, 2013 at 10:26 am

    #271335

    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

  • February 24, 2013 at 10:31 am

    #1590659

    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

  • February 24, 2013 at 11:23 am

    #1590665

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

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • February 24, 2013 at 11:34 am

    #1590667

    do you want to enter my server remotly?

    we can use program named by teamviewer

  • February 24, 2013 at 12:25 pm

    #1590670

    any help

  • February 25, 2013 at 12:41 am

    #1590703

    Is SQL Server Browser runnning on the database machine?

    Greetz
    Query Shepherd

  • February 28, 2013 at 10:52 pm

    #1592246

    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

  • March 1, 2013 at 9:40 am

    #1592444

    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

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply