2012年3月22日星期四

BCP SQL Server 6.5

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

没有评论:

发表评论