CODEWITHSUNDEEP
coldfusioncomsage-erp
user3797770
user3797770

Reputation: 21

Connecting to COM object in ColdFusion

I am trying to connect to a Sage 100 COM object from ColdFusion. ColdFusion is on one machine and Sage and the other COM object is on another. How do I set up the credentials so that ColdFusion can gain access to the COM object on the Sage machine. The code that I have is currently:

<CFOBJECT ACTION="CONNECT" 
  CLASS="pvxcom.exe" 
  NAME="SageConnection" 
  CONTEXT="remote" 
  SERVER="\\sage">

Update from Comments:

I am using ColdFusion 9 and the error message I am receiving is:

An exception occurred when instantiating a COM object. The cause of this exception was that: coldfusion.runtime.com.ComObjectInstantiationException: An exception occurred when instantiating a COM object.

Upvotes: 0

Views: 316

Answers (1)

Miguel-F
Miguel-F

Reputation: 13548

You are running a 64-bit version of ColdFusion which does not support COM objects. Really I think it goes down to the 64-bit OS not playing well with COM objects either. Anyway, if the COM object is required for you I think you will need to install the 32-bit version of ColdFusion and perhaps on a 32-bit version of your operating system.

I believe this goes back to the ColdFusion 8 days (the first ColdFusion version that included a 64-bit option). In fact I found this in an old ColdFusion 8 article:

Most of the functionality and features of ColdFusion run just fine on 64-bit platforms, however, certain features like ColdFusion COM interoperability, ColdFusion Delphi interoperability, and Microsoft Access database connectivity do not work on a ColdFusion 64-bit platform.

My emphasis on the COM statement

Upvotes: 1

Related Questions