Updating excel data with dsn less connection vba
Her most recent book is "Mastering Microsoft SQL Server 2005 Express," with Mike Gunderloy, published by Sybex.
Other collaborations with Mike Gunderloy are "Automating Microsoft Access 2003 with VBA," "Upgrader's Guide to Microsoft Office System 2003," "ICDL Exam Cram 2," and "Absolute Beginner's Guide to Microsoft Access 2003" all by Que.
I'm not suggesting that administrators move all their connections to DSN, so don't light those torches just yet.
A developer of any worth at all has no more trouble creating a connection string, but this sensible DSN solution is for the lone wolves who don't have the technical resources some of us take for granted. You must know all the numbers and their sequence to spring the lock.
If you're lucky, someone in your organization can provide the correct connection string.For instance, the following code opens a connection to a local copy of using an ADODB Connection object: The name of a DSN is much easier to remember than all the keywords and possible values that compose a connection string.Whether you're a developer or just trying to get your work done, a DSN is easier to use.Simply put, a DSN is a shortcut to and a way into a data source.(Although you can use a DSN with the Web, OLE DB is the preferred method for working with database connections via the Web.) To create a DSN (using Windows XP) follow these steps: To create a system connection that's available to all users, click the System DSN tab.