Platform:
Windows XP, SQL Server 2000 sp3a enterprise
We tried to use bcp to extract a simple table into a file
serious error:
SQLState = 08001, NativeError = 17
Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server
does not
exist or access denied.
SQLState = 01000, NativeError = 2
Warning = [Microsoft][ODBC SQL Server Driver][DBNETLIB]Connectio
nOpen
(Connect()).
Any idea please !!
there is no sufficient ressources on the net
Thanks.
MaggieResolved !
c:> bcp base.dbo.table out "c:\tt.txt" -S server\instance -U sa -P password
instance name and server at the last of command !
"404 found" wrote:
> Platform:
> Windows XP, SQL Server 2000 sp3a enterprise
> We tried to use bcp to extract a simple table into a file
> serious error:
> SQLState = 08001, NativeError = 17
> Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Serve
r does not
> exist or access denied.
> SQLState = 01000, NativeError = 2
> Warning = [Microsoft][ODBC SQL Server Driver][DBNETLIB]Connect
ionOpen
> (Connect()).
> Any idea please !!
> there is no sufficient ressources on the net
> Thanks.
> Maggie
2012年2月23日星期四
bcp : Error trying to connect !
标签:
bcp,
connect,
database,
enterprisewe,
error,
errorsqlstate,
extract,
fileserious,
microsoft,
mysql,
oracle,
platformwindows,
server,
sp3a,
sql,
table
订阅:
博文评论 (Atom)
没有评论:
发表评论