Here are some sample connection strings to get you started:
MS Access
ODBC - "Driver={Microsoft Access Driver (*.mdb)}Dbq=\\NAS1\yourhomedirectory\data\yourdatabase.mdb Uid=Admin Pwd="
OLE DB - "Provider=Microsoft.Jet.OLEDB.4.0Data Source=\\NAS1\yourhomedirectory\data\yourdatabase.mdb User ID=admin Password="
SQL Server
OLE DB - "Data Source=sqlx.pacificonline.com Initial Catalog=SQLXABC123 User ID= SQLXABC123 Password=sqlpassword"
http://www.connectionstrings.com/ is an excellent site that has links to just about every connection string possible.
Article ID: 42, Created: November 8, 2015 at 4:11 PM, Modified: July 14, 2016 at 4:06 PM