Post reply

bcp issue on sql 2000 cluster

  • October 13, 2004 at 9:08 am

    #361195

     

    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 13, 2004 at 9:18 am

    #526533 

    By default, bcp picks up the default instance of the local server. For clusters, you have to specify the virtual server name and the instance name(if applicable)
     

Viewing 2 posts - 1 through 2 (of 2 total)

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