Re: Connection object question

Mark J. McGinty wrote:
"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.

Is there any way I can have a connection to an SQL Server database in exclusive mode ? If there was a way would this speed up changes to tables in that database ? Is there any connection mode which would be effective to speed up any changes when I know that no other connection will be accessing a particular database when my program does ?
.

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)