Skip to main content
Inspiring
January 23, 2009
Question

problems accessing SQL-DMO

  • January 23, 2009
  • 1 reply
  • 766 views
Hi I am trying to access SQL-DMO and Windows Script to generate customized scripts for SQL server table objects. There is a dll file sqldmo.dll hich sits in the \Tools\Binn directory under the Microsoft SQL Server installation.

No i am trying to instantiate this object vai coldfusion using the following:

<cfobject type="com" name="SQLServer" class="SQLDMO.SQLServer" server="\\olivemill" action="create">

I keep getting this error:-

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..

Has anyone tried this before? Any help greatly appreciated!
This topic has been closed for replies.

1 reply

February 3, 2009
I've never tried this, but if you are trying to create the object remotely (server-"olivemill") there may be permissions issues with the account cold fusion is running under. I would give "Everyone" access to the dll to start with and see if that how that goes.