mscomm

14 Jul 2005 4:30 PM

gerry

we have need to use mscomm from within sql server to do a simple output.
using sp_OA everything works fine with the exception of setting the Output
property.
we are getting the error 0x800A017C Invalid property value
I assume this is because the proprty expects a Variant and we are sending a
string
I tried sending varchar & varbinary values - same result.

any insights or working examples would be appreciated.

Gerry

14 Jul 2005 6:07 PM

oj

SQL Server does not support variant type. So, the only course of action is
to create a COM wrapper and call it with sp_oa*.

--
-oj

Show quote

"gerry" <g***@hotmail.com> wrote in message
news:uyMGsFJiFHA.3300@TK2MSFTNGP15.phx.gbl...
> we have need to use mscomm from within sql server to do a simple output.
> using sp_OA everything works fine with the exception of setting the Output
> property.
> we are getting the error 0x800A017C Invalid property value
> I assume this is because the proprty expects a Variant and we are sending
> a
> string
> I tried sending varchar & varbinary values - same result.
>
> any insights or working examples would be appreciated.
>
> Gerry
>
>

17 Jul 2005 6:51 AM

gerry

thanks oj.

I ended up writing a extended procedure that really simplified things, gave
us much greater flexibility and sped up the entire process immensely.

Show quote

"oj" <nospam_ojngo@home.com> wrote in message
news:ODZhg7JiFHA.3540@TK2MSFTNGP14.phx.gbl...
> SQL Server does not support variant type. So, the only course of action is
> to create a COM wrapper and call it with sp_oa*.
>
> --
> -oj
>
>
> "gerry" <g***@hotmail.com> wrote in message
> news:uyMGsFJiFHA.3300@TK2MSFTNGP15.phx.gbl...
> > we have need to use mscomm from within sql server to do a simple output.
> > using sp_OA everything works fine with the exception of setting the
Output
> > property.
> > we are getting the error 0x800A017C Invalid property value
> > I assume this is because the proprty expects a Variant and we are
sending
> > a
> > string
> > I tried sending varchar & varbinary values - same result.
> >
> > any insights or working examples would be appreciated.
> >
> > Gerry
> >
> >
>
>