[AccessD] SQL Server Connect strings

Stuart McLachlan stuart at lexacorp.com.pg
Wed Mar 2 15:02:49 CST 2011


A very useful reference.  I keep it bookmarked and it is my first point of call if I have anything 
out of the ordinary to connect to.

-- 
Stuart

On 2 Mar 2011 at 10:55, Jim Lawrence wrote:

> Hi Patty:
> 
> I am not sure this will answer you question but find a link to three
> different sites giving sample connection strings for various versions
> of MS SQL and some with explanations. (The list is half way down the
> page.)
> 
> http://www.databaseadvisors.com/reference/referencemisc.asp
> 
> HTH
> Jim
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Den Patrino
> Sent: Wednesday, March 02, 2011 9:47 AM To:
> AccessD at databaseadvisors.com Subject: [AccessD] SQL Server Connect
> strings
> 
> Members ...
> 
> It's nice to see some discussion on using Access with SQL Server. I've
> just started to experiment with Access as a FE and SQL Server as a BE.
> I'm a little confused about connection strings. Should one be using a
> DNS connection string or a DNS-less connection string.
> 
> Are there pros and cons to one or the other.
> 
> TIA
> Patty
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> -- 
> 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