1. Install the MYSQL connector/ODBC (http://www.mysql.com/downloads/api-myodbc-3.51.html) 2. Configure it 3. Download the iMail odbc dll that works with MYSQL (http://wwwg2.dpzone.com/products/software/imail/odbcuser/) 4. Create the host or if you have existing then point tell it to use external data base, change the path to the new dll and then use the ODBC data source name that you created before and enter the table name, it will do the rest for you if all the info is correct.
Ps in mysql the data base should have been created already. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of GPF Sent: Sunday, October 05, 2003 4:18 AM To: [EMAIL PROTECTED] Subject: Re: [IMail Forum] External Database with mySQL I haven't done mySQL but with SQL the ODBC will build the table for you. You just need to create the database. Gary ----- Original Message ----- From: "Richard Bewley" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, October 04, 2003 12:15 PM Subject: [IMail Forum] External Database with mySQL > Hi, > > I'm trying to get IMail working off an external mySQL database. It has the > following structure: > > CREATE TABLE imail ( > USERID varchar(31) NOT NULL default '', > PASSWORD varchar(31) NOT NULL default '', > FULLNAME varchar(63) default NULL, > USERDIR varchar(255) default NULL, > MAILADDR varchar(255) default NULL, > MAXSIZE int(11) default NULL, > MAXMSGS int(11) default NULL, > FLAGS int(11) default NULL, > TYPE int(11) default NULL, > NUMTRIES int(11) default NULL, > ATTEMPTTIME int(11) default NULL, > NUMTIMESSUSP int(11) default NULL, > LASTLOGIN int(11) default NULL, > SPNDUSRACCT int(11) default NULL, > ICALENBL int(11) default NULL, > SPELLENBL int(11) default NULL, > NUMSGSTNS int(11) default NULL, > IWDEPTH int(11) default NULL, > IWOPTIONS int(11) default NULL, > SPELLCHKG int(11) default NULL, > PRVWSIZE int(11) default NULL, > DEFVIEW varchar(40) default NULL, > TIMEZONE varchar(255) default NULL, > STRTDAY int(11) default NULL, > DEFCALNM varchar(40) default NULL, > ENTRYGRNL int(11) default NULL, > STARTTIME int(11) default NULL, > ENDTIME int(11) default NULL, > MAXEVNTDISP int(11) default NULL, > MAXTSKDISP int(11) default NULL, > MAXNOTEDISP int(11) default NULL, > MAXDLYRCURCNT int(11) default NULL, > MAXWKLYRCURCNT int(11) default NULL, > MAXMONRCURCNT int(11) default NULL, > MAXYRLYRCURCNT int(11) default NULL, > DISPCMPLTDTSKS int(11) default NULL, > HOURSCLOCK int(11) default NULL, > MAXSRCHRESPPG int(11) default NULL, > MAXEVENTTITLELEN int(11) default NULL, > MAXTASKTITLELEN int(11) default NULL, > CONFIRMONDELETE int(11) default NULL, > NUMNOTIFY int(11) default '0', > LASTNOTIFY int(11) default '0', > FTPMAXSPACE int(11) default NULL, > FTPMAXFILES int(11) default NULL, > FTPFLAGS int(11) default '11', > PRIMARY KEY (USERID) > ) TYPE=MyISAM; > > Also, I have gotten the DP-M710-odbcuser.dll file, but I am unsure where to > put the hostname of the mySQL server. Is it supposed to go somewhere in > this line? > > mysql; UID=username; PWD=password > > Also, what should I have where I had "mysql"? I believe this is supposed > to be the DSN name, if I were using SQL Server. > > Any direction you could give me would be greatly appreciated. > > Thanks, > Richard > > > --- > [This E-mail scanned for viruses by friend.ly.net.] > > > 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/ 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/
