Using CDO in a DTS Pacakge -
11-21-2005
, 10:11 PM
I have a DTS package that uses an ActiveX script to create an instance of
the CDO.Message object and then sets the configurations using the url based
microsoft namespaces, such as:
objFields.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") =
cdoSendUsingPort
All has been working fine and dandy, when all the suden, Saturday it broke.
I found that our ISP implemented a new policy that day
to NOT allow access to the internet from their hosting (or in this case
database) servers. They did this to keep customers who are VPN'ed
to they're servers, to "pass thru" to the internet and run their bandwidth
meter up.
This would be ok with me as the smtp mail server is hosted by them, BUT now
I cannot see microsoft.com, to get to the schema namespaces.
I have found a couple of internet code snippets discussing METADATA
reference tags to the cdosys.dll, but so far all errors out (I believe these
samples are really for using from an ASP page).
Any suggestions or solutions?
Thanks,
Russell |