bcp issue on sql 2000 cluster

• aruram

  SSCrazy

  Points: 2379

  More actions

  October 12, 2004 at 3:19 pm

  #86685

  I am getting the following error when i try to bcp data from one of the servers on a sql 2000 cluster:

  SQLState = 08001, NativeError = 14

  Error = [Microsoft][ODBC SQL Server Driver][Shared Memory]Invalid connection.

  SQLState = 01000, NativeError = 14

  Warning = [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Invalid Instance()).

  NULL

  I am using the regular bcp command and not specifiying the server /instance name. The same command runs fine when i run it from another server that is not on a cluster.

  Why am i getting this error and how can i fix it?

   

  TIA

• October 15, 2004 at 8:00 am

  This was removed by the editor as SPAM

• UncleRoydee

  SSC Enthusiast

  Points: 100

  More actions

  December 20, 2004 at 9:06 am

  #534484

  Sorry, I don't have an answer but I'm experiencing the exact same problem with a cluster environment.

  Did you ever find a solution?

• jerry6484

  SSC Journeyman

  Points: 90

  More actions

  December 20, 2004 at 9:52 am

  #534495

  What version of MDAC is on the server? You will need at least MDAC version 2.7 or above to be able to connect to a named instance of SQLServer.

• UncleRoydee

  SSC Enthusiast

  Points: 100

  More actions

  December 20, 2004 at 10:23 am

  #534503

  Actually, I found the problem. I needed to add the -S switch as below.

  BCP "SELECT * FROM ##temp_ftp_bat" queryout "C:\FTP_Test\ftp_script.txt" -S databaseserver -T -c'

  Thanks for the reply.