Skip to main content
Inspiring
January 23, 2009
質問

problems accessing SQL-DMO

  • January 23, 2009
  • 返信数 1.
  • 766 ビュー
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!
このトピックへの返信は締め切られました。

返信数 1

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.