Howie, I dunno if this helps - but here's an excerpt from SQL Books:
sp_OACreate (T-SQL)
Creates an instance of the OLE object on the computer running Microsoft® SQL
ServerT.
Syntax
sp_OACreate progid, | clsid,
objecttoken OUTPUT
[, context]
Arguments
progid
Is the programmatic identifier (ProgID) of the OLE object to create. This
character string describes the class of the OLE object and has the form:
'OLEComponent.Object'
OLEComponent is the component name of the OLE Automation server, and Object
is the name of the OLE object. The specified OLE object must be valid and
must support the IDispatch interface.
For example, SQLDMO.SQLServer is the ProgID of the SQL-DMO SQLServer object.
SQL-DMO has a component name of SQLDMO, the SQLServer object is valid, and
(like all SQL-DMO objects) the SQLServer object supports IDispatch.
Maybe there's some "adjusting" that needs to happen?
Hey user list, if anyone out there is pretty good with SQL7, how about a
hand in testing and getting this com object working in stored procedures?
Tom
----- Original Message -----
From: Howie Hamlin <[EMAIL PROTECTED]>
To: inFusion Support List <[EMAIL PROTECTED]>
Sent: Thursday, January 11, 2001 2:28 AM
Subject: Re: [iMS] ODSMIME COM Object
>
> ----- Original Message -----
> From: "Tom Langer" <[EMAIL PROTECTED]>
> To: "inFusion Support List" <[EMAIL PROTECTED]>
> Sent: Wednesday, January 10, 2001 10:29 PM
> Subject: Re: [iMS] ODSMIME COM Object
>
>
> > >
> > > Yes, but the real question is "would this be something useful?" - I
> don't
> > > mind having the software designed but only as long as it's for a
> purpose.
> >
> > I see it being useful. Although the web is wonderful, it will not
> > completely replace the usefullness of a vb-type app - and if I want to
> > include some custom email interface in my accounting or order entry
> system,
> > I can by embedding a couple hundred k com object - see my point?
> >
>
> Yes, I see. Makes sense...
>
> >
> > > > email hooks - and with iMS as the standard production mail server,
> it'll
> > > > make it real easy.
> > > >
> > > > Avoid those pesky SetHeader methods tho wouldja? :-) hehe
> > > >
> > >
> > > OMG - you never stop :-)
> > >
> > > Seriously, though - the SetHeader is actually more elegant than the
> header
> > > controls in the cfx_imsmail tag IMHO.
> >
> > I'm sure I agree with you - the com object is implemented right in terms
> of
> > a VB/access style, but SQL just isn't liking that darn setheader
method -
> > I've tried at least 6 different ways - all of which fail... :-(
> >
>
> There must be some syntax to get this to work...
>
> Regards,
>
> Howie
>
>
>
>
> ========================================================================
> This list server is Powered by iMS
> 'The Swiss Army Knife of Mail Servers'
> --------------------------------------
> To leave this list please complete the form at
> http://www.coolfusion.com/iMSSupport.cfm
> Need an iMS Developer license? Sign up for a free license here:
> http://www.coolfusion.com/iMSDevelopers.cfm
> List archives: http://www.mail-archive.com/infusion-email%40eoscape.com/
> ========================================================================
>
========================================================================
This list server is Powered by iMS
'The Swiss Army Knife of Mail Servers'
--------------------------------------
To leave this list please complete the form at
http://www.coolfusion.com/iMSSupport.cfm
Need an iMS Developer license? Sign up for a free license here:
http://www.coolfusion.com/iMSDevelopers.cfm
List archives: http://www.mail-archive.com/infusion-email%40eoscape.com/
========================================================================
