Devart Forums

I would like to connect to a SQL Server located remotely (SQL Server exposed to an external IP) and upload and download documents from a fileserver that is in LAN with the remote server.

I embedded this code in a TMSStoredProcedure

SELECT BulkColumn as MyFile FROM OPENROWSET(BULK '\FILESERVER\SharedFolder\hello.txt' , SINGLE_BLOB) AS X

then from Delphi I cast this as TBlobFIeld and SaveToFile

Can you suggest a way to do the opposite? So saving a local file to the remote \FILESERVER\SharedFolder ?

Thanks.

SDAC doesn't support exporting data from a table to a server file, because Transact-SQL doesn't allow do it.

I found a way to perfome what I need using bcp, anyway this means executing xp_cmdshell so it is not something doable directly with sdac.
Thanks for the answer.