Connect Access / OOBase to MySQL Using ODBC Part 1 of 2

This video demonstrates how to install and configure the MySQL ODBC driver on a Windows-based PC and then use it to connect either Microsoft Access or Open Office Base to a MySQL database. Part 1 of 2.

---

Closed Caption:

hello and welcome in the short screen
movie im gonna show you how to connect
to a my sequel database from access
using ODBC
or the open database connectivity API
the first thing you need to do is
install the ODBC driver
you can get that from the mice equal
website you can see the address appear
that said http:// death slash my sequel
dot
com slash downloads slash connector
and the connector you're looking for for
this example
is the ODBC connector as you can see
there are other different kinds of
connectors for JDBC different kinds of
platforms and so on
we'll take a look at the ODBC connector
and the one that you want to download
their to have not currently available
3.51 as the standard production and
version and 5.0 is a new one
beta version and you can install either
one depending on your system 5.0 is only
available for Windows as you can see the
3.51
downloads available for other platforms
I'm not gonna show you this download
have installed it on my computer already
for Windows it's really a simple matter
at that picking the Windows Installer
clicking the download button then it's
an automatic install sure that part in
the goods for smuggling
if you have mcintosh you're trying to
install it on lanix
you're gonna check for the
specifications for your system to
install those files
once you've installed the ODBC connector
you need to set up a DSN and I'll show
you what that is
and to do that you need to go to control
panel in from control panel select
Administrative Tools
and then from administrative tools slot
data sources the DSN as a data source
name
not open this up you can take a look
done data source name is just a
collection of information about the
datasource
including the name of that the IP
address from work or host and name
kind you know how you want to lock in
San in some other things will walk
through that
in Windows you can select the user DSN
Dennis only available to the particular
user on the current machine
you are you can select a system DSN this
is available to anybody on the machine
my understanding is that macintosh issue
meter
and install a system DSN and
for here for the Windows platform on
strong user DSN
and it's simply a matter of looking at
here
under user DSN and
note that once installed the driver and
it'll add it to this list I've
drivers that I can you send for the San
new datasource on selecting my sequel
ODBC 3.51 driver and click Finish
in now as you can see is asking for some
information
and so will go through this and
any usually just need to fill in this
for screen so the data source name is
some kind of name that you might define
snowing in a plain and simple
ODBC just for a name
and this will be them
example and the server is the name of
the server could be an IP address could
be a domain name you need two hands
am my sequel database setup here sign
any use this
and which I just setup is assertive a
dummy named
where I do have a am my sequel database
setup
the user and
you know typically you log in as a user
root in
one thing I should mention here instead
and this is a sometimes assertion error
lack of connectivity
if if the and my sequel databases in on
the same machine that you're working on
this if it's located in a different
machine
on website somewhere you have to have
access privileges for the user from
remote data systems turn you know by
default and
the my sequel and when you add a user
only permits you to log in locally
soon that can be a source of confusion
that something you need to take European
my sequel itself password and
of course and then the database if we're
lucky it's going to
actually connect to the database and we
see it did I'm gonna happen and
a database hearing any use for example
called images in now we're all set to go
so we can click can
okay here if you're having some problems
there is a diagnostic test but
since it opened the database and found
that image in San
database within my sequel were okay
star click OK in we're basically done
now it's a matter for opening up the
application you want that
and can use ODBC so I'm first gonna
demonstrate this with access
you now open up Microsoft Access here
and what I'm gonna do this I'm going to
create a new
a new database plant database and
compensation
ODBC test am will create the database
now in order to link to the mice equal
database
and images database they created a DSN
for
I'm gonna go to File and then I'm in a
good
external data and one wanna do is link
tables
wanna lick tables it'll bring up and
a dialog box that will allow you to
learn
selected data source I am going to go
down here
under the files of typing if you go all
the way down to the bottom you'll see
that you can open up a DBC databases
so I'm gonna select that and then I'm
gonna go over to machine data sources
and you'll see that the one that I
created here the sample
ODBC is available for me to select
so all they need to do is select an I'm
going to select
all the tables that are within that
database and click OK
and now you can see that with in Access
iPad at the tables from the mice equal
database and we can open things up
I in see that in fact and we do have
access to our data
now there's some limitations of what you
can do here you can damn
you can't do and some in some
database operations and you know
creating new tables things like that you
actually need to go back to the bicycle
database India but you can
insert done new values you can update
values you can run reports
and I can do all kinds of other things
and with one tablespoon let me close
down and show you what you can do in
terms of acquiring
that's why we'll go to query here in
will create a query in design view
you know and each of these tables but
and and you'll notice that done access
takes its best guess at
relating peace and relating these by ID
code and
with the key fields and the primary keys
in the foreign keys and he should take a
look at these if perhaps in
it's made a mistake or you need to do
something different you can't
and we can open the sampling so let's
create a simple report let's take the
M image title
and the collection title and the
photographer first name
in the photographer last name and so
we've added the sand
fields to a report we can take a look
and see what that looks like
this is all the information from our
database now
ok in so I think you can see and
that damn we head back to the the the
capability for manipulating your data
reporting on our data
thats into my sequel database from
access we can also take a look at
and the sequel view and show you the
actual sequel
statement but that access created
from our query by example database and
what but we just didn't reporters with
instruments query by example
disagree graphical gooey way to put
together reports
and it usually does a pretty good some
pretty good job sometimes
you know more complex reports and now
will learn you know still need some
manual tinkering here in the
in the query window let's go back to
design view
in just to show you some other things
you can do and
we can do and sorting and obviously we
could put in water and photographer last
name despite dropping this down
we could also put criteria in here done
that she like
them
like star life life star that's gonna
get done
records that done where the image titled
and has the the word life in it
somewhere
and note that with access the well
character asterisk with my sequel you
may recall the
wild-card surname per cent symbol so
there are some
incompatibilities and the indium
sequel that's produced but if we go
ahead and take a look at that
and then we see that we just have them
the two images that are included
stuck a scarf you now once again we can
go take a look at the sequel that
created this
are sequel view man and you can see that
it's am done the
done the inner joins on the on that on
the tables
in the order by and and adaware close
soon
this is all pretty straightforward I'm
not gonna demonstrate anymore
on this if you know access then now you
can use that
and this is how you connect to it