Chilkat • HOME • Android™ • AutoIt • C • C# • C++ • Chilkat2-Python • CkPython • Classic ASP • DataFlex • Delphi DLL • Go • Java • Node.js • Objective-C • PHP Extension • Perl • PowerBuilder • PowerShell • PureBasic • Ruby • SQL Server • Swift • Tcl • Unicode C • Unicode C++ • VB.NET • VBScript • Visual Basic 6.0 • Visual FoxPro • Xojo Plugin
(SQL Server) Synchronize Remote Directory TreeUploads a directory tree from the local filesystem to the FTP server. Synchronization modes include:
-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls. -- CREATE PROCEDURE ChilkatSample AS BEGIN DECLARE @hr int -- Important: Do not use nvarchar(max). See the warning about using nvarchar(max). DECLARE @sTmp0 nvarchar(4000) -- This example requires the Chilkat API to have been previously unlocked. -- See Global Unlock Sample for sample code. DECLARE @ftp int -- Use "Chilkat_9_5_0.Ftp2" for versions of Chilkat < 10.0.0 EXEC @hr = sp_OACreate 'Chilkat.Ftp2', @ftp OUT IF @hr <> 0 BEGIN PRINT 'Failed to create ActiveX component' RETURN END EXEC sp_OASetProperty @ftp, 'Hostname', 'ftp.example.com' EXEC sp_OASetProperty @ftp, 'Username', 'login' EXEC sp_OASetProperty @ftp, 'Password', 'password' EXEC sp_OASetProperty @ftp, 'KeepSessionLog', 1 -- Connect and login to the FTP server. DECLARE @success int EXEC sp_OAMethod @ftp, 'Connect', @success OUT IF @success <> 1 BEGIN EXEC sp_OAGetProperty @ftp, 'LastErrorText', @sTmp0 OUT PRINT @sTmp0 EXEC @hr = sp_OADestroy @ftp RETURN END -- Set the current remote directory to the root of -- the tree where files are uploaded. EXEC sp_OAMethod @ftp, 'ChangeRemoteDir', @success OUT, '/abc123' IF @success <> 1 BEGIN EXEC sp_OAGetProperty @ftp, 'LastErrorText', @sTmp0 OUT PRINT @sTmp0 EXEC @hr = sp_OADestroy @ftp RETURN END -- Recursively upload all non-existant and newer files. DECLARE @mode int SELECT @mode = 2 EXEC sp_OAMethod @ftp, 'SyncRemoteTree', @success OUT, 'c:/temp/abc123', @mode IF @success <> 1 BEGIN EXEC sp_OAGetProperty @ftp, 'LastErrorText', @sTmp0 OUT PRINT @sTmp0 EXEC @hr = sp_OADestroy @ftp RETURN END EXEC sp_OAMethod @ftp, 'Disconnect', @success OUT -- Display the session log. EXEC sp_OAGetProperty @ftp, 'SessionLog', @sTmp0 OUT PRINT @sTmp0 EXEC @hr = sp_OADestroy @ftp END GO |
© 2000-2025 Chilkat Software, Inc. All Rights Reserved.