Macromedia dreamweaver 8-using dreamweaver Manual De Usuario

Understanding database connections

993

Drivers are written by database vendors such as Microsoft and Oracle, and by a variety of 
third-party software vendors. Microsoft offers a number of ODBC drivers and OLE DB 
providers for the most popular database packages, such as Microsoft Access, Microsoft SQL 
Server, and Oracle. The ODBC drivers, which only run on the Windows platform, are 
automatically installed with Microsoft Office, and with Windows 2000 and Windows XP 
Professional. They are also installed with the Microsoft Data Access Components (MDAC) 
2.5, 2.6, and 2.7 packages, which you can download for free from the Microsoft website at 

. MDAC 2.7 installs a number of OLE 

DB providers. 

To find out which ODBC drivers are installed on your Windows system, see 

.

Some common JDBC drivers include the i-net JDBC drivers for Microsoft SQL Server 
databases, the Oracle Thin driver for Oracle databases, and the JDBC Driver for DB2 for 
IBM DB2 databases. For more information on JDBC drivers and their vendors, see the 
searchable database of JDBC drivers on the Sun website at 

.

Here are the database interfaces for each type of web application and some common database 
drivers for each:

NO

TE

Install MDAC 2.5 first, then install MDAC 2.7.

Web application

Database interface

Common drivers

ColdFusion
JSP

JDBC

ColdFusion native drivers
Sun JDBC-ODBC driver
Oracle Thin JDBC driver

ASP

ODBC or OLE DB

Microsoft Access Driver
Microsoft SQL Server Provider 
Microsoft ODBC for Oracle 

ASP.NET

OLE DB

Microsoft Jet Provider
Microsoft SQL Server Provider 
Microsoft Oracle provider 

PHP

MySQL specific

MySQL driver