strConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;" & _ 
	"DATA SOURCE=C:\Databases\NorthWind.mdb;"

strConnectionString = "Provider=MSDASQL;Driver={SQL Server};" & _ 
	"Server=YOUR_SERVER_NAME;Database=YOUR_DATABASE;" & _ 
	"User ID=YOUR_USERNAME;Password=YOUR_PASSWORD;"

strConnectionString = "Provider=SQLNCLI;" & _ 
	"Server=YOUR_SERVER_IP;Database=YOUR_DATABASE;" & _
	"UID=YOUR_USERNAME;PWD=YOUR_PASSWORD;"

strConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};DESC=;" & _ 
	"DATABASE=YOUR_DATABASE;SERVER=YOUR_SERVER_NAME;" & _ 
	"UID=YOUR_USERNAME;PASSWORD=YOUR_PASSWORD;" &  _ 
	"PORT=;OPTION=0;STMT=;" 

strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ 
	"Data Source=C:\YOUR_FOLDER_PATH\;" & _ 
	"Extended Properties=""text;HDR=Yes;FMT=Delimited""" 

For Standard Security

strConnectionString = "Provider=OraOLEDB.Oracle;" & _
           "Data Source=MyOracleDB;" & _ 
           "User Id=myUsername;" & _
           "Password=myPassword"

For a Trusted Connection

strConnectionString = "Provider=OraOLEDB.Oracle;" & _
           "Data Source=MyOracleDB;" & _ 
           "User Id=/;" & _
           "Password="
' Or

strConnectionString = "Provider=OraOLEDB.Oracle;" & _
           "Data Source=MyOracleDB;" & _ 
           "OSAuthent=1"

Note: "Data Source=" must be set to the appropriate Net8 name which is known to the naming method in use. For example, for Local Naming, it is the alias in the tnsnames.ora file; for Oracle Names, it is the Net8 Service Name. 

For more information, see: Oracle Provider for OLE DB Developer's Guide

Using Database container (ODBC)

strConnectionString = "DRIVER={Microsoft Visual FoxPro Driver};" & _ 
	"SourceDB=C:\YOUR_FOLDER_PATH\YourDB.dbc;" & _ 
	"SourceType=DBC;Exclusive=No;" 

Using Database container (OLE DB)

strConnectionString = "Provider=VFPOLEDB.1;" & _ 
	"Data Source=C:\YOUR_FOLDER_PATH\YourDB.dbc;" & _ 
	"Password=YOUR_PASSWORD;Collating Sequence=MACHINE;"