hi,

What i am trying to do is

Copy the file from server(remote) to the Drive(destination)

There is no Shares of drives.

So i think i need BCP or textcopy for the same . or Might be a C# assembly ?

Will try it with BCP if not will write out a C# assembly.

Any other Ideas ?

Storage:


1) Client machine : Different Domain than Server
2) Can interact only through services with the server.
3) The file can be a Photo, or Fax doc ,or something like
4) The file name (with path) is stored in the Server for retrival of the Image or Photo

something like "Select * from openrowset(BULK 'PATH',single_blob) as A
I also tried "Insert into openrowset('MSDASQL.1,'c:\';'';'','c:\test\data.jpg') select f1 from ##foo1 " with the Microsoft Text driver

5) I want to do the reverse. of the select ; Write to the file.

6) think of the control You will get. Infact updating the server would be easy , without the use of FTP or something else(of course you will need to be logged in with admin prev or atleast must be able to see the drive)


Suhashegde