October 12, 2004 at 3:19 pm
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
December 20, 2004 at 9:06 am
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?
December 20, 2004 at 9:52 am
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.
December 20, 2004 at 10:23 am
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.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply