[AccessD] SQL Server Connect strings

Jim Lawrence accessd at shaw.ca
Wed Mar 2 12:55:56 CST 2011


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




More information about the AccessD mailing list