Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - register.asp not recording emails in SQL2
  FAQ FAQ  Forum Search   Register Register  Login Login

register.asp not recording emails in SQL2

 Post Reply Post Reply
Author
bearb319 View Drop Down
Newbie
Newbie


Joined: 22 February 2005
Status: Offline
Points: 2
Post Options Post Options   Thanks (0) Thanks(0)   Quote bearb319 Quote  Post ReplyReply Direct Link To This Post Topic: register.asp not recording emails in SQL2
    Posted: 02 March 2005 at 10:10am

I recently converted the access DB to sql2000. Now it appears that the register.asp page no longers "registers" the email account and adds it to the tblogins table. Could this be a permissions problem?

I am not a asp wizard or a sql master so any pointers will be most appreciated.

I'm also interested in using the code updates that have been posted here but apparently, I'm not setting something up correctly as they do not work. I went back to the dafault pages.

Cheers and TIA for any assistance,

Barry

 

Back to Top
Desperado View Drop Down
Senior Member
Senior Member
Avatar

Joined: 27 January 2005
Location: United States
Status: Offline
Points: 1143
Post Options Post Options   Thanks (0) Thanks(0)   Quote Desperado Quote  Post ReplyReply Direct Link To This Post Posted: 02 March 2005 at 1:40pm
Barry,
 
Without seeing your code, I am not sure what is going on BUT ... can you compare your Register.asp with the following section?
 
 Message = Message & "." & vbCRLF
 SQL = "SELECT * FROM tblMsgs WHERE 0 = 1"
 rs.Open(SQL)
 rs.AddNew
 rs("Msg") = Message
 rs.Update
 MsgID = rs("MsgID")
 rs.Close
 SQL="SELECT * FROM tblQuarantine WHERE 0 = 1"
 rs.Open(SQL)
 rs.AddNew
' rs("EMailFrom") = "Administrator <
support@yourdomain.com>"
 rs("EMailFrom") = "
support@yourdomain.comt"
 rs("EMailTo") = EMail
 rs("Subject") = "Your quarantine area password"
 rs("MsgID") = MsgID
 rs("MsgDate") = MessageDate
 rs("Expire") = 0
 rs("Deliver") = 1
'****** MAKE SURE THE SERVER ID IS CORRECT ******
 rs("ServerID") = 5
'******************************
 rs("RejectDetails") = ""
 rs("RejectID") = 0
 rs.Update
 rs.Close
 Set rs = Nothing
 
Regards,
The Desperado
Dan Seligmann.
Work: http://www.mags.net
Personal: http://www.desperado.com

Back to Top
bearb319 View Drop Down
Guest Group
Guest Group
Post Options Post Options   Thanks (0) Thanks(0)   Quote bearb319 Quote  Post ReplyReply Direct Link To This Post Posted: 02 March 2005 at 3:21pm

'****** MAKE SURE THE SERVER ID IS CORRECT ******

 

How would I know whhat the server ID is? This is installed ont he same box ( spamfilter and sql2000). The register.asp is the same file as what comes int he sample files from logsat.

 

Thanks!!!

 

Barry

Back to Top
Desperado View Drop Down
Senior Member
Senior Member
Avatar

Joined: 27 January 2005
Location: United States
Status: Offline
Points: 1143
Post Options Post Options   Thanks (0) Thanks(0)   Quote Desperado Quote  Post ReplyReply Direct Link To This Post Posted: 02 March 2005 at 4:02pm

Barry,

The server ID is in both the SQL Server "tblServers" and in the SpamFilter.ini entry: tblServersServerID=

AND ... look carefully at my sql query. If it is differant than the one you are using, I made the changes to make it work.  There is a thread somewhere on the Forum about this issue but as I said, see if there are differances in the email address format and also the exoire, rejectID and deliver settings.

Dan

The Desperado
Dan Seligmann.
Work: http://www.mags.net
Personal: http://www.desperado.com

Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4104
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post Posted: 02 March 2005 at 4:51pm
Barry,

In the ASP pages Desperado is correct in his suggestion to compare the register.asp page with the section he posted. More specifically, can you

rs("EMailFrom") = "System Administrator <>"

to something like

rs("EMailFrom") = "someemail@yourdomain.com"

For the ServerID you can use "0".

On another note, have yo uby any chance changed the computer's name? That would require changing the ServerID in the database.

Roberto Franceschetti

LogSat Software

Spam Filter ISP
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.320 seconds.