Is the Web Messaging service running as a user who has rights to access the
database (like POP3 and SMTP and IMAP should, too)? If not, that could keep
it from writing changes to the DB.
Daniel Donnelly
________________________________________________________
----- Original Message -----
From: "Charlie Strause" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 18, 2001 2:37 PM
Subject: [IMail Forum] ODBC user database connection problem using a View in
MS SQL
> I'm having IMail use the ODBC connection to an external user database
table
> in MS SQL.
>
> In the past, we did a project where we used this feature, but instead of
> using a real table in SQL, we defined a View. This also worked on the
> project I'm working on now. Users can log in fine.
>
> However, if you try to save preferences via the web messaging interface,
the
> value does not get stored in the TYPE field as I expected.
>
> If I use a real table instead of a view, it saves the value OK.
>
> The view has select and update permissions set. I can set the column
using
> my own software via ODBC and it gets written all the way through to the
> column that the view is based on. Its just that IMail can't set it.
>
> Has anyone out there gotten this to work, how ?
>
> Thanks.
>
> 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/
