How to generate an ADO Connection String

For database connections in UltraDev you often need to supply an ADo Connection String. Here is a tip how to generate such string very easily.
(Windows only)

1. Go to your desktop
2. Right click and choose NEW/Microsoft Data Link - if you don't have this option on your menu, just choose NEW/Text Document
3. If you have make a new text file - change the file extension from .txt to .udl
4. Double click on the new file - you will see now the Microsoft Connection wizard (Data Link Properties)
5. Choose your database driver and connection properties
6. Test the connection
7. Choose OK to save the file
8. Now click on the Start Menu (button) and choose Run...
9. Type WRITE (or Notepad)
10. Drag the file from your desktop just behind the command that you type on step 9 - you will see the file name and path appear just after WRITE
11. Run the command - you will see now the text editor started with your connection file open in it. It is all text
12. Select and copy the line after the comment "; Everything after this line is ..."
13. This you your ADO connection string! You can use this in UltraDev now! Just paste it into UltraDev connection dialog.

That's it - have fun!