-r <repo> 
-s <connection_type> 
-n <connection_name>
[{-u <user_name>
[-p <password> | 
-P <password_environment_variable>]}| 
-K <connection_to_the_Kerberos_server>] 
[-c <connect_string> (required for Oracle, Informix, DB2, Microsoft SQL Server, ODBC, and NetezzaRelational)] 
[-l <code_page>] 
[-r <rollback_segment> (valid for Oracle connection only)] 
[-e <connection_environment_SQL>] 
[-f <transaction_environment_SQL>] 
[-z <packet_size> (valid for Sybase ASE and MS SQL Server connection)]
[-b <database_name> (valid for Sybase ASE, Teradata and MS SQL Server connection)] 
[-v <server_name> (valid for Sybase ASE and MS SQL Server connection)] 
[-d <domain_name> (valid for MS SQL Server connection only)] 
[-t (enable trusted connection, valid for MS SQL Server connection only)] 
[-x (enable advanced security, lets users give Read, Write and Execute permissions only for themselves.)]
[-k <connection_attributes> (attributes have the format name=value;name=value; and so on)] 
[-y (Provider Type (1 for ODBC and 2 for OLEDB), valid for MS SQL Server connection only)] 
[-m (UseDSN, valid for MS SQL Server connection only)] 
	  

Set the value to 1 if you want to use the ODBC provider type. Default is 1.
Set the value to 2 if you want to use the OLE DB provider type.