* This is the modus mailing list * Also, what version of Windows and MDAC are you running on the mail server? Thanks, Lewis
----- Original Message ----- From: "Lewis Watson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, November 29, 2003 1:08 PM Subject: [Modus] SQL died and is now rebuilt but needing assistance. > * This is the modus mailing list * > > Hi Ken, > Well, if you don't mind losing you current quarantine data you could try > and rebuild the quarantine database tables.. The script will automatically > drop and rebuild the tables used by Modus. Here's the how-to. > > http://www.vircom.com/L0g1n/Vircom_Clients/Howtos/howto/howtomodusmail_002.asp > > There are options in SQL to check and fix tables and I would certainly be > concerned as to why it stopped working. However, you probably will be able > to fix it without having to know why it happened, although it could happen > again. My thoughts were before rebuilding the tables was to verify it was > not just a communication problem between Modus and SQL. > Good luck, > Lewis > > > > ----- Original Message ----- > From: "Ken Grimes" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Saturday, November 29, 2003 12:57 PM > Subject: [Modus] SQL died and is now rebuilt but needing assistance. > > > > * This is the modus mailing list * > > > > Lewis, > > > > Everything works okay when in the native mdb, but when we move it back > to > > the SQL it has the same trouble. > > > > Thanks, > > Ken Grimes > > > > > > ----- Original Message ----- > > From: "Lewis Watson" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Saturday, November 29, 2003 11:37 AM > > Subject: [Modus] SQL died and is now rebuilt but needing assistance. > > > > > > > * This is the modus mailing list * > > > > > > Hi Ken, > > > Good, so we know that SQL is able to talk the mail server and we know > that > > > your ODBC connection is good. > > > > > > Try this: > > > Stop the Modusadm service. > > > Change the quarantine settings so that it uses the Access DB option. > > > Start the Modusadm service. > > > Click on the quarantine button and see if you get any errors. > > > > > > If you do not get any errors.... > > > Stop the ModusAdm service > > > Click the quarantine Database tab and configure your ODBC > information. > > > Start the ModusAdm service.... > > > Good luck, > > > Lewis > > > > > > > > > > > > > > > > > > > > > ----- Original Message ----- > > > From: "Ken Grimes" <[EMAIL PROTECTED]> > > > To: <[EMAIL PROTECTED]> > > > Sent: Saturday, November 29, 2003 11:11 AM > > > Subject: [Modus] SQL died and is now rebuilt but needing assistance. > > > > > > > > > > * This is the modus mailing list * > > > > > > > > Hello Lewis, > > > > > > > > We can go to the ODBC on the mail server and get a successful test > to > > > the > > > > database machine. BTW, we are using the IP address of the machine > and > > > not > > > > the machine name....I have read on the list before that this method > was > > > > preferred. > > > > > > > > Ken Grimes > > > > > > > > > > > > > > > > ----- Original Message ----- > > > > From: "Lewis Watson" <[EMAIL PROTECTED]> > > > > To: <[EMAIL PROTECTED]> > > > > Sent: Saturday, November 29, 2003 10:42 AM > > > > Subject: [Modus] SQL died and is now rebuilt but needing assistance. > > > > > > > > > > > > > * This is the modus mailing list * > > > > > > > > > > Hi Ken, > > > > > For starters I have a suggestion. Open the ODBC connection you use > to > > > > > connect to SQL from the mail server and try to test it. This will > at > > > least > > > > > tell you if the mail server can connect to SQL. Once we know this > we > > > can > > > > > go forward. > > > > > Good luck, > > > > > Lewis > > > > > > > > > > > > > > > > > > > > ----- Original Message ----- > > > > > From: "Ken Grimes" <[EMAIL PROTECTED]> > > > > > To: <[EMAIL PROTECTED]> > > > > > Sent: Saturday, November 29, 2003 10:22 AM > > > > > Subject: [Modus] SQL died and is now rebuilt but needing > assistance. > > > > > > > > > > > > > > > Hello Everyone, > > > > > > > > > > We had our SQL 2000 server die on us Thanksgiving day and we now > have > > > it > > > > > rebuilt however we have 100's of megs worth of error logs in the > M3 > > > log > > > > > folders ever few hours and I cannot figure out what we are doing > > > wrong. > > > > > We have had the SQL server running since version 1.4 so we have > > > forgotten > > > > > how to or what to do to make sure all of the items in Modus are > > > configured > > > > > correctly. We went to the Vircom site and there was a "How To" > > > describing > > > > > the SQL 2000 setup for 2.x but nothing regarding the M3 > specifically. > > > > > There was a script for the M3 quarantine which we used and we > followed > > > the > > > > > How To for the 2.x. We edited the existing ODBC "sa" password in > the > > > mail > > > > > machine because we couldn't verify what the old one was and > changed it > > > in > > > > > Modus and the SQL server also. We also cannot view the quarantine > as > > > it > > > > > gives us an error as well. Any help would be appreciated. BTW, > all > > > > > services have been stopped and restarted not just the modusscan > and > > > > > modusadmin services as stated in the Vircom "How To:". > > > > > > > > > > The Modus Server logs show: > > > > > Mail Store error [0xE00E03E9]: > > > > > State:S0002,Native:208,Origin:[Microsoft][ODBC SQL Server > Driver][SQL > > > > > Server]State:37000,Native:8180,Origin:[Microsoft][ODBC SQL Server > > > > > Driver][SQL Server]Invalid object name > 'tblMsgCatalog'.Statement(s) > > > could > > > > > not be prepared. > > > > > ---- MODUSADM log entry made at 11/29/2003 09:39:54 > > > > > > > > > > The WebMail Quarantine link provides this error: > > > > > An internal error occurred. Please try again later and contact > your > > > ISP if > > > > > the problem persists. Description : Code : &H800E03E9 > > > > > > > > > > Thanks in advance, > > > > > Ken Grimes > > > > > "Officially SQL Challenged?" > > > > > > > > > > > > > > > ** > > > > > To unsubscribe, send an Email to: [EMAIL PROTECTED] > > > > > with the word "UNSUBSCRIBE" in the body or subject line. > > > > > > > > > > > > ** > > > > To unsubscribe, send an Email to: [EMAIL PROTECTED] > > > > with the word "UNSUBSCRIBE" in the body or subject line. > > > > > > > > > ** > > > To unsubscribe, send an Email to: [EMAIL PROTECTED] > > > with the word "UNSUBSCRIBE" in the body or subject line. > > > > > > ** > > To unsubscribe, send an Email to: [EMAIL PROTECTED] > > with the word "UNSUBSCRIBE" in the body or subject line. > > > ** > To unsubscribe, send an Email to: [EMAIL PROTECTED] > with the word "UNSUBSCRIBE" in the body or subject line. ** To unsubscribe, send an Email to: [EMAIL PROTECTED] with the word "UNSUBSCRIBE" in the body or subject line.
