problems accessing SQL-DMO

[zubair]

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!

[Guest]

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.