Just FYI - ODBC is a real pain to configure if the database is not on the same machine, getting the permissions right is almost impossible... I had a couple machines I never could make the connection on. Try moving the database to the machine you are setting up ODBC on and get it working there, then move it and work out the permissions afterward.
> 2. configured the external database. (created ODBC DSN which points to a > table called USER located in server X) > 3. USER table has the fields, UserID, Password, Fullname, UserDir and > Flags. > > Assuming the above is correct, I should be able to add a user via iMail > Admin and be able to see a record being added > into the table USER right? (that didnt happen... *sob*) > > I would be extremely grateful if anyone can help me out here... where have I > gone wrong? Thanks > > > Btw, I am unsure about one thing written in iMail's User Guide which says: > " For users using SQL 7.0 or above: In the ODBC Data Source Name input the > line: DNS_NAME;UID=username; PWD=password." > http://www.ipswitch.com/support/IMail/guide/imailug801/Chapter%202%20config1 > 2.html#16649 > > I didnt carry out the step above. Is it critical? > > > SY Lim. > > > 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/
