A quick to construct OLE DB or ODBC connection strings on Windows is through Universal Data Link or .UDL files. Create an empty file with a .UDL extension. Then open it, which will bring up a nice UI for configuring the data source. When finished, the file will contain the appropriate connection parameters.