Alright. After reading the 2006 release notes, it sounds like there are no new columns added to the database between 8.05 and 9.04. It seems as if the primary reason for my troubles is that I did not make the permissions changes outlined here:
http://support.ipswitch.com/kb/IM-20051206-DM07.htm Is it really necessary to do all of this to make external databases work? If I don't have a domain in place between my Imail and SQL server can I get by with duplicate usernames and passwords on both systems? Has anybody tried this in a non-domain environment? Josh -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tripp Allen Sent: Wednesday, August 02, 2006 6:56 AM To: [email protected] Subject: Re: [IMail Forum] external databases and odbcuser You can also run the dbupdate utility to add the columns. Tripp ----- Original Message ----- From: "Sanford Whiteman" <[EMAIL PROTECTED]> To: "Josh Adams" <[email protected]> Sent: Tuesday, August 01, 2006 11:38 PM Subject: Re: [IMail Forum] external databases and odbcuser >> Are there any possible complications I can run in to by connecting >> to the external database using the old odbcuser file? > > There certainly are columns that were added since 8.05, and returning > a totally different struct to IMail (that doesn't contain those > values, since the ODBCUSER.DLL doesn't know they exist) sounds very > dangerous to me. > > I believe the SQL to add the new columns exists in an ODBCUSER.TXT or > similarly-named file (sorry, not near an IMail box right now). > > --Sandy > > > ------------------------------------ > Sanford Whiteman, Chief Technologist > Broadleaf Systems, a division of > Cypress Integrated Systems, Inc. > e-mail: [EMAIL PROTECTED] > > SpamAssassin plugs into Declude! > > http://www.imprimia.com/products/software/freeutils/SPAMC32/download/rel ease/ > > Defuse Dictionary Attacks: Turn Exchange or IMail mailboxes into IMail > Aliases! > > http://www.imprimia.com/products/software/freeutils/exchange2aliases/dow nload/release/ > > http://www.imprimia.com/products/software/freeutils/ldap2aliases/downloa d/release/ > > To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html > List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ > Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/ > To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/ To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/
