Thank you very much. I missed that External DB posting in my search. Your
notes should help tremendously. I promise that once I get it up and
running, I'll actually learn what I'm doing. :)
>From: "Matt Robertson" <[EMAIL PROTECTED]>
>Subject: Re: [IMail Forum] OT: SQL
>Date: Sun, 2 Sep 2001 20:40:47 -0700
>Reply-To: [EMAIL PROTECTED]
>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.
>
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
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/
