Someone just published one, more or less, a few days ago. I archived it in
case I ever wanted to use it myself. It is included at bottom. Once you get
mySQL server set up you might be able to just point to a blank datasource.
To my knowledge the only generic walkthrus are those found in the mySQL
docs, which aren't much on hand-holding. Here's the procedure in a
nutshell:
1. download the mySQL full install
2. Download the myODBC drivers
3. Extract the ZIP file from 1. above and run setup.exe
4. You now have a bunch of files in c:\mysql and below, assuming you used
the defaults. Go here and read this:
file:///C:/mysql/Docs/manual.html#Windows_installation
If you hate reading manuals, chances are all you'll need it to do is key in
C:\mysql\bin\mysqld-nt --install
in a command window to install mysql as an automatic service on your NT/2k
system.
5. Install the myODBC drivers. Pretty straightforward stuff. Just make
sure you grab the full install and run the thing.
6. Next you'll need a GUI front-end manager. While there's no substitute
for knowing SQL and building your own queries to do stuff as needed, a GUI
makes life easier. I'm not fond of the mySQL-supplied version. mySQLFront
is the best out there, available at http://mysqlfront.de. Works great for
both local and remote administration.
7. Set up your datasources. You'll almost certainly have to do this using
the ODBC tool in Control Panel. Its simple enough to do. I keep a shortcut
to this on my desktop as I'm in and out of it all the time, along with
mySQLFront.
''Learn SQL in 10 Minutes'' by Ben Forta is not meant to be an in-depth
reference, or something to teach fundamentals in depth. Just a handy pocket
ref I refer to every once in a while. Once you get good at the language Joe
Celko's ''SQL for Smarties'' is a very good bet, but be warned: the guy
isn't kidding. This is an advanced text. Not sure of a good middle-ground
text as these are the only two I have.
Good luck, and post back if you get the user db ported over.
-----------------------------------------
Matt Robertson [EMAIL PROTECTED]
MSB Designs, Inc. http://mysecretbase.com
-----------------------------------------
-----Oprindelig meddelelse-----
Fra: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]P� vegne af Randy Leiker
Sendt: 30. august 2001 17:43
Til: [EMAIL PROTECTED]
Emne: Re: [IMail Forum] External DB!
Thomas - I seem to remember that when we first started using an Access db,
we found the information about the needed Access fields within a release
notes document which was located within the Imail directory after it was
installed. You might try checking that source & see if you can locate it.
If you don't want to deal with manually setting up the db, you should be
able to have Imail automatically create the database tables you need.
First, create a blank Access db and store it somewhere on your Imail server.
Next, point an ODBC datasource to the new Access db that you just created.
Third, open the Imail admin application, select a mail server, tell it to
use ODBC for storing it's user information (see the Imail user manual for
this process), and tell it the ODBC datasource name you're using as well as
the name of the db table you'd like to create. Imail should then
automatically create that table with all the needed fields.
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/
