ASP developers can bypass all these potential headaches in Dreamweaver by using a DSN-less connection.
A DSN-less connection uses the same driver as a DSN connection, but without relying on the definition of a
Data Source Name. The syntax of a DSN-less connection varies for each type of database, but basically has
five parts:
n Provider: The underlying mechanism that connects the ODBC driver to the application. For
ODBC drivers, the provider is MSDASQL; because the provider is always the same for ODBC, the
entry is optional in a connection string and understood if omitted.
n Driver: The proper name of the driver as listed in the ODBC Data Source Administrator.
n Path to data source: Typically, this full path to a database is called the DBQ; however, with some
data sources, such as Oracle and SQL Server, this parameter appears in two parts, listing both the
server and the database name.
653
Establishing Connections and Recordsets 19
n Username: The username, if any, required for access to the data source. This element is often
abbreviated UID in a connection string.
n Password: The password, if any, required for access to the data source. This element is often
abbreviated PWD in a connection string.
Here??™s an example of a DSN-less connection string to an Access database named dbaEvents.
Pages:
1136
1137
1138
1139
1140
1141
1142
1143
1144
1145
1146
1147
1148
1149
1150
1151
1152
1153
1154
1155
1156
1157
1158
1159
1160