Are there any errors in the sysmmdd.txt log? Have you tried to do a SQL trace. This should get to the bottom of the problem.
-- Joseph Mann Wednesday, July 24, 2002, 5:02:37 AM, you wrote: NC> No luck with that, I even tried using sa for the odbc - still no NC> database connection. NC> I've now also tried deleting and recreating the hosts from NC> scratch, using a different odbc, and tried creating a new user. NC> After going out of Imail and back in the user is not there. NC> Looking in the database you can see that the Imail default table NC> was never created. NC> Anyone have any other ideas? I'm now considering reinstalling NC> Imail, but I'm not sure that it will help. NC> Thanks NC> Nick NC> ---------- Original Message ---------------------------------- NC> From: Don Schreiner <[EMAIL PROTECTED]> NC> Reply-To: [EMAIL PROTECTED] NC> Date: Tue, 23 Jul 2002 09:56:56 -0400 NC> Nick, NC> I am pretty sure you have to do the following: NC> Set SQL so you can view the system tables (I think by default SQL NC> is set NC> where the system tables are not displayed). You want to view the NC> system NC> user table (sysusers). Delete your IMail related DB "system user NC> account" from the specific IMAil related DB and then add the NC> account at NC> the server level. I think SQL incorrectly reads that the IMail NC> system NC> user account was attached to the old server. This worked for us NC> when we NC> experienced something similar. HTH. NC> Don Schreiner NC> CompBiz, Inc. NC> -----Original Message----- NC> From: [EMAIL PROTECTED] NC> [mailto:[EMAIL PROTECTED]] On Behalf Of Nick NC> Coyne NC> Sent: Tuesday, July 23, 2002 9:08 AM NC> To: [EMAIL PROTECTED] NC> Subject: [IMail Forum] external database connectivity problems NC> Hi. We're running IMail 7.07 on a win2k adv box using SQL 2000 for NC> the user database. Things were working just fine until our SQL NC> crashed and required a reinstall. After restoring the tables and NC> data, IMail just won't see the new database. I've deleted and NC> recreated the odbc connection, it works just fine. IMail however NC> sees no users on the external database. NC> Any suggestions guys? This happened to me once before on a fresh NC> installation and the only thing that fixed it that time was NC> reinstalling a few times - I still don't know what the problem was. NC> Thanks NC> Nick NC> Spur Corporation Limited NC> Phone: +27-21-4621293 NC> Fax: +27-21-4616857 NC> Cell: +27-83-3936999 NC> Please visit http://www.ipswitch.com/support/mailing-lists.html NC> to be removed from this list. NC> An Archive of this list is available at: NC> http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ NC> Please visit the Knowledge Base for answers to frequently asked NC> questions: http://www.ipswitch.com/support/IMail/ Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Please visit the Knowledge Base for answers to frequently asked questions: http://www.ipswitch.com/support/IMail/
