[AccessD] Linked to SQL Server in a domain

Jim Lawrence accessd at shaw.ca
Fri May 22 13:49:58 CDT 2009


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




More information about the AccessD mailing list