C
CS
I have a stored procedure which sends out an email to all the users
listed in the database. for some reasons I am not getting all emails.
could someone offere some assistance?
Here's my code. Global.asa
Sub Session_OnStart
'==Visual InterDev Generated - DataConnection startspan==
'--BCSI Data Connection
Session("TMS_ConnectionString") = "DSN=Test"
Session("TMS_ConnectionTimeout") = 60
Session("TMS_CommandTimeout") = 60
Session("TMS_RuntimeUserName") = " "
Session("TMS_RuntimePassword") = ""
End Sub
My asp page:
Set cnTMS = Server.CreateObject("ADODB.Connection")
cnTMS.ConnectionTimeout = Session("TMS_ConnectionTimeout")
cnTMS.CommandTimeout = Session("TMS_CommandTimeout")
cnTMS.Open Session("TMS_ConnectionString"),
Session("TMS_RuntimeUserName"), Session("TMS_RuntimePassword")
Set rsTMS = Server.CreateObject("ADODB.Recordset")
Set cmdTMS = Server.CreateObject("ADODB.command")
cmdTMS.CommandText = " "
'
cmdTMS.CommandText = "Exec Test_ResStaffEmail"
'
cmdTMS.CommandType = 1
Set cmdTMS.ActiveConnection = cnTMS
rsTMS.Open cmdTMS, , 1, 3
'
' rsTMS.Close
'
Set cmdTMS = Nothing
Set rsTMS = Nothing
Am i missing somethins as it is supposed to send out 90 emails but i
receive only 5? Teh stored procedure is getting executed but the mails
are not coming through.
Thanks
listed in the database. for some reasons I am not getting all emails.
could someone offere some assistance?
Here's my code. Global.asa
Sub Session_OnStart
'==Visual InterDev Generated - DataConnection startspan==
'--BCSI Data Connection
Session("TMS_ConnectionString") = "DSN=Test"
Session("TMS_ConnectionTimeout") = 60
Session("TMS_CommandTimeout") = 60
Session("TMS_RuntimeUserName") = " "
Session("TMS_RuntimePassword") = ""
End Sub
My asp page:
Set cnTMS = Server.CreateObject("ADODB.Connection")
cnTMS.ConnectionTimeout = Session("TMS_ConnectionTimeout")
cnTMS.CommandTimeout = Session("TMS_CommandTimeout")
cnTMS.Open Session("TMS_ConnectionString"),
Session("TMS_RuntimeUserName"), Session("TMS_RuntimePassword")
Set rsTMS = Server.CreateObject("ADODB.Recordset")
Set cmdTMS = Server.CreateObject("ADODB.command")
cmdTMS.CommandText = " "
'
cmdTMS.CommandText = "Exec Test_ResStaffEmail"
'
cmdTMS.CommandType = 1
Set cmdTMS.ActiveConnection = cnTMS
rsTMS.Open cmdTMS, , 1, 3
'
' rsTMS.Close
'
Set cmdTMS = Nothing
Set rsTMS = Nothing
Am i missing somethins as it is supposed to send out 90 emails but i
receive only 5? Teh stored procedure is getting executed but the mails
are not coming through.
Thanks