|
| |
Accessing your mySQL database with MS Access
Once you have your website configured to use mysql, you may need to make updated
to your database. This can be done using Telnet and the mysql client from
the unix command line, but you can also open your database directly with
Microsoft Access.
- First you must download the current version of myODBC from the mySQL
page. You do not need the source code, just the full setup for your
version of windows. We recommend the 3.5.x version
- Next you must install myODBC. Unpack the file you just downloaded and
run the enclosed Setup (make sure to close any other applications before
running setup).
- Next you need to create the DSN (Data Source Name). In Windows XP
from START -> COntrol Panel -> Administrative Tools -> Data Source (ODB).
A new window will pop up with what is presently defined.
Select
"add", and on the next window scroll down and select the
version of "MySQL" you downloaded.,
click "OK".
You will then see a large window with fields you must complete. Use
the following info:
| Windows DSN Name |
: |
a name to reference this connection by |
| Server |
: |
db2.thebook.com |
| User |
: |
DB username provided by TheBook when mySQL was set up (Example DB Username: example) |
| Password |
: |
DB password provided by TheBook when mySQL was set up (Example DB Password: example |
| Database |
: |
DB Name provided by TheBook when mySQL was set up (Example database: example) |
You should be able to press the "TEST" button and confirm a connection.
YOu can then say OKAY and exit.
- Start Access or any other application that will use ODBC.
- Cancel the open dialog that initially pops up.
- Click File -> OPen to open your
mysql Database.
- In the Open window, near the bottom, select
"ODBC()" from the list of file types -- a new
window will be displayed.
- You should see two listings -- "File Data
Source" and "Machine Data Source." Go
to the "Machine Data Source" listing.
- You should see the name of the Data Source you created,
select it for opening -- you should then see a list of
tables!
- Use any access commands...
Please see the MS Access documentation for information on generating an Access
query against the database. |
