|
Home > Archive > MS SQL Server Notification Services > September 2005 > SMTP To Name
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| My messages are going through successfully via SMTP, but the To field does
not show the email address of the person. If you look at the SMTP message
with notepad you see X-Receiver: <email address>, but there is not a To:
field declared.
Is this correct for SQL 2005 June CTP for NS? We would really like to have
the name show up. The ADF has the following:
<Protocol>
<ProtocolName>SMTP</ProtocolName>
<Fields>
<Field>
<FieldName>Subject</FieldName>
<SqlExpression>
<Our subject line>
</SqlExpression>
</Field>
<Field>
<FieldName>From</FieldName>
<SqlExpression>
<our return email address here, not displayed for spam sake>
</SqlExpression>
</Field>
<Field>
<FieldName>To</FieldName>
<SqlExpression>
DeviceAddress
</SqlExpression>
</Field>
<Field>
<FieldName>Priority</FieldName>
<SqlExpression>
N'Normal'
</SqlExpression>
</Field>
<Field>
<FieldName>BodyFormat</FieldName>
<SqlExpression>
N'text'
</SqlExpression>
</Field>
</Fields>
</Protocol>
| |
|
| what is a sample content of deviceaddress? if unsure , you could
confirm this by including is in the subject line for a test run.
Are you just getting the persons name in the to?
you imply that the mail is arriving at the correct person so the mail
server must have got something as a destination address...
Kate MBCS
Alert Technologies
http://www.alert-technologies.co.uk
Get your notification services implementation going in minutes not
weeks ......
| |
|
| The question I believe is more for Microsoft, unless you are using SQL 2005
June CTP and do not have the same problem I am expressing.
The message gets to the recipient, but just has a blank To field.
"kate" <k@alert-tech.co.uk> wrote in message
news:1125442500.441978.182120@g14g2000cwa.googlegroups.com...
> what is a sample content of deviceaddress? if unsure , you could
> confirm this by including is in the subject line for a test run.
>
> Are you just getting the persons name in the to?
>
> you imply that the mail is arriving at the correct person so the mail
> server must have got something as a destination address...
>
> Kate MBCS
>
> Alert Technologies
> http://www.alert-technologies.co.uk
> Get your notification services implementation going in minutes not
> weeks ......
>
| |
|
| Here is header info from a message, clearly To is not getting populated:
X-Receiver: <email address removed to prevent spam>
X-Sender: <email address removed to prevent spam>
thread-index: AcWuMlXujTeg/WNaQc6BZNYKzWRt5g==
Thread-Topic: Load Alert - Subscription ID: 1
From: <email address removed to prevent spam>
Bcc:
Subject: Load Alert - Subscription ID: 1
Date: Wed, 31 Aug 2005 09:46:06 -0400
Message-ID: < 000001c5ae32$55fae13
0$601d17ac@dev.landstar.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="utf-8"
Content-Transfer-Encoding: 7bit
X-Mailer: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
Why not use the Messaging Class from .Net and not rely on CDO?
"Andy" <andyjax@newsgroup.nospam> wrote in message
news:OMOA0hirFHA.3884@TK2MSFTNGP11.phx.gbl...
> The question I believe is more for Microsoft, unless you are using SQL
> 2005 June CTP and do not have the same problem I am expressing.
>
> The message gets to the recipient, but just has a blank To field.
>
> "kate" <k@alert-tech.co.uk> wrote in message
> news:1125442500.441978.182120@g14g2000cwa.googlegroups.com...
>
>
| |
|
| i think they do, the messaging class is just a wrapper on cdo isnt it?
Kate MBCS
Alert Technologies
http://www.alert-technologies.co.uk
Get your notification services implementation going in minutes not
weeks ......
| |
|
| I don't recall, but will look into that later.
"kate" <k@alert-tech.co.uk> wrote in message
news:1125531405.470724.34890@z14g2000cwz.googlegroups.com...
>i think they do, the messaging class is just a wrapper on cdo isnt it?
>
> Kate MBCS
>
> Alert Technologies
> http://www.alert-technologies.co.uk
> Get your notification services implementation going in minutes not
> weeks ......
>
| |
| Joe Webb 2005-09-02, 8:24 pm |
| I've got the June CTP and will try to test it out early next week (I'm
teaching a class in another city this week and won't be back in my
office until next week). I'll let you know my results.
In the meantime I've checked the bug database that I have access to
(which is not the same one that MS uses) and I don't see it list.
--
Joe Webb
SQL Server MVP
~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/t...il/-/0972688811
I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)
On Wed, 31 Aug 2005 08:35:19 -0400, "Andy" <andyjax@newsgroup.nospam>
wrote:
>The question I believe is more for Microsoft, unless you are using SQL 2005
>June CTP and do not have the same problem I am expressing.
>
>The message gets to the recipient, but just has a blank To field.
>
>"kate" <k@alert-tech.co.uk> wrote in message
>news:1125442500.441978.182120@g14g2000cwa.googlegroups.com...
>
| |
| Shyam Pather [MSFT] 2005-09-09, 8:24 pm |
| Andy,
In the subscriber device record, what is the value for the DeviceAddress
column?
-shyam
--
Learn more about SQL-NS:
http://www.amazon.com/exec/obidos/t...l/-/0672326647/
---------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
---------------------------------------------
"Andy" <andyjax@newsgroup.nospam> wrote in message
news:uJKwldWrFHA.1168@TK2MSFTNGP11.phx.gbl...
> My messages are going through successfully via SMTP, but the To field does
> not show the email address of the person. If you look at the SMTP message
> with notepad you see X-Receiver: <email address>, but there is not a To:
> field declared.
>
> Is this correct for SQL 2005 June CTP for NS? We would really like to have
> the name show up. The ADF has the following:
> <Protocol>
> <ProtocolName>SMTP</ProtocolName>
> <Fields>
> <Field>
> <FieldName>Subject</FieldName>
> <SqlExpression>
> <Our subject line>
> </SqlExpression>
> </Field>
> <Field>
> <FieldName>From</FieldName>
> <SqlExpression>
> <our return email address here, not displayed for spam sake>
> </SqlExpression>
> </Field>
> <Field>
> <FieldName>To</FieldName>
> <SqlExpression>
> DeviceAddress
> </SqlExpression>
> </Field>
> <Field>
> <FieldName>Priority</FieldName>
> <SqlExpression>
> N'Normal'
> </SqlExpression>
> </Field>
> <Field>
> <FieldName>BodyFormat</FieldName>
> <SqlExpression>
> N'text'
> </SqlExpression>
> </Field>
> </Fields>
> </Protocol>
>
| |
|
| Regular email address only, I have also tried it with putting a Name <email
address> and other variations.
"Shyam Pather [MSFT]" <spather@online.microsoft.com> wrote in message
news:etUKu5WtFHA.1596@TK2MSFTNGP10.phx.gbl...
> Andy,
> In the subscriber device record, what is the value for the DeviceAddress
> column?
> -shyam
>
> --
> Learn more about SQL-NS:
> http://www.amazon.com/exec/obidos/t...l/-/0672326647/
> ---------------------------------------------
> This posting is provided "AS IS" with no warranties, and confers no
> rights. Use of included script samples are subject to the terms specified
> at http://www.microsoft.com/info/cpyright.htm.
> ---------------------------------------------
> "Andy" <andyjax@newsgroup.nospam> wrote in message
> news:uJKwldWrFHA.1168@TK2MSFTNGP11.phx.gbl...
>
>
| |
| Joe Webb 2005-09-21, 9:24 am |
| Andy -
I'm using the June CTP and haven't been able to duplicate your
results.
When I use the built-in SMTP delivery protocol to send an email to a
subscriber, I can see the subscriber's email address in the 'To' field
of the email.
Here's how I created the subscriber and device for the instance.
INSERT INTO NSSubscriberView(Sub
scriberId, Enabled)
VALUES (N'joew@webbtechsolu
tions.com', 1)
INSERT INTO NSSubscriberDeviceVi
ew(SubscriberId, Enabled, DeviceName,
DeviceTypeName, DeviceAddress, DeliveryChannelName)
VALUES (N'joew@webbtechsolu
tions.com', 1, N'EmailDevice', N'Email',
N'joew@webbtechsolut
ions.com', N'EmailChannel')
Have you been able to resolve this?
--
Joe Webb
SQL Server MVP
~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/t...il/-/0972688811
I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)
On Fri, 9 Sep 2005 14:49:38 -0400, "Andy" <andyjax@newsgroup.nospam>
wrote:
>Regular email address only, I have also tried it with putting a Name <email
>address> and other variations.
>
>
>"Shyam Pather [MSFT]" <spather@online.microsoft.com> wrote in message
>news:etUKu5WtFHA.1596@TK2MSFTNGP10.phx.gbl...
>
| |
| Joe Webb 2005-09-21, 9:24 am |
| Andy -
Your posting doesn't mention whether you're using the built-in SMTP
delivery protocol or a custom component that you've created.
Can you post the DeliveryChannels node of your ICF?
--
Joe Webb
SQL Server MVP
~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/t...il/-/0972688811
I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)
On Fri, 9 Sep 2005 14:49:38 -0400, "Andy" <andyjax@newsgroup.nospam>
wrote:
>Regular email address only, I have also tried it with putting a Name <email
>address> and other variations.
>
>
>"Shyam Pather [MSFT]" <spather@online.microsoft.com> wrote in message
>news:etUKu5WtFHA.1596@TK2MSFTNGP10.phx.gbl...
>
| |
|
| I see it showing up now, all I did was add an alias to my SMTP server I was
bouncing out of, which was my SQL server.
Thanks for looking into this, I believe it was a limitation of the SMTP
setup.
"Joe Webb" < joew@webbtechsolutio
ns.com> wrote in message
news:5em2j1l9n2maefj
86unrjdhohp1i2vq5ib@
4ax.com...[color=darkred]
> Andy -
>
> Your posting doesn't mention whether you're using the built-in SMTP
> delivery protocol or a custom component that you've created.
>
> Can you post the DeliveryChannels node of your ICF?
>
> --
> Joe Webb
> SQL Server MVP
>
>
> ~~~
> Get up to speed quickly with SQLNS
> http://www.amazon.com/exec/obidos/t...il/-/0972688811
>
> I support PASS, the Professional Association for SQL Server.
> (www.sqlpass.org)
> On Fri, 9 Sep 2005 14:49:38 -0400, "Andy" <andyjax@newsgroup.nospam>
> wrote:
>
|
|
|
|
|