General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only