* 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.
