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 Server does
not exist or access denied.
SQLState = 01000, NativeError = 2
Warning = [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen
(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 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 Server does
> not exist or access denied.
> SQLState = 01000, NativeError = 2
> Warning = [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen
> (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:
> I 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 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 Server does
> > not exist or access denied.
> > SQLState = 01000, NativeError = 2
> > Warning = [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen
> > (Connect()).
> >
> > Any idea..?
> > CARLOS BREA
> > PUERTO RICO
没有评论:
发表评论