SQL Server 2000 and BCP utility
Posted on 2004-07-30
I was wondering if someone would not mind leading me in the right direction. I have explored information everywhere I possibley was able to. and am still not able to get this to function.
I am learning SQL server 2000 running the 120 Day Enterprise Evaluation Edition, and am attempting to load a flat txt file into a table via the Command Prompt, continue to obtain ODBC errors each time I run the data transfer. I even install the MDAC 2.8 version of the ODBC drivers.
These are the statemens in which I key in the Command Prompt.
C:\Documents and Settings\Owner>bcp brandywade..paintings IN C:\le3_flat.txt -t -c -S -T -P -R
The errors I continue to recieve are
SQLState = 08S01, Native Error = 11
Error = [Microsoft][ODBC SQL Server Driver][Shared Memory] General network error.
Check your network documentation.
SQLState = 01000, NativeError = 10054
Warning = [Microsoft][ODBC SQL Server Driver][Shared Memory] ConnectionRead <recv<>>.
Thank you in advance.