[AccessD] Linked to SQL Server in a domain

Very cool.  Thanks for the tip.

Rusty 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Friday, May 22, 2009 1:50 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Linked to SQL Server in a domain

Everyone may already know this little trick for connecting to a MS SQL DB
but if not it might prove useful:

1. <Right-mouse-click> on your desktop, select New and then select Text
Document.
2. Rename the text to anything with a 'UDL' extension. Example: text.udl 3.
Now open the new file and you will see an ODBC template for filling out.
4. Just fill the fields out and test until a connection with your MS SQL or
a variety of other DBs for that matter, is established.
5. When completed you can then rename the file text.udl back to text.txt and
you have a complete list of tried and tested connection strings suitable for
use in your code.

Hope this helps someone.
Jim

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

**********************************************************************
WARNING: All e-mail sent to and from this address will be received,
scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc.
corporate e-mail system and is subject to archival, monitoring or review 
by, and/or disclosure to, someone other than the recipient.
**********************************************************************