I just found a very cool site called ConnectionStrings.com (I found it on the .Text Basic Configuration web page.) This site provides examples of connection strings for all of the following including subsets of each:
- SQL Server
- Access
- Oracle
- MySQL
- Interbase
- IBM DB2
- Sybase
- Informix
- Mimer SQL
- PostgreSQL
- DSN
- Excel
- Text
- DBF/FoxPro
- Visual FoxPro
- Pervasive
- UDL
Almost never should you be at a loss for how to format a connection string again! High recommended.