Creation of connection object

A connection string combines all the information your web application needs to connect to a database. Dreamweaver inserts this string in your page?s server-side scripts for later processing by your application server.
A connection string for Microsoft Access and SQL Server databases consists of a combination of the following parameters separated by semicolons:
Provider specifies the OLE DB provider for your database. For example, here is parameter for Access:

Provider=Microsoft.Jet.OLEDB.4.0;

For the parameter value of your OLE DB provider, see your provider vendor?s documentation, or consult your system administrator.

Here?s an example of a connection string that will create an ODBC connection to an Access database called trees.mdb:

Driver={Microsoft Access Driver (*.mdb)};
DBQ=C:\Inetpub\wwwroot\Research\trees.mdb

Here?s an example of a connection string that will create an OLE DB connection to a SQL Server database called Mothra located on a server called Gojira:

Provider=SQLOLEDB;Server=Gojira;Database=Mothra;UID=jsmith;
PWD=orlando8