Skip to Main Content
Adobe® Dreamweaver® CS4 Bible
book

Adobe® Dreamweaver® CS4 Bible

by Joseph Lowery
March 2009
Beginner to intermediate content levelBeginner to intermediate
1321 pages
46h 24m
English
Wiley
Content preview from Adobe® Dreamweaver® CS4 Bible
734
Part IV
Incorporating Dynamic Data
A DSN-less connection uses the same driver as a DSN connection, but without relying on the defini-
tion of a Data Source Name. The syntax of a DSN-less connection varies for each type of database,
but basically has five parts:
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.
Driver
—The proper name of the driver as listed in the ODBC Data Source Administrator.
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.
Username
—The username, if any, required for access to the data source. This element is
often abbreviated
UID in a connection string.
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.mdb:
Provider=MSDASQL;Driver={Microsoft Access Driver i
(*.mdb)};DBQ=c:\clients\dba\data\dbaEvents.mdb;UID=jlowery;PWD=hoosier7;
If the same data source were in SQL Server format (on a server named euripedes), the DSN-le ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Adobe® Dreamweaver® CS5 Bible

Adobe® Dreamweaver® CS5 Bible

Joseph W. Lowery
Dreamweaver® CS3 Bible

Dreamweaver® CS3 Bible

Joseph W. Lowery

Publisher Resources

ISBN: 9780470382523Purchase book