Now, in most cases unless you are a database guru, Microsoft Access works just fine. So in your first dialog window make sure that
Microsoft Access Driver is selected and press
Finish.
Then the last dialog window will come up. Here next to
Data Source Name, is where you type in the connection name you want to give your database. This can be anything you want, but make sure it’s simple, short and descriptive. You aren’t allowed spaces but you CAN use underscores _.
The data source name is VERY important, as this is how you will call up the connection with UltraDev. So make sure it’s easy to remember.
Now you have selected a name, well you need to point that name to the database you will be using. So under the area
Database, press the
Select… button and browse to your database (wherever that may be). Now you have a connection name pointing to a database.
- An important tip to remember is that you need to keep your database in the same place. If you move it around without re-pointing your connection then it won’t be able to find it.
- When you go to host your website with a company, make sure you FTP your database up to your website. Then call the hosting company and tell them you have a database in this folder and you need an ODBC connection created to it named (whatever you called it on your computer)
.
