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