BCP to text failing [shared memory] invalid instance

Hot Topic

Restrict User Access in MSSQL 2000
deploying report models
Using Dimension Source table filter throygh DSO
Help Needed: For Creating Synchronous Transform Component
Can I run SQL2000Dev and SQL2005Exp Side By Side?
RSClientPrint - Error on some clients
Passing data to a custom component at runtime.
Changing user used to execute scheduled jobs
Cant modify sp_admessage - Internals Mystery!!! Please Help!!!
Remote Access - How To & Security Concerns

SQL Server

How to use reporting services of the MSSQL2000.
SP_PREPEXEC and SP_UNPREPARE
Error while importing Text file using Import Export Wizard
Can no longer open my SSIS packages
Generate Scripts option in SQL 2005 Management Studio
where do i find the examples that come with sql server
File Connector w/ Execute Package Task Expression Bug?
remove specific string from text field
Upgrade from 32-bit eval to 64-bit enterprise?
Obtaining TCP/IP Port and Pipe name

BCP to text failing [shared memory] invalid instance

When I run this code...

DECLARE @bcpCommand varchar(2000)
SET @bcpCommand = 'bcp sp_text out test.txt -c -U -P'
EXEC master..xp_cmdshell @bcpCommand

I get this...

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

What on earth does it mean !

Thx,

Nick

Answer this question

BCP to text failing [shared memory] invalid instance

  • KB Sherman

    Since you didn't specify the -S or server parameter BCP will try to connect to a default instance of SQL Server on the machine running the BCP utility. In this case, it seems like there is either no SQL Server default instance installed or the shared memory protocol is disabled. So please specify the server to which you want to connect and it should be fine.

  • BCP to text failing [shared memory] invalid instance
Answer this question