problem with xp_smtp_sendmail

Hi friends, i have trying to make a procedure to send an email tom my
e-mail account using xp_smtp_sendmail, but y
have a problem and i don't know why i dont receive any message. I make ping
to the server and it works but when i run this:
declare @.rc int
exec @.rc = master.dbo.xp_smtp_sendmail
@.FROM = N'dep.tecnico@.prmconsultores.com',
@.TO = N'dep.tecnico@.prmconsultores.com',
@.server = N'smtp.prmconsultores.com'
select RC = @.rc
go
the result of rc=1 and any message is send.
Someone can help me.
thanks in advance.
Sure, try to connect to the mailserver you are sending to. Use telnet
for this to clarify if the server accepts non-authenticated relaying
(most productional server don=B4t do this).
-Open the commandline
-type: telnet <Servername> 25
-type: helo
-type: mailfrom:<YourMailAdress>
-type: rcptto:<ReceiptientMailAdress>
-type: data
-type: <two returns>
Mail will be send OR and error message will be presented (eventually
during the steps above).
Post the error back if any.
HTH, jens Suessmeyer.
|||Thanks for help. I have tried to make telnet
telnet smtp.prmconsultores.com 25
but it returns error like this:
connection error, can't open the connection to the host to 25 port
i think that the host don't accepts non-authenticated relaying as yuo say.
thanks any way.
"Jens" <Jens@.sqlserver2005.de> escribi en el mensaje
news:1137756243.009895.16250@.g43g2000cwa.googlegro ups.com...
Sure, try to connect to the mailserver you are sending to. Use telnet
for this to clarify if the server accepts non-authenticated relaying
(most productional server dont do this).
-Open the commandline
-type: telnet <Servername> 25
-type: helo
-type: mailfrom:<YourMailAdress>
-type: rcptto:<ReceiptientMailAdress>
-type: data
-type: <two returns>
Mail will be send OR and error message will be presented (eventually
during the steps above).
Post the error back if any.
HTH, jens Suessmeyer.
|||Wait a minute, wait a minute. The attempt you made was just below the
application layer. So there might be a connection problem rather than a
authentification problem. "Denied relying" is presented when you
connect successfully to the remote computer and stated the command
above. If the server above is public you can be sure that unknown
mailservers are blocked. But a way around would be to install a virtual
SMTP server (like this one which comes with IIS) and relay the message
to a trusted mail server and then send it with credentials to a public
webserver.
HTH, jens Suessmeyer.

problem with xp_smtp_sendmail

Hi friends, i have trying to make a procedure to send an email tom my
e-mail account using xp_smtp_sendmail, but y
have a problem and i don't know why i dont receive any message. I make ping
to the server and it works but when i run this:
declare @.rc int
exec @.rc = master.dbo.xp_smtp_sendmail
@.FROM = N'dep.tecnico@.prmconsultores.com',
@.TO = N'dep.tecnico@.prmconsultores.com',
@.server = N'smtp.prmconsultores.com'
select RC = @.rc
go
the result of rc=1 and any message is send.
Someone can help me.
thanks in advance.Sure, try to connect to the mailserver you are sending to. Use telnet
for this to clarify if the server accepts non-authenticated relaying
(most productional server don=B4t do this).
-Open the commandline
-type: telnet <Servername> 25
-type: helo
-type: mailfrom:<YourMailAdress>
-type: rcptto:<ReceiptientMailAdress>
-type: data
-type: <two returns>
Mail will be send OR and error message will be presented (eventually
during the steps above).
Post the error back if any.
HTH, jens Suessmeyer.|||Thanks for help. I have tried to make telnet
telnet smtp.prmconsultores.com 25
but it returns error like this:
connection error, can't open the connection to the host to 25 port
i think that the host don't accepts non-authenticated relaying as yuo say.
thanks any way.
"Jens" <Jens@.sqlserver2005.de> escribi en el mensaje
news:1137756243.009895.16250@.g43g2000cwa.googlegroups.com...
Sure, try to connect to the mailserver you are sending to. Use telnet
for this to clarify if the server accepts non-authenticated relaying
(most productional server dont do this).
-Open the commandline
-type: telnet <Servername> 25
-type: helo
-type: mailfrom:<YourMailAdress>
-type: rcptto:<ReceiptientMailAdress>
-type: data
-type: <two returns>
Mail will be send OR and error message will be presented (eventually
during the steps above).
Post the error back if any.
HTH, jens Suessmeyer.|||Wait a minute, wait a minute. The attempt you made was just below the
application layer. So there might be a connection problem rather than a
authentification problem. "Denied relying" is presented when you
connect successfully to the remote computer and stated the command
above. If the server above is public you can be sure that unknown
mailservers are blocked. But a way around would be to install a virtual
SMTP server (like this one which comes with IIS) and relay the message
to a trusted mail server and then send it with credentials to a public
webserver.
HTH, jens Suessmeyer.

problem with xp_smtp_sendmail

Hi friends, i have trying to make a procedure to send an email tom my
e-mail account using xp_smtp_sendmail, but y
have a problem and i don't know why i dont receive any message. I make ping
to the server and it works but when i run this:
declare @.rc int
exec @.rc = master.dbo.xp_smtp_sendmail
@.FROM = N'dep.tecnico@.prmconsultores.com',
@.TO = N'dep.tecnico@.prmconsultores.com',
@.server = N'smtp.prmconsultores.com'
select RC = @.rc
go
the result of rc=1 and any message is send.
Someone can help me.
thanks in advance.Sure, try to connect to the mailserver you are sending to. Use telnet
for this to clarify if the server accepts non-authenticated relaying
(most productional server don=B4t do this).
-Open the commandline
-type: telnet <Servername> 25
-type: helo
-type: mailfrom:<YourMailAdress>
-type: rcptto:<ReceiptientMailAdress>
-type: data
-type: <two returns>
Mail will be send OR and error message will be presented (eventually
during the steps above).
Post the error back if any.
HTH, jens Suessmeyer.|||Thanks for help. I have tried to make telnet
telnet smtp.prmconsultores.com 25
but it returns error like this:
connection error, can't open the connection to the host to 25 port
i think that the host don't accepts non-authenticated relaying as yuo say.
thanks any way.
"Jens" <Jens@.sqlserver2005.de> escribió en el mensaje
news:1137756243.009895.16250@.g43g2000cwa.googlegroups.com...
Sure, try to connect to the mailserver you are sending to. Use telnet
for this to clarify if the server accepts non-authenticated relaying
(most productional server don´t do this).
-Open the commandline
-type: telnet <Servername> 25
-type: helo
-type: mailfrom:<YourMailAdress>
-type: rcptto:<ReceiptientMailAdress>
-type: data
-type: <two returns>
Mail will be send OR and error message will be presented (eventually
during the steps above).
Post the error back if any.
HTH, jens Suessmeyer.|||Wait a minute, wait a minute. The attempt you made was just below the
application layer. So there might be a connection problem rather than a
authentification problem. "Denied relying" is presented when you
connect successfully to the remote computer and stated the command
above. If the server above is public you can be sure that unknown
mailservers are blocked. But a way around would be to install a virtual
SMTP server (like this one which comes with IIS) and relay the message
to a trusted mail server and then send it with credentials to a public
webserver.
HTH, jens Suessmeyer.

Problem with values returned by Calculated Member

Dear Friends,

I have a problem with CM:

Example

Row Field1 Field2 Field3 Total

1 31662 1 14,75 467014,5

2 250000 1 6,94 1735000

Total for each row= Field1*Field3 / Field2

The value I want for Calculated Member is Total1 + Total 2, 2202014,5, but the value is wrong... The calculated member gives me the value from: SUM Field1* SUM Field3 / SUM Field2, 3054624,39

The MDX:

[Measures].[Open Pos]*[Measures].[New Price]/[Measures].[Fx Rate Rep Cur]

And all the measures are with AggregateFunction as SUM...

Where is the problem? How can I calculate each row in spite of the sum?

Thanks!!

More help to you:

29-12-2006 BANCO PASTOR SA 31662 1 14,75 467.014,50 29-12-2006 GALP ENERGIA SGPS SA B 250000 1 6,94 1.735.000,00

For the date 29.12.2006 I want the calculated member with the value 2202014,5

And currently I'having the value 3054624,39.

|||Is the required calculation Sum(Field 1 * Field 3) / Sum (Field 2)? If so, try adding a calculated column to the DSV that does the (Field 1 * Field 3) calculation. Add this as a new measure, with Sum as the aggregation function. Then your calculated measure will be (New Measure) / (Field 2).|||

for the date 29-12-2006 I need to calculate each line of fact Table...

Example:

Date Field1 Field2 Field3 EachRow 29-12-2006 100 1 5 500 29-12-2006 200 1 4 800 29-12-2006 300 1 2 600 Correct 1900

As I did, in Calculated Member, the value returned is not 1900, but is 2200!! :-(

29-12-2006 600 3 11 2200

Understood?

Thanks!

|||

Then just add the entire calculation ( (Field 1 * Field 3) / Field 2 ) as a calculated column in your DSV. Create a new measure on that column, and set the AggregationFunction to SUM.

Anytime you need something calculated at the fact level, it's usually best to either add it to fact table directly, or include it in the DSV.

|||But field1 is a named calculation, and I cant use this value to create a new named calculation... :-(|||You should be able to replicate the calculation for Field1 in your new calculated column.|||

How can I do it?

When I am creating the second named calculation, in the expression textbox I wrote: [Field1]+1

and returned me the error message: Invalid column named 'Field1'

Field1 is a named calculation... :-(

|||Copy the expression from Field1 into Field2, and add the additional calculations that need to be performed.|||

The problem is that the calculations in named calculation Field 1 is not so simple...

yeh.. but I understood that is no possible call a NC from another NC... thanks!

Problem with values returned by Calculated Member

Dear Friends,

I have a problem with CM:

Example

Row Field1 Field2 Field3 Total

1 31662 1 14,75 467014,5

2 250000 1 6,94 1735000

Total for each row= Field1*Field3 / Field2

The value I want for Calculated Member is Total1 + Total 2, 2202014,5, but the value is wrong... The calculated member gives me the value from: SUM Field1* SUM Field3 / SUM Field2, 3054624,39

The MDX:

[Measures].[Open Pos]*[Measures].[New Price]/[Measures].[Fx Rate Rep Cur]

And all the measures are with AggregateFunction as SUM...

Where is the problem? How can I calculate each row in spite of the sum?

Thanks!!

More help to you:

29-12-2006

BANCO PASTOR SA

31662

1

14,75

467.014,50

29-12-2006

GALP ENERGIA SGPS SA B

250000

1

6,94

1.735.000,00

For the date 29.12.2006 I want the calculated member with the value 2202014,5

And currently I'having the value 3054624,39.

|||Is the required calculation Sum(Field 1 * Field 3) / Sum (Field 2)? If so, try adding a calculated column to the DSV that does the (Field 1 * Field 3) calculation. Add this as a new measure, with Sum as the aggregation function. Then your calculated measure will be (New Measure) / (Field 2).|||

for the date 29-12-2006 I need to calculate each line of fact Table...

Example:

Date

Field1

Field2

Field3

EachRow

29-12-2006

100

1

5

500

29-12-2006

200

1

4

800

29-12-2006

300

1

2

600

Correct

1900

As I did, in Calculated Member, the value returned is not 1900, but is 2200!! :-(

29-12-2006

600

3

11

2200

Understood?

Thanks!

|||

Then just add the entire calculation ( (Field 1 * Field 3) / Field 2 ) as a calculated column in your DSV. Create a new measure on that column, and set the AggregationFunction to SUM.

Anytime you need something calculated at the fact level, it's usually best to either add it to fact table directly, or include it in the DSV.

|||But field1 is a named calculation, and I cant use this value to create a new named calculation... :-(|||You should be able to replicate the calculation for Field1 in your new calculated column.|||

How can I do it?

When I am creating the second named calculation, in the expression textbox I wrote: [Field1]+1

and returned me the error message: Invalid column named 'Field1'

Field1 is a named calculation... :-(

|||Copy the expression from Field1 into Field2, and add the additional calculations that need to be performed.|||

The problem is that the calculations in named calculation Field 1 is not so simple...

yeh.. but I understood that is no possible call a NC from another NC... thanks!