Bulk exporting SQL Server 7 data and bulk importing it to SQL Server 2008 R2 Like the title suggests, I want to bulk export data within an sql server 7.0 database into a file and then import it to an sql server 2008 r2 database, I did the following, I first typed this command on the windows 2000 shell:  

C:&gt; bcp sticom.dbo.societe format nul -c -f C:\test.fmt -t, -T


it was executed successfully, then I copied the C:\test.fmt in a network shared folder so I can access it from the other windows 7 system, I then copied on the desktop and tried to execute this command on the command prompt:  

C:\ bcp sticom.dbo.societe in C:\test.bcp -f C:\test.fmt  -T


and I got this error:  


  SQLState = 08001, NativeError = 2   Error = [Microsoft][SQL Server
  Native Client 10.0][SQL Native Client]An error has occurred while
  establishing a connection to the server. When connecting to SQL Server
  2005, this failure may be caused by the fact that under the default
  settings SQL Server does not allow remote connections. SQLState =
  S1T00, NativeError = 0 Error = [Microsoft][SQL Native Client]Login
  timeout expired


I checked my connection, I checked the services and the paths, everything was in place
The BCP utility attempts to connect to the default instance if you don't specify the -S parameter.  My guess is there is no default instance available for the 'import' BCP.