DSN-less Connections example string for some common databases:

Note: CPS Plus will save username/password, required to connect to database, 
in its internal properties file. This file may be fairly easily read so it is 
recommended that user used in this ODBC connection, has limited privileges! 
For example only write privilege for table used in this connection.
 
 

MS ACCESS

Driver={Microsoft Access Driver (*.mdb)};Dbq=c:\myPath\myDb.mdb;Exclusive=0;Uid=Admin;Pwd=;
 

MS Excel

Driver={Microsoft Excel Driver (*.xls)};Driverid=790; ;FIRSTROWHASNAMES=1;READONLY=FALSE;Dbq=C:\MyPath\ExcelFile.xls;DefaultDir=C:\MyPath;
 

Microsoft SQL Server

Driver={SQL Server};Server=ServerName;DataBase=DataBaseName;Uid=UserName;Pwd=Password;
Or
Driver={SQL Server}; Server=xxx.xxx.xxx.xxx;Address=xxx.xxx.xxx.xxx,1433;Network=DBMSSOCN;Database=myDatabaseName;Uid=myUsername;
 
 

Microsoft SQL Server Express

Note: Connection to SQLEXPRESS may fail if SQL Browser service is not running. Make sure that SQL Browser and TCP/IP, NP protocols are enabled before attempting connection.
 
DRIVER={SQL Server};SERVER= MYSQLEXPRESSHOST\SQLEXPRESS;Database=MyDatabase;UID=myUsername;PWD= myPassword;
 
Replace MYSQLEXPRESSHOST with name of PC where SQL server is running and SQLEXPRESS should mach instance name.
 

Oracle

Microsoft ODBC for oracle:
Driver={Microsoft ODBC Driver for Oracle};ConnectString=OraServer;Uid=myUsername;Pwd=myPassword;
Or (OraServer defined in your TNSNAMES.ORA)
Driver={Microsoft ODBC Driver for Oracle};ConnectString= OraServer.world;Uid=myUsername;Pwd=myPassword;
 
Connecion without TNS names - all defined in connect string:
ODBC;Driver={Microsoft ODBC for Oracle};Server=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))(CONNECT_DATA=(SID=SidName)));Uid=myUsername;Pwd=myPassword;
 
Oracle ODBC Driver:
Driver={Oracle ODBC Driver};Dbq=myDBName;Uid=myUsername;Pwd=myPassword
 

Oracle XE

Driver=(Oracle in XEClient);dbq=127.0.0.1:1521/XE;Uid=myUsername;Pwd=myPassword;
 

MySQL  - MyODBC

Driver={mySQL};Server=db1.database.com;Port=3306;Option=131072;Stmt=;Database=mydb;Uid=root;Pwd=secret;
 

MySQL - ODBC 3.5.1

DRIVER={MySQL ODBC 3.51 Driver};SERVER=127.0.0.1;PORT=3306;DATABASE=myDatasbase;USER=user;PASSWORD=abc;OPTION=3;
 

AS/400 (from IBM)

Driver={Client Access ODBC Driver (32-bit)};System=myAS400;Uid=myUsername;Pwd=myPassword;
 

dBASE

Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=c:\somepath;
 
 

Other examples:

 
We recommend that you search for more examples and ODBC drivers on the official websites of database companies.There are numerous examples of DSN-less connection examples on the web.