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