[AccessD] SQL Server Connect Strings

Stuart ...

Thanks for the replies.
I hadn't thought of having to create a DSN on all the pc's that would run
the FE application. Using a DSN-less connection in the FE is definitely the
way to go.

Thanks,
Patty

Date: Thu, 03 Mar 2011 06:59:10 +1000
From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
To: Access Developers discussion and problem solving
       <accessd at databaseadvisors.com>
Subject: Re: [AccessD] SQL Server Connect strings
Message-ID: <4D6EAF9E.15472.21645AAC at stuart.lexacorp.com.pg>
Content-Type: text/plain; charset=US-ASCII

I always use full DSN-less connection strings for portability of the
application.    No need to
worry about whether the DSN is present on every workstation and it's easy to
change in an
update to the FE if you need to change your connection ( say been a live and
a training BE
database).

(A very common typo in the interent age, it's DSN (data source name) not DNS
( domain
name system)

--
Stuart