Print Page | Close Window

register.asp not recording emails in SQL2

Printed From: LogSat Software
Category: Spam Filter ISP
Forum Name: Spam Filter ISP Support
Forum Description: General support for Spam Filter ISP
URL: http://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5083
Printed Date: 23 October 2017 at 6:47pm


Topic: register.asp not recording emails in SQL2
Posted By: bearb319
Subject: register.asp not recording emails in SQL2
Date 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

 




Replies:
Posted By: Desperado
Date 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 <
mailto:support@yourdomain.com - support@yourdomain.com >"
 rs("EMailFrom") = "
mailto:support@yourdomain.comt - 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



Posted By: Guests
Date 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



Posted By: Desperado
Date 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



Posted By: LogSat
Date 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

http://www.logsat.com" rel="nofollow - LogSat Software

http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP



Print Page | Close Window