InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 04:49:13 GMT20http://www.sqlservercentral.com/Forums/Topic1423425-1550-1.aspxyes, the problem was that I configered that the bcp is a case sensetive , when I wrote -c -T capital T , it is solvedThanks for your concernFri, 01 Mar 2013 09:40:08 GMTzihttp://www.sqlservercentral.com/Forums/Topic1423425-1550-1.aspxDid you get it resolved?A shot in the dark:[quote]You specified home\[b]mssqlserver[/b][/quote]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?Thu, 28 Feb 2013 22:52:27 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1423425-1550-1.aspxIs SQL Server Browser runnning on the database machine?Mon, 25 Feb 2013 00:41:49 GMTSQL Pizzahttp://www.sqlservercentral.com/Forums/Topic1423425-1550-1.aspxany helpSun, 24 Feb 2013 12:25:27 GMTzihttp://www.sqlservercentral.com/Forums/Topic1423425-1550-1.aspxdo you want to enter my server remotly?we can use program named by teamviewerSun, 24 Feb 2013 11:34:18 GMTzihttp://www.sqlservercentral.com/Forums/Topic1423425-1550-1.aspxDo you have a linked server set up and allowed remote connections to it?Sun, 24 Feb 2013 11:23:44 GMTMyDoggieJessiehttp://www.sqlservercentral.com/Forums/Topic1423425-1550-1.aspxwhen I wrote on -Shome not -Shome\mssqlserverthis error occuredC:\Users\Dell>bcp medica.dbo.patient in d:\patients.txt -c -t -Shome\mssqlserver -Usa -PP@ssw0rdSQLState = 08001, NativeError = 87Error = [Microsoft][SQL Server Native Client 11.0]SQL Server Network Interfaces: Connection string is not valid [87].SQLState = 08001, NativeError = 87Error = [Microsoft][SQL Server Native Client 11.0]A network-related or instance-specific error has occurred while establishing a connectionto SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.SQLState = S1T00, NativeError = 0Error = [Microsoft][SQL Server Native Client 11.0]Login timeout expiredSun, 24 Feb 2013 10:31:12 GMTzihttp://www.sqlservercentral.com/Forums/Topic1423425-1550-1.aspxDear ExpertsI exported data table by bcp succesfully in txt file, I want to import this file in different sql server but this error occuredC:\Users\Dell>bcp medica.dbo.patient in d:\patients.txt -c -t -Shome\mssqlserver -Usa -PP@ssw0rdSQLState = 08001, NativeError = 87Error = [Microsoft][SQL Server Native Client 11.0]SQL Server Network Interfaces: Connection string is not valid [87].SQLState = 08001, NativeError = 87Error = [Microsoft][SQL Server Native Client 11.0]A network-related or instance-specific error has occurred while establishing a connectionto SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.SQLState = S1T00, NativeError = 0Error = [Microsoft][SQL Server Native Client 11.0]Login timeout expiredany help,thanksSun, 24 Feb 2013 10:26:44 GMTzi