Wednesday, August 13, 2014

Oracle Objects for OLE -- Automation server / ActiveX component can't create object


While using Oracle Objects for OLE and trying to instantiate an OracleInProcServer.XOraSession object or any other object you get error like:

Microsoft JScript runtime error: Automation server can't create object


Microsoft VBScript runtime error: ActiveX component can't create object: 'OracleInProcServer.XOraSession'

Your operating system is 64-bit Windows.


The problem is that Oracle Objects for OLE is not supported on 64-bit Windows operating systems. But this doesn't mean that you can't use OO4O on 64-bit Windows operating systems.

To successfully run your scripts you have to use 32-bit Automation Servers, for example 32-bit Internet Explorer, 32-bit Microsoft Office products or 32-bit cscript.exe located in C:\Windows\SysWOW64

  • Oracle Objects For OLE Not Installed With 64bit Oracle Client 11gR2 (Doc ID 1178672.1)
  • FAQ: Running 32-bit and 64-bit Oracle Software On 64-bit Windows (Doc ID 1151394.1) 
  • Considerations Using The Oracle Client With Microsoft Products on 64 bit Windows Operating System (Doc ID 781432.1)

No comments: