Hi..im trying to use BCP to transfer data from text file to a SQL table and
give me an error. I have access to the db table with the 'sa' user and both
input and format files are in the directory. This was working well, but
suddenly stop working.
This is the complete command and the error at the prompt:
--COmmand--
C:\>bcp dt..hc990021 in e:\dtracker\dtdata30\33600001032002990.or1
-fe:\dtracker\dtdata30\HC990021.fmt -b5000 -F1 -Usa -P -h
--error--
SQLState = 08001, NativeError = 17
Error = [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Se
rver does
not exist or access denied.
SQLState = 01000, NativeError = 2
Warning = [Microsoft][ODBC SQL Server Driver][Shared Memory]Conn
ectionOpen
(Connect()).
Any idea..?
CARLOS BREA
PUERTO RICOI think you may be missing the /S parameter which contains the
server/instance name of SQL Server.
"Pirulo_y2k" wrote:
> Hi..im trying to use BCP to transfer data from text file to a SQL table an
d
> give me an error. I have access to the db table with the 'sa' user and bot
h
> input and format files are in the directory. This was working well, but
> suddenly stop working.
> This is the complete command and the error at the prompt:
> --COmmand--
> C:\>bcp dt..hc990021 in e:\dtracker\dtdata30\33600001032002990.or1
> -fe:\dtracker\dtdata30\HC990021.fmt -b5000 -F1 -Usa -P -h
> --error--
> SQLState = 08001, NativeError = 17
> Error = [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL
Server does
> not exist or access denied.
> SQLState = 01000, NativeError = 2
> Warning = [Microsoft][ODBC SQL Server Driver][Shared Memory]Co
nnectionOpen
> (Connect()).
> Any idea..?
> CARLOS BREA
> PUERTO RICO|||Thanks DrRides...I used with the -S and works great! The issue is that it
was working without the -S swith before.
I just cut and paste the bcp command from an error log that generate an
application. Is there a way that I can run the bcp command without specify
the named instances? or..where I can setup a default named instances for
the bcp command..'
"DrRides" wrote:
[vbcol=seagreen]
> I think you may be missing the /S parameter which contains the
> server/instance name of SQL Server.
> "Pirulo_y2k" wrote:
>
没有评论:
发表评论