changed to exchange and emails not working

[rsbutterfly16]

hi guys i had created an activex script that sends emails from sqlserver this is part of the code that pertains to my question:


'establish settings for sending of CDO message
myMail.Configuration.Fields.Item _
("

http://schemas.microsoft.com/cdo/configuration/sendusing")=2

'Name or IP of remote SMTP server
myMail.Configuration.Fields.Item _
("

http://schemas.microsoft.com/cdo/configuration/smtpserver")

_
="67.59.xxx.xxx"
'Server port
myMail.Configuration.Fields.Item _
("

http://schemas.microsoft.com/cdo/configuration/smtpserverport")

_
=25
myMail.Configuration.Fields.Update

'send and clean up
myMail.Send
set myMail=nothing



however i just changed my mail to exchange server and changed my profile to an exchange server profile and it is not sending any emails. How do i change this part of the code?

 

[mrdenny]

Based on the code provided all you should need to do is change the IP Address to the IP of the new Exchange server.

You may need to tell the Exchange server that the SQL Server is authorized to send email.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[rsbutterfly16]

how do i get the IP address of the exchange server?
what about the port#? does that change too?

 

[mrdenny]

Port number stays the same.

You can either ping the server or ask your windows admin.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[rsbutterfly16]

I got the IP address of where the exchange server resides, i changed it in the activex script ,when i run it i get no errors but i still don' t get the email

 

[mrdenny]

You'll have to have the Exchange Admin check the exchange server to see what happened to the email.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog