Connecting To Data Base In Sql Server 2000 - ActiveX Script Of A SQL Job

Hi All,

I' m trying to execute activeX script from a job. I could do it successfully. But when i tried to access data base the job is failed when running.


My Requirement : I would like to send a mail in a scheduled base using a job and activeX script.



I could send a mail giving static parameters. But as i need to make the parameter values of activeX script dynamic, i tried to connect data base and retrieve the required data as shown below.
When i parse the script it showed success.But this is failing when it is running.

while creating a job i had selected ActiveX script option with vbscript language
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
Set con = Server.CreateObject("ADODB.Connection")
con.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;password=welcome;Initial Catalog=MyDatabase;Data Source=(local); "
Set rs = Server.CreateObject("ADODB.Recordset")
Set rs = con.execute("select fromid,toid,seqid from MailsLog where status='N'")
while rs.eof <> true
con.execute ("update MailsLog set status='Y' where seqid = " & rs("seqid"))
wend
set rs = nothing
set con = nothing

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////



Could any one please help me in this regard, of accessing activeX script with connecting to data base.

I' ll be so kind of any immediate response.
Thanking You

Ganesh