This section applies only if your web server is running on a remote computer. If your web server is running on the same computer as Dreamweaver, skip to Creating a database connection.
Before attempting to connect to the sample database, perform the following tasks on the remote computer running your web server: copy the sample database to the computers hard disk and create a DSN on the computer that points to the database.
You can place the file in any folder on the remote computer, or you can create a new folder for it.
NOTE |
|
There are potential security issues if you place the database file inside the Inetpub folder on the remote computer. Its better to place the file in a folder thats not publicly accessible. |
To find out whether the driver is already installed, see Viewing the ODBC drivers installed on a Windows system in Using Dreamweaver.
If the driver is not installed, download and install the Microsoft Data Access Components (MDAC) 2.5 and 2.7 packages on the remote computer. You can download MDAC for free from the Microsoft website at http://msdn.microsoft.com/data/mdac/downloads/. These packages contain the latest Microsoft drivers, including the Microsoft Access Driver.
NOTE |
|
Install MDAC 2.5 before installing MDAC 2.7. |
For instructions, see the following articles on the Microsoft website:
After the database, database driver, and DSN are in place, create a database connection in Dreamweaver. (See Creating a database connection.)