Creating a local DSN
This tutorial shows you how to set up a LOCAL Data Source
Name, or DSN. Any DSN that is used on your 'live' web application
on your webserver will normally be set up by your hosting company.
They may charge a fee for doing this, so you may want to look at
our 'DSN-less connection strings' tutorial.
1. To create a local Data Source Name, click on Start>Settings>Control
Panel. (On Windows 2000 this will be Start>Settings>Control
Panel>Administrative tools>Data Sources)
Now open ODBC Data Sources
2. You should see this box:
Click on the 'System DSN'
tab, you should now see the following:
You will see any previously created DSN's in the window.
Click on the 'Add'
button, and you will see this box:
You now need to select the driver depending on which database you
are using. We'll be using MS Access. So, click on the driver type
and then click on the 'Finish'
You should now see the following:
You need to name your DSN (in our example replace DSN_Name
with your data source name), make it something relevant to your
database/web site. You will need to know the DSN later, when you
set up your connection in UltraDev.
Then click the 'Select'
button and you will see the following:
Now you simple browse to your local database file and click on
the 'OK' button. Now, when you open up Connections
in UltraDev, you should see your new (local) DSN in the list.