How to Configure ODBC to Access a Microsoft SQL Server

This video tutorial covers how to configure ODBC to access a Microsoft SQL Server database. More guides and tutorials: http://www.itgeared.com/.

---

Closed Caption:

ok so we're going to cover how to
configure odbc to connect way back in
Microsoft sequel server
okay for this example all I have to
shortcut icons on the desktop and one is
the microsoft access 2010 icon and the
other is the data sources odbc icon
i'm going to be using microsoft access
to access the data once the odbc
connection is made the first step is to
go ahead and launch the data sources
control panel applet and i'm from this
source administrator window
you basically have multiple tabs the two
most at the two most common tabs you'll
be using is either the user DSN or the
system DSN both of these tabs can be
used to connect to a back-end system
the difference is that the user DSN tab
will expose these data sources to the
currently logged on user versus the
system DSN where if you create any here
they'll be available to any user that's
logged onto this computer for this
example go ahead and create a user DSN
and our goals by starting by clicking
the Add button and we want to connect to
a sequel server so i'll select that
okay we got to give this connection name
i'll just call it on
itg sequel test you can give it a
description if you like
and need to specify the sequel server
name
click Next ok so you can connect to the
sequel server by either using your
current logon credentials which is the
first option here using windows and the
authentication or you can specify
username and password to connect to the
backend sequel server already have a
user account and password to find on
sequel so go ahead and choose that
option and i'll type in my credentials
here
click Next
i'm going to go ahead and change the
default database rather than connected
to master all connect to a test database
that i've already created
no other options need to be changed how
click Next and on the screen
unless you want to save a queries and
statistics to a log file on going to
just click on finish
if you like you can review your arm
configuration and test data source by
clicking on this button you'll notice
that are the tests completed
successfully which means that i was able
to make a successful connection to the
sequel server pickle clay
you'll notice that our connection is now
listed as a user data source and hit OK
to finish
ok so we're going to go ahead and launch
microsoft access 2010 so we can access
our data on the sequel server and we're
going to create a blank database
now i'm not going to store any data in
this local access fossil going to close
this table and we need to go ahead and
get to our external data so will click
on the external data tab and since this
is an old BBC connection will launch
that wizard
I want to announce the wizard we have
two options either we can import the
data into a table into this access
database or just go ahead and link to
the data source in the back end without
storing local data that's what i'm going
to choose it ok ok go ahead and select
your data source
we're going to go onto the machine data
source tab and i'm going to select the
data source that i just created in the
previous steps click OK
typing your credentials
click OK ok once i make the connection
sequel server will provide me with a
list of all the objects at this user has
access to in this case I have a lot of
objects presented to me because this
test user was created with vast amounts
of rights and privileges but for this is
for this example I'll go ahead and just
linked to the customers table and click
OK and you'll notice that once i connect
it shows an external linked table called
do consumers and if I double-click that
I have access to the table in the back
end server
now depending on the rights that this
user has you can either just select data
from the table you can insert new data
you can delete data or you can just
update existing data for instance i want
to add a record to this database i can
also go ahead and add some data
system test information here
so it's using a particular aside from
being able to insert data can also
delete data so i can right click for
instance a roll and delete record
so again on this data is actually the
changes to the data are actually be made
on the sequel server itself on none of
the state is being stored in his local
access database file
i'm just using access to interface with
a sequel
that's it for this demonstration of
configuring odbc the connect to a sequel
server
thank you for watching