How do I connect to the Microsoft Access database using a DSN-less connection?
A DSN-less connection is a method of connecting to a database without specifying a named data source. DSN-less connections don’t require the creation of an ODBC DSN. Instead of relying on information stored in a file or in the system registry (as DSN connections do), DSN-less connections specify the driver name and all driver-specific information in the connection string. Because a DSN-less connection is essentially “hard-coded” to use a certain driver, user identity and database location, problems may arise when database parameters change. Because the variety of connection parameters can differ greatly from one ODBC data source drive to another, it is recommended that you use a DSN whenever possible.
