register.asp not recording emails in SQL2 |
Post Reply 
|
| Author | |
bearb319 
Newbie 
Joined: 22 February 2005 Status: Offline Points: 2 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: register.asp not recording emails in SQL2Posted: 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
|
|
 |
|
|
Desperado
Senior Member 
Joined: 27 January 2005 Location: United States Status: Offline Points: 1143 |
Post Options
Thanks(0)
Quote Reply
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 |
|
|
|
|
bearb319
Guest Group 
|
Post Options
Thanks(0)
Quote Reply
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 |
|
|
|
|
Desperado
Senior Member
Joined: 27 January 2005 Location: United States Status: Offline Points: 1143 |
Post Options
Thanks(0)
Quote Reply
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 |
|
|
|
|
LogSat
Admin Group 
Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
Quote Reply
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. |
|
|
|
Topic Options|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
This page was generated in 0.191 seconds.