i need to get some data out from a SQL Server 6.5
i tried using the BCP
bcp iac.dbo.sf_profil out c:\test.bcp /c /Slocal /Usa /Pabc123
bcp iac.dbo.sf_profil out c:\test.bcp /c /Svots138svr09 /Usa /Pabc123
bcp iac.dbo.sf_profil out c:\test.bcp /c /S(local) /Usa /Pabc123
but still was unable to run
the error message
DB-library error
unable to connect : SQL Server is unavailable does not existAre all three command lines failing? The first one seems to be referencing a server named "local" instead of the (local) server. Also, when in doubt, explicitly use the name of the local server.
Not to be completely anal-retentive but are the user and password valid and capable of accessing the database and objects?|||i need to get some data out from a SQL Server 6.5
i tried using the BCP
bcp iac.dbo.sf_profil out c:\test.bcp /c /Slocal /Usa /Pabc123
bcp iac.dbo.sf_profil out c:\test.bcp /c /Svots138svr09 /Usa /Pabc123
bcp iac.dbo.sf_profil out c:\test.bcp /c /S(local) /Usa /Pabc123
but still was unable to run
the error message
DB-library error
unable to connect : SQL Server is unavailable does not exist
In sql server 2000 ,
With default format,you could run
exec master..xp_cmdshell 'bcp test.dbo.jojo out c:\test.txt -c -T -Sservername -Usa -Psecrectcode'
Joydeep
没有评论:
发表评论