I'm currently using both the IMail Database and the External Database
(with MS SQL 2K) with no problems. There are a couple things that
we need to check. I don't know if these will work for you, but these
are my settings:
1) Make sure you have a database setup. It doesn't matter if you have
tables in it or not. Just try not to have any tables called "tblUser"
or similar. I don't know what that will do. I'm using MS SQL2K Enterprise.
Also make sure you have a user that has permissions to create tables.
Once those tables are created, they should already have permissions to
insert, update, select, and delete rows from the tables.
2) For your ODBC DSN:
- In your Data Sources, you should be using a "System DSN"
- For this example, we'll use: dsn_name
- For a MS SQL config, click "Next", NOT "Finish".
- Use SQL Authentication (not sure if you can use NT Auth)
- Under "Client Configuration", I use TCP/IP with the rest as default.
- I have "Connect to SQL Server to obtain..." checked
- You should fill in LoginID and Password with a user that has
access to create tables in your database. Click Next.
- I have "Change default database to" checked with my database
from Step 1 selected. The rest of the settings are default. Click Next.
- Use defaults and click Finish.
- Click "Test Data Source" to make sure you've got all the settings right.
- Remember that if you go back into the DSN using the "Configure" button
you might have to confirm that all your settings stayed the same. MS Win2K
blanks out some of your settings when you go back in.
3) When you click Configure for External DB, what do you have for:
- External Database Implementation DLL
- use the default
- ODBC System Data Source name
- should be in this format for SQL2K:
dsn_name;uid=username;pwd=password;
- Table Name
- Whatever you want. Does not have to point to an
existing table. I named by user table tblUser_1. The number is
so I can use the same database for multiple domains if I have to.
4) Try adding a user. Then, check the database. You should have both a new
table with the user added.
Don't know if this helps, but it works for me. Here's a couple of KB things
to check if you're still having problems.
http://support.ipswitch.com/kb/IM-20000726-DM01.htm
http://support.ipswitch.com/kb/IM-20001219-DM02.htm
-Norm
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Discussion
Groups
Sent: Friday, April 12, 2002 4:25 PM
To: [EMAIL PROTECTED]
Subject: RE: [IMail Forum] External Database
We're trying to do the same thing. Have the DSN setup but cant seem to
get it to input the records
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Rick Leske
Sent: Friday, April 12, 2002 12:42 PM
To: [EMAIL PROTECTED]
Subject: [IMail Forum] External Database
I need help... and greatly appreciate the info. I am using imail and
trying to setup email to use its' default external database. My
question is what are the table names that i need to setup/make with
access? i've researched the kb & manual and can't seem to locate the
right info. is there any place that i could download a blank/sample
user database?
thanks so much,
Rick
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 the Knowledge Base for answers to frequently asked
questions: http://www.ipswitch.com/support/IMail/
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 the Knowledge Base for answers to frequently asked
questions: http://www.ipswitch.com/support/IMail/
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 the Knowledge Base for answers to frequently asked
questions: http://www.ipswitch.com/support/IMail/
