Joseph is correct here - and doing a SQL trace will shed some light. Are you able to set-up your ODBC at all or is this occurring when the ODBC connection is made and then IMail is not recognizing Username and Password on the DB? (this is what I was referencing in my suggestion previous). If a dedicated M$ SQL DB machine, then are you running ISA or any firewall stuff that will prevent user account privileges from one machine to the next? Also, check user account and re-set if you have an "instance" of SQL installed vs. just SQL as we also experienced similar problems on client machines who have done this. I know it is frustrating as can be, to the point I would rather use the IMail DB which I understands performs very nicely. But because of other integrated apps we cannot really go that route. Good luck and let us know what the problem was when discovered.
-Don S. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Joseph Mann Sent: Wednesday, July 24, 2002 9:22 AM To: [EMAIL PROTECTED] Subject: Re: [IMail Forum] external database connectivity problems 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/ ---------- [This e-mail scanned by CompBiz for Viruses. http://www.CompBiz.Net] 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/
