Weird attachment problem

[Asher_N]

I have a weird problem with an attachment.

I have a SQL Server 2000 with Reporting Services. Every morning it
generates a report and e-mail it to 6 people as an Excel attachment.
5 of those people also us Blackberry. I do not.

They can open the report on the BB, or through Outlook. If they use Outlook
Web Access, the message shows the paper clip, but when you open it, there
is no attachment. If I forward from OWA back to myself, I can open the
attachment in Outlook, but not OWA. If I forward my copy of that e-mail to
one of those users, they have the same problem. They can open attachments
in OWA from any other source, this only seem to affect RS generated
messages.

[Rich Matheisen [MVP]]

"Asher_N" <compguy666@hotmail.com> wrote:

I have a weird problem with an attachment.

I have a SQL Server 2000 with Reporting Services. Every morning it
generates a report and e-mail it to 6 people as an Excel attachment.
5 of those people also us Blackberry. I do not.

They can open the report on the BB, or through Outlook. If they use Outlook
Web Access, the message shows the paper clip, but when you open it, there
is no attachment. If I forward from OWA back to myself, I can open the
attachment in Outlook, but not OWA. If I forward my copy of that e-mail to
one of those users, they have the same problem. They can open attachments
in OWA from any other source, this only seem to affect RS generated
messages.

How big is the message? OWA only allows, IIRC, a 2MB attachment unless
you've change that.

--
Rich Matheisen
MCSE+I, Exchange MVP
MS Exchange FAQ at http://www.swinc.com/resource/exch_faq.htm
Don't send mail to this address mailto:h.pott@getronics.com

[Asher_N]

"Rich Matheisen [MVP]" <richnews@rmcons.com.NOSPAM.COM> wrote in
news:rk0ji1916h1ajj0fjkb2q15vqnpl15db2h@4ax.com:

"Asher_N" <compguy666@hotmail.com> wrote:

"Rich Matheisen [MVP]" <richnews@rmcons.com.NOSPAM.COM> wrote in
news:fq3hi1dr9md252rhnuk8u63htg0hups1ol@4ax.com:

Tha attachments are less than 100K. I can open them. It's the users
that also reveive them on a Blackberry that have the problem. Of
course, those happen to be the Senior Directors :)

Are you using BES or just the desktop synch? If it's BES, have you
considered it might be a problem with that software?

I'm using BES. I'm leaning more towards a SQL RS problem, but I tought
I'd also give the Exchange group a shot. It's only attachments coming
from RS to BB users when Exchange is accessed through OWA. At this point
I'm ready to consider the phase of the moon as a possible trigger.

[Asher_N]

"Rich Matheisen [MVP]" <richnews@rmcons.com.NOSPAM.COM> wrote in
news:fq3hi1dr9md252rhnuk8u63htg0hups1ol@4ax.com:

Tha attachments are less than 100K. I can open them. It's the users that
also reveive them on a Blackberry that have the problem. Of course, those
happen to be the Senior Directors :)

"Asher_N" <compguy666@hotmail.com> wrote:

I have a weird problem with an attachment.

I have a SQL Server 2000 with Reporting Services. Every morning it
generates a report and e-mail it to 6 people as an Excel attachment.
5 of those people also us Blackberry. I do not.

They can open the report on the BB, or through Outlook. If they use
Outlook Web Access, the message shows the paper clip, but when you
open it, there is no attachment. If I forward from OWA back to myself,
I can open the attachment in Outlook, but not OWA. If I forward my
copy of that e-mail to one of those users, they have the same problem.
They can open attachments in OWA from any other source, this only seem
to affect RS generated messages.

How big is the message? OWA only allows, IIRC, a 2MB attachment unless
you've change that.

[Rich Matheisen [MVP]]

"Asher_N" <compguy666@hotmail.com> wrote:

"Rich Matheisen [MVP]" <richnews@rmcons.com.NOSPAM.COM> wrote in
news:fq3hi1dr9md252rhnuk8u63htg0hups1ol@4ax.com:

Tha attachments are less than 100K. I can open them. It's the users that
also reveive them on a Blackberry that have the problem. Of course, those
happen to be the Senior Directors :)

Are you using BES or just the desktop synch? If it's BES, have you
considered it might be a problem with that software?

--
Rich Matheisen
MCSE+I, Exchange MVP
MS Exchange FAQ at http://www.swinc.com/resource/exch_faq.htm
Don't send mail to this address mailto:h.pott@getronics.com

[Rich Matheisen [MVP]]

"Asher_N" <compguy666@hotmail.com> wrote:

"Rich Matheisen [MVP]" <richnews@rmcons.com.NOSPAM.COM> wrote in
news:rk0ji1916h1ajj0fjkb2q15vqnpl15db2h@4ax.com:

"Asher_N" <compguy666@hotmail.com> wrote:

"Rich Matheisen [MVP]" <richnews@rmcons.com.NOSPAM.COM> wrote in
news:fq3hi1dr9md252rhnuk8u63htg0hups1ol@4ax.com:

Tha attachments are less than 100K. I can open them. It's the users
that also reveive them on a Blackberry that have the problem. Of
course, those happen to be the Senior Directors :)

Are you using BES or just the desktop synch? If it's BES, have you
considered it might be a problem with that software?


I'm using BES. I'm leaning more towards a SQL RS problem, but I tought
I'd also give the Exchange group a shot. It's only attachments coming
from RS to BB users when Exchange is accessed through OWA. At this point
I'm ready to consider the phase of the moon as a possible trigger.

I'm not familiar with the ability of SQL Server to manage the format
of the mail it sends, but if it's possible, try altering the format
from, say, plain test to HTML, or from MIME encoding to using
UUENCODE.

--
Rich Matheisen
MCSE+I, Exchange MVP
MS Exchange FAQ at http://www.swinc.com/resource/exch_faq.htm
Don't send mail to this address mailto:h.pott@getronics.com

[Asher_N]

"Rich Matheisen [MVP]" <richnews@rmcons.com.NOSPAM.COM> wrote in
news:ttcji15klo6g72spl738lfc08qe8qodd2b@4ax.com:

"Asher_N" <compguy666@hotmail.com> wrote:

"Rich Matheisen [MVP]" <richnews@rmcons.com.NOSPAM.COM> wrote in
news:rk0ji1916h1ajj0fjkb2q15vqnpl15db2h@4ax.com:

"Asher_N" <compguy666@hotmail.com> wrote:

"Rich Matheisen [MVP]" <richnews@rmcons.com.NOSPAM.COM> wrote in
news:fq3hi1dr9md252rhnuk8u63htg0hups1ol@4ax.com:

Tha attachments are less than 100K. I can open them. It's the users
that also reveive them on a Blackberry that have the problem. Of
course, those happen to be the Senior Directors :)

Are you using BES or just the desktop synch? If it's BES, have you
considered it might be a problem with that software?


I'm using BES. I'm leaning more towards a SQL RS problem, but I tought
I'd also give the Exchange group a shot. It's only attachments coming
from RS to BB users when Exchange is accessed through OWA. At this
point
I'm ready to consider the phase of the moon as a possible trigger.

I'm not familiar with the ability of SQL Server to manage the format
of the mail it sends, but if it's possible, try altering the format
from, say, plain test to HTML, or from MIME encoding to using
UUENCODE.

I can't be changed.

[chicagoclone]

any luck with this.

"Asher_N" wrote:

"Rich Matheisen [MVP]" <richnews@rmcons.com.NOSPAM.COM> wrote in
news:ttcji15klo6g72spl738lfc08qe8qodd2b@4ax.com:

"Asher_N" <compguy666@hotmail.com> wrote:

"Rich Matheisen [MVP]" <richnews@rmcons.com.NOSPAM.COM> wrote in
news:rk0ji1916h1ajj0fjkb2q15vqnpl15db2h@4ax.com:

"Asher_N" <compguy666@hotmail.com> wrote:

"Rich Matheisen [MVP]" <richnews@rmcons.com.NOSPAM.COM> wrote in
news:fq3hi1dr9md252rhnuk8u63htg0hups1ol@4ax.com:

Tha attachments are less than 100K. I can open them. It's the users
that also reveive them on a Blackberry that have the problem. Of
course, those happen to be the Senior Directors :)

Are you using BES or just the desktop synch? If it's BES, have you
considered it might be a problem with that software?


I'm using BES. I'm leaning more towards a SQL RS problem, but I tought
I'd also give the Exchange group a shot. It's only attachments coming
from RS to BB users when Exchange is accessed through OWA. At this
point
I'm ready to consider the phase of the moon as a possible trigger.

I'm not familiar with the ability of SQL Server to manage the format
of the mail it sends, but if it's possible, try altering the format
from, say, plain test to HTML, or from MIME encoding to using
UUENCODE.


I can't be changed.

[Asher_N]

No. It's still there.

=?Utf-8?B?Y2hpY2Fnb2Nsb25l?= <chicagoclone@discussions.microsoft.com>
wrote in news:AEE40733-0DE5-4DAB-AF5C-6C383EC02A25@microsoft.com:

any luck with this.

"Asher_N" wrote:

"Rich Matheisen [MVP]" <richnews@rmcons.com.NOSPAM.COM> wrote in
news:ttcji15klo6g72spl738lfc08qe8qodd2b@4ax.com:

"Asher_N" <compguy666@hotmail.com> wrote:

"Rich Matheisen [MVP]" <richnews@rmcons.com.NOSPAM.COM> wrote in
news:rk0ji1916h1ajj0fjkb2q15vqnpl15db2h@4ax.com:

"Asher_N" <compguy666@hotmail.com> wrote:

"Rich Matheisen [MVP]" <richnews@rmcons.com.NOSPAM.COM> wrote in
news:fq3hi1dr9md252rhnuk8u63htg0hups1ol@4ax.com:

Tha attachments are less than 100K. I can open them. It's the
users that also reveive them on a Blackberry that have the
problem. Of course, those happen to be the Senior Directors :)

Are you using BES or just the desktop synch? If it's BES, have
you considered it might be a problem with that software?


I'm using BES. I'm leaning more towards a SQL RS problem, but I
tought I'd also give the Exchange group a shot. It's only
attachments coming from RS to BB users when Exchange is accessed
through OWA. At this
point
I'm ready to consider the phase of the moon as a possible trigger.

I'm not familiar with the ability of SQL Server to manage the
format of the mail it sends, but if it's possible, try altering the
format from, say, plain test to HTML, or from MIME encoding to
using UUENCODE.


I can't be changed.

[philhege]

I have the same problem. The reason is that SQL Mail sends its
attachments in Unicode, which for some reason BB can't handle as an
attachment. The only alternative I see is to direct the query output
to the message body. My reports aren't that large, but 100K seems like
a lot to spill.

Any other ideas?


Asher_N wrote:

No. It's still there.

=?Utf-8?B?Y2hpY2Fnb2Nsb25l?= <chicagoclone@discussions.microsoft.com
wrote in news:AEE40733-0DE5-4DAB-AF5C-6C383EC02A25@microsoft.com:

any luck with this.

"Asher_N" wrote:

"Rich Matheisen [MVP]" <richnews@rmcons.com.NOSPAM.COM> wrote in
news:ttcji15klo6g72spl738lfc08qe8qodd2b@4ax.com:

"Asher_N" <compguy666@hotmail.com> wrote:

"Rich Matheisen [MVP]" <richnews@rmcons.com.NOSPAM.COM> wrote in
news:rk0ji1916h1ajj0fjkb2q15vqnpl15db2h@4ax.com:

"Asher_N" <compguy666@hotmail.com> wrote:

"Rich Matheisen [MVP]" <richnews@rmcons.com.NOSPAM.COM> wrote in
news:fq3hi1dr9md252rhnuk8u63htg0hups1ol@4ax.com:

Tha attachments are less than 100K. I can open them. It's the
users that also reveive them on a Blackberry that have the
problem. Of course, those happen to be the Senior Directors :)

Are you using BES or just the desktop synch? If it's BES, have
you considered it might be a problem with that software?


I'm using BES. I'm leaning more towards a SQL RS problem, but I
tought I'd also give the Exchange group a shot. It's only
attachments coming from RS to BB users when Exchange is accessed
through OWA. At this
point
I'm ready to consider the phase of the moon as a possible trigger.

I'm not familiar with the ability of SQL Server to manage the
format of the mail it sends, but if it's possible, try altering the
format from, say, plain test to HTML, or from MIME encoding to
using UUENCODE.


I can't be changed.