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/
