replying to my own message.... Changing the column to a BLOB fixed it up - the backslashes were being treated as special delimiters, but calling it binary instead of text fixed it up.
Another question if someone can help: I can now create and delete users by adding them to the sql database; what happens to spool files when a user is deleted in sql? ----- Original Message ----- From: "David Morton" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 02, 2001 11:43 AM Subject: [IMail Forum] external database - Mysql > I'm trying to set up an external database to a MySQL system, using ODBC. > The ODBC drivers are installed correctly, and the imail system even created > the table fo me, so I know the permissions are ok. However, both SMTP and > POP deny that the user account exists. > Has anyone done this before? > > I'm suspecting there are some binary issues here; the userdir field loks > messy: > > mysql> select UserDir from 1_correct_connect_com; > +---------------------------------------+ > | UserDir | > +---------------------------------------+ > oot |Mail1_correct-connect_comusers > | d:IMail1_correct-connect_comUsersdgm | > +---------------------------------------+ > 2 rows in set (0.00 sec) > > > This is a 6.06 Imail system, on Win2k. > > Thanks for any help.... > - > David Morton > Osprey Network Technologies, Inc. > > > 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 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/
