DB API for ADO/DAO?

[Jimmy Retzlaff]

Steve Holden (sholden at holdenweb.com) wrote:
> "John Burton" <john.burton at jbmail.com> wrote in message
...
>> The problem with odbc is that you need to manually set up data
sources
>> using the control panel which isn't something I want the users to
have
>> to do.
...
>As well as the other responses pointing you to ADO code, also note that
>mxODBC allows you to use DSN-less data sources.
...
>     DriverConnect('FILEDSN=test.dsn;UID=test;PWD=test')
>
>This is sometimes useful when you want to dynamically setup a data
source,
>e.g. a MS Access database."""

The current version of the win32all ODBC driver has this same
capability. It is spelled:

odbc('FILEDSN=test.dsn;UID=test;PWD=test')

To connect to the master database of SQL Server on the same machine:

odbc('Driver={SQL
Server};Server=(local);Database=master;UID=test;PWD=test')

Jimmy