|
Since upgrade from SQL Anywhere 9 to 16 (build 2283) we have problems with the database server that does not response anymore. All clients that are connected are freezing. A new connection in ISQL freezes after a click on the "Connect" button. With request log we saw that the problem is in the command xp_startmail(). I created a small test sp that sends a email using the startmail, but the behavior is not always the same. Sometimes the db server freezes sometimes not. |
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- numbered list: 1. Foo 2. Bar
- to add a line break simply add two spaces to where you would like the new line to be.
- basic HTML tags are also supported
Question tags:
question asked: 20 Sep '16, 04:31
question was seen: 846 times
last updated: 20 Sep '16, 08:37
Could you show a snippet of your code to connect via MAPI and to send the mail, say, to show whether you check the return code for xp_startmail and the like?
Note that v16 has introduced the new xp_get_mail_error_text system procedure and xp_get_mail_error_code system procedure that could be of help here - in case you get a return code before the engine freezes...
Does the behaviour depend on the user/privileges trying to mail and/or the kind of recipient (part of your mail domain or not)?
sorry i'm so bored about this issue, that i did not think clearly... actually i'm using xp_startsmtp(); xp_sendmail(); xp_stopsmtp();
i will direct for the xp_startsmtp question.