Thanks for the reply...I got it all working with the triggers...I'm an idiot...forgot to grant permissions to my IMail SQL login to the other database. :)
Haven't looked at altering the DLL yet...Any suggestions or samples? - Andy -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sanford Whiteman Sent: Thursday, July 31, 2003 3:53 PM To: Andy Ognenoff Subject: Re: [IMail Forum] External Data Source with triggers(failing) > I have IMail 8 running on an external data source (SQL Server 2000) > and I want to put a few triggers on the table to synchronize a > couple fields in the IMail table with another database. I have all > of the triggers working exactly as they need to when doing an > insert/update/delete from within SQL Server (directly changing the > data) but when doing anything from IMail Administrator it fails out > when creating/editing/deleting accounts (because I do a roll back of > the transaction if there were errors) but I don't know why its > failing out. You need to find out the last SQL DML was that was issued by IMail and issue it interactively to see the error. And without knowing what your trigger does, we have no way of knowing what constraint was violated. There's no essential incompatibility between triggers on the back end and IMail on the front. > On another note.when using an external data source does anyone have > a good way of encrypting the passwords so they aren't stored in > plain text in the database or would IMail not be able to handle > decrypting it? You can make a very slight change to the ODBCUSER.DLL code to accomplish this. -Sandy ------------------------------------ Sanford Whiteman, Chief Technologist Broadleaf Systems, a division of Cypress Integrated Systems, Inc. e-mail: [EMAIL PROTECTED] ------------------------------------ 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/
