Click here to Skip to main content
11,642,233 members (60,966 online)
   

Database

 
AnswerRe: CONNECTING MSSQL DB FILE FROM PEN DRIVE Pin
Eddy Vluggen23-Sep-12 2:38
memberEddy Vluggen23-Sep-12 2:38 
AnswerRe: CONNECTING MSSQL DB FILE FROM PEN DRIVE Pin
jschell23-Sep-12 8:10
memberjschell23-Sep-12 8:10 
GeneralRe: CONNECTING MSSQL DB FILE FROM PEN DRIVE Pin
r_mohd24-Sep-12 2:28
memberr_mohd24-Sep-12 2:28 
GeneralRe: CONNECTING MSSQL DB FILE FROM PEN DRIVE Pin
jschell24-Sep-12 12:37
memberjschell24-Sep-12 12:37 
QuestionDb over internet Pin
leone22-Sep-12 8:56
memberleone22-Sep-12 8:56 
AnswerRe: Db over internet Pin
Eddy Vluggen23-Sep-12 0:42
memberEddy Vluggen23-Sep-12 0:42 
AnswerRe: Db over internet Pin
jschell23-Sep-12 8:16
memberjschell23-Sep-12 8:16 
GeneralRe: Db over internet Pin
leone24-Sep-12 0:45
memberleone24-Sep-12 0:45 
GeneralRe: Db over internet Pin
Jörgen Andersson24-Sep-12 2:05
memberJörgen Andersson24-Sep-12 2:05 
AnswerRe: Db over internet Pin
Chris Quinn27-Sep-12 2:36
memberChris Quinn27-Sep-12 2:36 
Questionconnection of mssql 2008 to cloud in windows form application Pin
KUNWAR99921-Sep-12 3:28
memberKUNWAR99921-Sep-12 3:28 
AnswerRe: connection of mssql 2008 to cloud in windows form application Pin
David Mujica21-Sep-12 3:50
memberDavid Mujica21-Sep-12 3:50 
AnswerRe: connection of mssql 2008 to cloud in windows form application Pin
Eddy Vluggen21-Sep-12 4:44
memberEddy Vluggen21-Sep-12 4:44 
QuestionSQL XP_StartSMTP to send email Pin
MWRivera20-Sep-12 5:45
memberMWRivera20-Sep-12 5:45 
Hi All,

I'm trying to send an email using a SQL procedure within SQL Anywhere 11. I have the following SQL statements to do this:

ALTER PROCEDURE "DBName"."WebFormNotify"()
begin
call xp_startsmtp('*A*@***.org', 'SMTP_Relay_server_name');
call xp_sendmail(recipient = '*B*@***.org',subject = 'SMTP SYBASE TEST',"message" = 'SMTP SYBASE TEST');
call xp_stopsmtp()
end

This is being ran from the server that has SMTP Relay setup on it. I am able to use telnet and send an email successfully. The procedure runs with no errors but the email is never recieved by the recipient. I have also replaced the second parameter passed into xp_startsmtp with the name of the actual SMTP server itself, but still no email was recieved by the recipient.

Any help on this would be really appreciated. Pleas elet me know if additional information is needed.

Thank you,
Mel
AnswerRe: SQL XP_StartSMTP to send email Pin
Chris Meech21-Sep-12 2:45
memberChris Meech21-Sep-12 2:45 
AnswerRe: SQL XP_StartSMTP to send email Pin
Eddy Vluggen21-Sep-12 4:47
memberEddy Vluggen21-Sep-12 4:47 
QuestionContinuous absent query Pin
RA|-|UL PATEL20-Sep-12 3:16
memberRA|-|UL PATEL20-Sep-12 3:16 
AnswerRe: Continuous absent query Pin
djj5520-Sep-12 8:04
memberdjj5520-Sep-12 8:04 
AnswerRe: Continuous absent query Pin
HiteshDR5-Nov-12 23:24
memberHiteshDR5-Nov-12 23:24 
Questionhow to update combobox values in msaccess tables in ACCESS2007 Pin
sowmya4919-Sep-12 20:40
membersowmya4919-Sep-12 20:40 
QuestionSpecifying Seed Values on model building Pin
solomon20118-Sep-12 5:34
membersolomon20118-Sep-12 5:34 
AnswerRe: Specifying Seed Values on model building Pin
Simon_Whale18-Sep-12 5:47
memberSimon_Whale18-Sep-12 5:47 
GeneralRe: Specifying Seed Values on model building Pin
mark merrens18-Sep-12 8:19
membermark merrens18-Sep-12 8:19 
AnswerRe: Specifying Seed Values on model building Pin
mark merrens18-Sep-12 8:22
membermark merrens18-Sep-12 8:22 
AnswerRe: Specifying Seed Values on model building Pin
Eddy Vluggen21-Sep-12 4:52
memberEddy Vluggen21-Sep-12 4:52 
Questionmultiple data instances one machine Pin
John Robert Wilk17-Sep-12 8:15
memberJohn Robert Wilk17-Sep-12 8:15 
AnswerRe: multiple data instances one machine Pin
Jörgen Andersson17-Sep-12 8:55
memberJörgen Andersson17-Sep-12 8:55 
AnswerRe: multiple data instances one machine Pin
Wes Aday17-Sep-12 9:01
memberWes Aday17-Sep-12 9:01 
GeneralRe: multiple data instances one machine Pin
John Robert Wilk17-Sep-12 9:08
memberJohn Robert Wilk17-Sep-12 9:08 
GeneralRe: multiple data instances one machine Pin
Wes Aday17-Sep-12 9:14
memberWes Aday17-Sep-12 9:14 
GeneralRe: multiple data instances one machine Pin
John Robert Wilk17-Sep-12 9:17
memberJohn Robert Wilk17-Sep-12 9:17 
GeneralRe: multiple data instances one machine Pin
Wes Aday17-Sep-12 9:23
memberWes Aday17-Sep-12 9:23 
AnswerRe: multiple data instances one machine Pin
jschell17-Sep-12 9:16
memberjschell17-Sep-12 9:16 
GeneralRe: multiple data instances one machine Pin
John Robert Wilk17-Sep-12 9:21
memberJohn Robert Wilk17-Sep-12 9:21 
GeneralRe: multiple data instances one machine Pin
jschell18-Sep-12 8:00
memberjschell18-Sep-12 8:00 
AnswerRe: multiple data instances one machine Pin
Eddy Vluggen21-Sep-12 4:54
memberEddy Vluggen21-Sep-12 4:54 
QuestionSQL Error - Insert happening on update Pin
loctrice17-Sep-12 7:32
memberloctrice17-Sep-12 7:32 
AnswerRe: SQL Error - Insert happening on update Pin
Andrei Straut17-Sep-12 7:44
memberAndrei Straut17-Sep-12 7:44 
GeneralRe: SQL Error - Insert happening on update Pin
loctrice17-Sep-12 7:51
memberloctrice17-Sep-12 7:51 
GeneralRe: SQL Error - Insert happening on update Pin
Andrei Straut17-Sep-12 7:54
memberAndrei Straut17-Sep-12 7:54 
GeneralRe: SQL Error - Insert happening on update Pin
loctrice17-Sep-12 7:56
memberloctrice17-Sep-12 7:56 
Questionmy SQl Pin
sreenadhmn16-Sep-12 23:16
membersreenadhmn16-Sep-12 23:16 
AnswerRe: my SQl Pin
Andrei Straut16-Sep-12 23:54
memberAndrei Straut16-Sep-12 23:54 
GeneralRe: my SQl Pin
Mycroft Holmes17-Sep-12 2:15
memberMycroft Holmes17-Sep-12 2:15 
GeneralRe: my SQl Pin
Andrei Straut17-Sep-12 2:27
memberAndrei Straut17-Sep-12 2:27 
GeneralRe: my SQl Pin
Richard MacCutchan17-Sep-12 4:44
mvpRichard MacCutchan17-Sep-12 4:44 
GeneralRe: my SQl Pin
Andrei Straut17-Sep-12 5:26
memberAndrei Straut17-Sep-12 5:26 
GeneralRe: my SQl Pin
Jörgen Andersson17-Sep-12 8:50
memberJörgen Andersson17-Sep-12 8:50 
GeneralRe: my SQl Pin
Andrei Straut17-Sep-12 9:45
memberAndrei Straut17-Sep-12 9:45 
QuestionInline code SQL 2005 Pin
Member 916254415-Sep-12 19:52
memberMember 916254415-Sep-12 19:52 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web03 | 2.8.150731.1 | Last Updated 31 Jul 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid