[AccessD] Access and SQL Server

Jim Lawrence accessd at shaw.ca
Tue Mar 1 17:01:49 CST 2011


Hi Stuart:

I must have missed your point but it is a great article.

Jim


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Tuesday, March 01, 2011 1:46 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access and SQL Server

Guess SQL Server isn't a real SQL DB then.

MS had to build Service Broker, especially to assist with asynchronous
operations. 

http://msdn.microsoft.com/en-us/library/ms345113%28v=sql.90%29.aspx

<quote>
Summary: Microsoft SQL Server 2005 Service Broker is a new platform for
building 
distributed asynchronous database applications. Including an asynchronous,
reliable 
messaging feature in the SQL Server database makes it possible to build a
variety of 
database applications that were difficult, if not impossible, to build
before.
</quote>
  
Why is the default connection method to SQL Server synchronous?


-- 
Stuart

On 1 Mar 2011 at 8:41, Jim Lawrence wrote:

> Real SQL DBs are designed to be asynchronous. Just because you can
> work around its philosophy of design does not mean you should.
> 


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list