Skip to main content
Inspiring
Jan 23, 2009 11:28 AM UTC
Question

problems accessing SQL-DMO

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 is closed to new replies. Start a new post to keep the conversation going.

1 reply

Feb 3, 2009 5:08 AM UTC
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.
Translate