According to this usage note, there's an old defect for CONNECT USING together with OLEDB access:
48877 - A pass-through connection invokes the Data Link Properties dialog box even though an assigne...
CONNECT USING was imoplemnted because it's conventient to avoid keeping connection information in many places. Also, this especially nice when you want to generete the connections dynamically in PROC SQL.