Error Registering Winscp.dll
Free SFTP, SCP and FTP client for Windows News Introduction SSH Client SFTP Client FTP Client Download Install Donate Documentation Guides F.A.Q. Scripting .NET & COM Library Screenshots Translations Support Forum Tracker History [[library_install]] WinSCP Contents » .NET Assembly » Downloading and Installing WinSCP .NET Assembly Downloading Installing Using from Visual Studio or other Development or Runtime Environment NuGet Package Installing to GAC On Development Machine On Production or User's Machine Registering for COM Side-by-Side Registration Deploying Embedding WinSCP Executable as Resource Downloading WinSCP .NET assembly is available in a package named winscpXXXautomation.zip on WinSCP download page. Follow the .NET assembly/COM library link. Advertisements: Installing The package includes the assembly itself (winscpnet.dll) and a required dependency, WinSCP executable winscp.exe. The binaries interact with each other and must be kept in the same folder for the assembly to work. In rare situations this is not possible (e.g. when installing the assembly to GAC), make use of Session.ExecutablePath property to force the assembly to look for the winscp.exe in a different location. Using from Visual Studio or other Development or Runtime Environment Note that your runtime or development environment may copy the assembly into an another location. In that case you need to copy winscp.exe into that location too. E.g. If you reference WinSCP assembly from your project in Microsoft Visual Studio, it copies the assembly during build into the project Output path (e.g.
on Animations Follow Allen Ellison HomeOnline ResumeContact usBlogCurrently http://www.allenellison.net/Blog/Post/3/Using-WinSCP-for-SFTP-connection-with-SSIS selectedPoolTournament PageHeaderSign In Sign In It looks like your browser does not have JavaScript enabled. Please turn on JavaScript and try again. Using WinSCP for SFTP connection with SSIS ArchivesOctoberSeptemberAugustJulyOlder Posts RSS Feed PageFooterUse this area to add footer content. The footer will be displayed on every page.
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more http://stackoverflow.com/questions/35091706/winscp-net-assembly-with-vba-throwing-activex-component-cant-create-object about Stack Overflow the company Business Learn more about hiring developers or posting http://forum.winbatch.com/index.php?topic=367.0 ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up WinSCP .NET assembly with VBA throwing ActiveX component can't create object error registering up vote 0 down vote favorite I have recently registered the WinSCPnet.dll using .NET Framework C:\Windows\Microsoft.NET\Framework64\v2.0.50727. And I have added the tlb file generated to my VBA references. But when I try to instantiate SessionOptions object, it throws an error "ActiveX component can't create object". Not sure what went wrong here. Also, I found that I was able to connect using VBScript. But if I use VBA, it is error registering winscp.dll not working. Can anyone suggest what is the problem? .net excel-vba com winscp winscp-net share|improve this question edited Jan 29 at 19:50 Martin Prikryl 34.3k1549133 asked Jan 29 at 18:40 karthiknsra 11 "And I have added the tlb file generated to my VBA references" What did you do exactly? –Martin Prikryl Jan 29 at 19:36 add a comment| 1 Answer 1 active oldest votes up vote 2 down vote The Microsoft Excel is 32-bit application, so you probably have to register the WinSCPnet.dll for 32-bit .NET framework, even on 64-bit system. As the instructions for registering the WinSCP .NET assembly for COM shows, on 64-bit system, you generally need to register the assembly both for 32-bit and 64-bit: %WINDIR%\Microsoft.NET\Framework\v4.0.30319\RegAsm.exe WinSCPnet.dll /codebase /tlb:WinSCPnet32.tlb %WINDIR%\Microsoft.NET\Framework64\v4.0.30319\RegAsm.exe WinSCPnet.dll /codebase /tlb:WinSCPnet64.tlb Do not add the .tbl manually to Excel. The assembly appears itself after being registered correctly. share|improve this answer edited Jan 30 at 7:37 answered Jan 29 at 19:47 Martin Prikryl 34.3k1549133 Please consider accepting my answer to close this question, as is seems to have helped you. –Martin Prikryl Feb 5 at 16:51 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sig
released Home Help Search Tech Database Downloads Login Register WinBatch Technical Support Forum » All Things WinBatch » COM Automation and dotNet » SFTP using WinSCP dotNet « previous next » Print Pages: [1] Go Down Author Topic: SFTP using WinSCP dotNet (Read 16705 times) Deana Wilson WindowWare Tech Support Tech Support Posts: 1183 WinBatch® can do it. SFTP using WinSCP dotNet « on: October 31, 2013, 10:10:34 am » The WinBatch Extenders: Winsock and WinInet do not currently support SFTP. However WinSCP ( http://winscp.net/eng/docs/introduction ) is an open source freeware SFTP client for Windows using SSH. Its main function is safe copying of files between a local and a remote computer. It supports scripting and command-line interface. Using dotNet with WinSCP: http://winscp.net/eng/docs/guide_dotnet I put together a WinBatch dotNet code sample that uses WinSCP to handle SFTP. QuoteREQUIRES WinBatch 2013A or newer Before starting you should: - Download and install both WinSCP and its .NET assembly/COM library (http://winscp.net/eng/download.php) - Know how to connect to your FTP/SFTP account;Here is the code. You will need to modify for your environment...Code: Winbatch;***************************************************************************;** SFTP using WinSCP dotNet;**;** Purpose: SFTP using WinSCP dotNet;** Inputs: ;** Outputs: ;** Reference: ;** REQUIRES WinBatch 2013A or newer ;** http://winscp.net/eng/docs/guide_dotnet;** http://winscp.net/eng/docs/library (WinSCP .NET Assembly and COM Library);** Before starting you should: ;** - Download and install both WinSCP and its .NET assembly/COM library (http://winscp.net/eng/download.php);** By default WinScp installs to C:\Program Files (x86)\WinSCP you will need to copy the WinSCp.dll to this directory ;** - Know how to connect to your FTP/SFTP account;;** - Know what WinSCP scripting commands to use for your task (e.g. file transfer).;** ;** Developer: Deana Falk 2013.10.31;*************************************************************************** If Version( )< '2013A' Pause( 'Notice', 'Need 2013A or Newer Version of WinBatch' ) Exit EndIfassemblydir = 'C:\Program Files (x86)\WinSCP'ObjectClrOption( 'appbase', assemblydir )ObjectClrOption ( 'use', 'WinSCP, Version=1.0.7.3446, Culture=neutral' ) ; Confirm version matches the dll;Create an instance of the WinSCP.SessionOptions class and fill in all necessary information to allow an automatic connection and authentication of your session.objSessionOptions