Home » Adobe Manuals » Computer Software » Adobe 38028779 » Manual Viewer

Adobe 38028779 Getting Started Guide - Page 298

Creating a database connection, Access Driver.

UPC - 718659742201

Add to My Manuals
Save this manual to your list of manuals

Page 298 highlights

NOTE 2. Make sure the Microsoft Access Driver, version 4.0 or higher, is installed on the remote computer. 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. Install MDAC 2.5 before installing MDAC 2.7. 3. Set up a DSN called CafeTownsend pointing to the sample database on the remote computer. For instructions, see the following articles on the Microsoft website: ■ If the remote computer runs Windows 2000, see Article 300596 at http://support.microsoft.com/default.aspx?scid=kb;en-us;300596. ■ If the remote computer runs Windows XP, see Article 305599 at http://support.microsoft.com/default.aspx?scid=kb;en-us;305599. 4. Make sure the Sun JDBC-ODBC Bridge driver is installed on the remote computer. You will use this driver along with the DSN to create a connection to the database. For instructions, see "Installing the bridge driver" on page 296. After the database, DSN, and bridge driver are in place, create a database connection in Dreamweaver. Creating a database connection The final step of the setup process is to create a connection to the database. To create a database connection in Dreamweaver: 1. Open any JSP page in Dreamweaver, and then open the Databases panel (Window > Databases). 298 Setup for Sample JSP Site

Section	Page
Contents	3
Introduction to Dreamweaver	9
Introduction	11
What you can do with Dreamweaver 8	11
What's new in Dreamweaver 8	12
Installing Dreamweaver 8	13
Registering Dreamweaver 8	13
Typographical conventions	14
Learning Dreamweaver	15
Where to start	15
Web-design novices	15
Experienced web designers	16
Experienced hand-coders	18
Web application developers	18
Getting the most from the Dreamweaver documentation	19
Accessing the Dreamweaver documentation	20
Accessing additional online Dreamweaver resources	23
Using the Dreamweaver help system	24
Opening Help	24
Searching help	24
Using the index	25
Changing the font size	25
Using the Start Page	25
Printing the Dreamweaver Documentation	26
Discussing the Dreamweaver documentation with LiveDocs	26
Dreamweaver Basics	27
Getting to know the Dreamweaver 8 workspace	27
The workspace layout	28
The Document window	30
The Document toolbar	30
The status bar	32
The Insert bar	33
The Coding toolbar	35
The Property inspector	36
The Files panel	37
The CSS Styles panel	38
Customizing the Dreamweaver 8 workspace	39
Choosing the workspace layout (Windows only)	39
Displaying tabbed documents (Macintosh)	40
Hiding and displaying the Start page	41
Accomplishing basic tasks in Dreamweaver 8	42
About Dreamweaver files	42
Creating new files in Dreamweaver	43
Saving files in Dreamweaver	44
Opening files in Dreamweaver	45
Tutorials	47
Tutorial: Setting Up Your Site and Project Files	49
Learn about Dreamweaver sites	49
Set up your project files	50
Define a local folder	52
Tutorial: Creating a Table-based Page Layout	55
Examine the design comp	55
Create and save a new page	57
Insert tables	58
Set table properties	62
Insert an image placeholder	67
Add color to the page	69
Tutorial: Adding Content to Pages	73
Locate your files	73
Review your task	75
Insert images	76
Replace the image placeholder	76
Insert an image by using the Insert menu	78
Insert an image by dragging	79
Insert an image from the Assets panel	80
Insert and play a Flash file	83
Insert Flash Video	86
Insert text	89
Insert body text	90
Insert text for a navigation bar	92
Create links	94
Preview your page in a browser	96
Tutorial: Formatting Your Page with CSS	99
Locate your files	100
Review your task	101
Learn about CSS	102
Create a new style sheet	104
Attach a style sheet	106
Explore the CSS Styles panel	109
Create a new CSS rule	111
Apply a class style to text	113
Format the navigation bar text	114
Create a new rule for the navigation	115
Apply the rule	121
Add a rollover effect	123
(Optional) Center the contents of the page	125
Tutorial: Publishing Your Site	129
Learn about remote sites	129
Define a remote folder	130
Upload your local files	133
Troubleshoot the remote folder setup (optional)	134
Advanced Tutorials	137
Tutorial: Working with Code	139
Look at the code	140
Switch to the coding workspace (Windows only)	142
Add a tag with the Tag Chooser	142
Edit a tag	145
Look up information about a tag	147
Add an image with code hints	148
Check your changes	151
Print your code	152
Tutorial: Creating a CSS-based Page Layout	153
Learn about CSS-based page layout	153
Examine the design comp	154
Create and save a new page	156
Insert layers	157
Draw a new layer	157
Add more layers	159
Add layers inside a layer	165
Add color to the page	171
Tutorial: Displaying XML Data	173
Locate your files	174
Review your task	175
Learn about using XML and XSL with web pages	176
Learn about XSLT pages	178
Convert an HTML page to an XSLT page	179
Attach an XML data source to the XSLT page	180
Alter the XSLT page layout	181
Bind XML data to the XSLT page	183
Apply styles to the XML data	185
Create a dynamic link	186
Add a Repeat Region XSLT object	188
Attach the XSLT page to the XML page	191
Learn about other deployment options	194
Tutorial: Developing a Web Application	197
Before you begin	198
Review your task	198
Open a document to work in	200
Define a recordset	201
Display the database records	204
Add dynamic fields to the table	206
Set a repeated region	207
View your page	208
Create a record insert form	208
Add a Record Insertion Form application object	209
Create the insert form	211
Copy files to the server	214
Further reading	214
Appendices	215
Understanding Web Applications	217
About web applications	217
Common uses for web applications	218
Web application example	218
How a web application works	219
Processing static web pages	219
Processing dynamic pages	221
Accessing a database	222
Authoring dynamic pages	224
Choosing a server technology	226
Web application terminology	227
Installing a Web Server	231
Getting started	231
Installing Internet Information Server	232
Testing IIS	233
Testing the Macintosh web server (PHP developers)	233
Web server basics	234
Setup for Sample ColdFusion Site	237
Setup checklists for ColdFusion developers	237
Configuring your system (ColdFusion)	238
Installing ColdFusion MX 7	240
Creating a root folder	243
Defining a Dreamweaver site (ColdFusion)	244
Copying the sample files	245
Defining a local folder	246
Defining a remote folder	247
Specifying where to process dynamic pages	248
Uploading the sample files	249
Connecting to the sample database (ColdFusion)	250
Setting up the database (server on a remote computer)	250
Connecting to the database	251
Setup for Sample ASP.NET Site	255
Setup checklists for ASP.NET developers	255
Configuring your system (ASP.NET)	256
Checking for a web server	258
Installing the .NET Framework	258
Creating a root folder	259
Defining a Dreamweaver site (ASP.NET)	260
Copying the sample files	261
Defining a local folder	262
Defining a remote folder	262
Specifying where dynamic pages can be processed	263
Uploading the sample files	264
Connecting to the sample database (ASP.NET)	265
Setting up the database (server on remote computer)	265
Creating a database connection	266
Setup for Sample ASP Site	269
Setup checklists for ASP developers	269
Configuring your system (ASP)	270
Checking for a web server	272
Installing an ASP application server	272
Testing the installation	273
Creating a root folder	274
Defining a Dreamweaver site (ASP)	275
Copying the sample files	276
Defining a local folder	277
Defining a remote folder	277
Specifying where dynamic pages can be processed	278
Uploading the sample files	279
Connecting to the sample database (ASP)	280
Setting up the database (server on remote computer)	280
Creating a database connection	282
Setup for Sample JSP Site	285
Setup checklists for JSP developers	285
Configuring your system (JSP)	286
Checking for a web server	288
Installing a JSP application server	288
Creating a root folder	289
Defining a Dreamweaver site (JSP)	290
Copying the sample files	291
Defining a local folder	292
Defining a remote folder	292
Specifying where dynamic pages can be processed	293
Uploading the sample files	294
Connecting to the sample database (JSP)	295
Installing the bridge driver	296
Setting up the database (server on remote computer)	297
Creating a database connection	298
Setup for Sample PHP Site	301
Setup checklists for PHP developers	302
Configuring your system (PHP)	302
Configuring your Windows system (PHP)	303
Checking for a web server (Windows)	304
Installing a PHP application server (Windows)	304
Testing the PHP installation (Windows)	306
Creating a root folder (Windows)	308
Configuring your Macintosh system (PHP)	309
Testing the PHP installation (Macintosh)	309
Creating a root folder (Macintosh)	310
Defining a Dreamweaver site (PHP)	311
Copying the sample files	311
Defining a local folder	312
Defining a remote folder	313
Specifying where dynamic pages can be processed (PHP)	313
Uploading the sample files	315
Connecting to the sample database (PHP)	315
Creating the MySQL database	316
Creating a database connection	318