Re: Connection object question


"Edward Diener" <eddielee_no_spam_here@xxxxxxxxxxxxxx> wrote in message
news:uLJfReeYFHA.3184@xxxxxxxxxxxxxxxxxxxxxxx
> Does the connection object define the connection to a single data source,
> ie. database, or to a server in general ?

Depends on the provider, for many of the less-functional back-ends, there
really is no "server" to speak of, only a host file system, and driver
modules on the clients. For those providers that do implement actual server
processes running on the host, it is a connection to the server. With SQL
Server, there is a designated default database, but you can reference any
database to which the connection has permissions from a single connection,
by either using 3-part names, or changing the DefaultDatabase property.

> I believe the former. The reason I ask is that if I set the Mode to
> adModeShareExclusive, I do not want to prevent other connections to the
> same server but a different database.

That would depend upon the provider as well, I believe adModeShareExclusive
is only supported by "file-based" providers, that rely on the host file
system to mitigate concurrency issues. (Examples of these are Jet and
FoxPro.)

SQL Server, for instance, returns Error #-2147217887: Provider does not
support the property.


-Mark


.

Relevant Pages

  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Complicated Connection Problems bewteen ADP and SQL Server
    ... This database ... expertise for getting the user workstations talking to the SQL Server. ... connection would fail and the adp wouldn't be able to talk to the server. ... might be in my ADO connection string. ...
    (microsoft.public.access.adp.sqlserver)
  • Complicated Connection Problem between ADP and SQL Server
    ... This database ... expertise for getting the user workstations talking to the SQL Server. ... connection would fail and the adp wouldn't be able to talk to the server. ... might be in my ADO connection string. ...
    (microsoft.public.sqlserver.connect)
  • Re: ADO Connection Timeout
    ... so what happens when a connection failure forces one station to revert ... to a local database? ... Further, you *will* have contention issues, Jet does not support record ... to the central server, but you are willing to live with periods where it ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... When the first test is run, the results are stored in the central database. ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)