Norman, I thank you for a very informative 'how to' and by golly I think my youngs son could handle that. Me? well old dog.. hard headed I guess.. what i'm trying to do is to use the default settings within imail for an external database. I have selected to use the External User Database (does imail make this?) Then I've let imail put in the default DSN of IMAILSECDB and lastly its' default table name of [default] which i understand will make a table called something like mailme_com.
Here's my wall; how do i add a user to the table? via asp? if so i can't seem to access the DSN IMAILSECDB.. i've searched the hd and cannot find it anywhere. should i just make an access DSN and point to it? I am truely sorry if this sounds like a mess but to me i'm sure i'm overlooking something very basic. i've tried to use the 'add new user' function/button within the imail administrator but i believe that's only for imails user database. Any suggestion good/bad will be greatly appreciated. thanks in advance, rick Norman J. Nolasco wrote: > 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/ > > > > 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/
