delphi ADO 连接数据库

Question

delphi ADO 可以连接哪几种类型的数据库，他们的connectString分别是什么？

Answer 1

正常来讲是数据库都能连接，connectString网上到处都是
有些驱动内置了或者系统内置了 比如 access sqlserver等
有些使用ADO需要数据库客户端比如 oracle等

Answer 2

...
      case ADODBType of
        ado_dtMSSQL: begin
          ADOConn.ConnectionString := 'DistribTX=0;Provider=SQLOLEDB.1;'
                                    + 'Persist Security Info=True;'
                                    + 'User ID=' + sUser + ';'
                                    + 'Initial Catalog=' + sDbName + ';'
                                    + 'Data Source=' + sServerip + ';';
        end;
        ado_dtOracle: begin
          ADOConn.ConnectionString :=   'PLSQLRSet=1;DistribTX=0;Provider=OraOLEDB.Oracle.1;'
                                      + 'Persist Security Info = True;'
                                      + 'Data Source=' + sServerip + ';'
                                      + 'User ID=' + sUser + ';'
                                      + 'Password =''' + Trim(sPass) + '''';
        end;
        ado_dtDB2: begin
          ADOConn.ConnectionString :=   'Provider=IBMDADB2;'
                                      + 'Persist Security Info=True;'
                                      + 'Location=' + sServerip + ';'
                                      + 'User ID=' + sUser + ';'
                                      + 'Data Source=' + sDbName + ';'
                                      + 'Password=' +sPass
                                      ;
        end
        else
          Exit;
      end;
...