> 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/
