Setting Up The ODBC Connection
I previously mentioned Leo West and its from this page that I found out how to
create an ODBC link. To create an ODBC link, open up Control Panel and
from within control panel, open up ODBC. The icon for this looks like this:
create an ODBC link. To create an ODBC link, open up Control Panel and
from within control panel, open up ODBC. The icon for this looks like this:
When you open this up, you end up with a screen like this:
Select the System DSN tab. If you havent done any work with user defined DSN’s,
this should be empty. Select the Add button. You will get a screen which looks
like this:
this should be empty. Select the Add button. You will get a screen which looks
like this:
Select the Microsoft Access driver. Click on the finish button. You will
now see this screen:
now see this screen:
In the Data Source Name text field, enter a name which you wont forget, as this
will be the way you will call your database. For the purposes of this tute, enter
‘WebTute’. The description text field is for your purposes as you may want to
manage your DSN connections later.
will be the way you will call your database. For the purposes of this tute, enter
‘WebTute’. The description text field is for your purposes as you may want to
manage your DSN connections later.
Finally, select the Select button. From this menu, choose the Access
database you initially created.
database you initially created.
And that’s it! your ODBC connction is done! Now to interface with it.
