ASA 8.0.3.5574

Hi,

within one project we use xp_sendmail for sending some emails with
attachment. I'm sure this already worked correctly.

But something happend (I have no idea when or what) and xp_sendmail now
does nothing at all. We don't get a mail sent and we don't even get a
resonse. Our procedure just waits and waits and ....

How to find out what could be cause for that? Any Windows SP maybe?

Regards
Fabian

Hi Fabian,

When you say that the procedure waits, do you mean that it's hanging on
the call to xp_sendmail? If you just call xp_startsmtp and xp_sendmail
from an interactive tool like dbisql, does the email get sent?

Mark Johnston

Fabian Knauf wrote:

Hello,

has really nobody an idea?

As an additional information:
- we tried running the dbserver as a service on system account and also
on a useraccount
- xp_startmail() das not return an error, regardless which user and
password we use
- using xp_sendmail() with smtp works fine but sometimes we need to
attach a file and then smtp is not working

Any ideas?

Thanks
Fabian

Fabian,

Fabian Knauf wrote:
From: (Mark Culp)
http://forums.sybase.com/cgi-bin/web...42516da10ee200

ASA [8.0.x /] 9.0.x does not support the ability to send attachments if
you are using SMTP... but it can send attachments if you use MAPI.

In SA 10, xp_sendmail has been enhanced so that you can send attachments
using both SMTP and MAPI.

--
Jeff Albion, Sybase iAnywhere

iAnywhere Developer Community :
http://www.sybase.com/developer/libr...ere-techcorner
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summ...&timeframe =0
Report a Bug/Open a Case : http://case-express.sybase.com/cx/

Are you saying the return code is zero but it doesn't do anything?

These functions don't raise errors, they set return codes...

@return_code = CALL xp_startsmtp ( ...

Are you saying the return code is zero even when you pass invalid
parameter values?

Please show us the code that is not working.

Breck


On 2 Sep 2009 08:49:31 -0700, Fabian Knauf <fk2412 (AT) web (DOT) de> wrote:

--
Breck Carter http://sqlanywhere.blogspot.com/

RisingRoad SQL Anywhere and MobiLink Professional Services
breck.carter (AT) risingroad (DOT) com

Jeff,

we use:

- xp_startsmtp and xp_sendmail to send mails without attachements: works
with no problems

- xp_startmail and xp_sendmail to send mails with attachements: doesn't work
as Fabian described (hangs in xp_sendmail with no return)

See answer to Breck with attached code.

Regards,
Claus Wagner



"Jeff Albion [Sybase iAnywhere]" <firstname.lastname (AT) ianywhere (DOT) com> schrieb
im Newsbeitrag news:4a9e9a0f$1 (AT) forums-1-dub (DOT) ..

Claus,

Claus Wagner wrote:
Yes, and Fabian posted the current version as:

"ASA 8.0.3.5574"

which does not support sending attachments via SMTP as Mark Culp
originally wrote. 8.0.3 is also out of engineering support, so the
behaviour is the behaviour at this point - there will not be any further
EBFs on this version.

If the difference between xp_sendmail working and not working is the
presence of an attachment, then it's clear what's causing the hang
condition. I'm skeptical of Fabian's suggestion that this 'used to work'
- our understanding is that it never should have.

Regards,

--
Jeff Albion, Sybase iAnywhere

iAnywhere Developer Community :
http://www.sybase.com/developer/libr...ere-techcorner
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summ...&timeframe =0
Report a Bug/Open a Case : http://case-express.sybase.com/cx/

Hi Jeff,

Beleive me: I know that and I never wrote that we tried sending
attachments with smtp!

We normaly send emails WITHOUT attachment with smtp (xp_startsmtp()),
and in the cases we want an attachment we use MAPI (xp_startmail()).

Both versions worked!

But since I don't really know when, the following xp_sendmail() returns
nothing at all.

You can have a look at the code Claus attached at his post to Breck.
There you can see the difference in our two different email-functions.


maybe an idea what could have caused our originally working function not
work anymore.


Fabian

Hi Fabian,

Fabian Knauf wrote:
My apologies, I had misread Claus' last message - I had read over the
part where you were starting MAPI in the attachment condition. I had
also read this message from yourself:

Which gave me the impression you were trying this operation over SMTP
still. I assume this was to read 'MAPI'?

You might want to open a technical support case then looking for
workarounds / help with diagnostics - was there a change in the MAPI
server, perhaps? Change in the EBF level?

Regards,

--
Jeff Albion, Sybase iAnywhere

iAnywhere Developer Community :
http://www.sybase.com/developer/libr...ere-techcorner
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summ...&timeframe =0
Report a Bug/Open a Case : http://case-express.sybase.com/cx/

Am Hi,

just for information:
I created a new Administrator user on the server and I run the DB
service as this user now. And it works again!

Regards
Florian