ADO 连接字串一网打尽ODBC DSNLess Connections:MS Access ODBC DSNless connectionDriver={Microsoft Access Driver (*.mdb)};Dbq=c:\somepath\dbname.mdb;Uid=Admin;Pwd=pass; dBase ODBC DSNless connectionDriver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=c:\somepath\dbname.dbf;Oracle ODBC DSNless connectionDriver={Microsoft ODBC for Oracle};Server=OracleServer.world;Uid=admin;Pwd=pass;MS SQL Server DSNless connectionDriver={SQL Server};Server=servername;Database=dbname;Uid=sa;Pwd=pass;MS Text Driver DSNless connectionDriver={Microsoft Text Driver (*.txt; *.csv)};Dbq=c:\somepath\;Extensions=asc,csv,tab,txt;Persist Security Info=False;Visual Foxpro DSNless connectionDriver={Microsoft Visual FoxPro Driver};SourceType=DBC;SourceDB=c:\somepath\dbname.dbc;Exclusive=No;MySQL DSNless connectiondriver={mysql}; database=yourdatabase;server=yourserver;uid=username;pwd=password;option=16386;OLE DB Connections:MS Access OLE DB connection Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\somepath\dbname.mdb;User Id=admin;Password=pass; Oracle OLE DB connectionProvider=OraOLEDB.Oracle;Data Source=dbname;User Id=admin;Password=pass;MS SQL Server OLE DB connectionProvider=SQLOLEDB;Data Source=machineName;Initial Catalog=dbname;User ID=sa;Password=pass;MS SQL Server OLE DB connection using an IP addressProvider=SQLOLEDB; Data Source=xx.xx.xx.xx,1433; Network Library=DBMSSOCN; Initial Catalog=dbname;User ID=sa;Password=pass;MS Text Driver OLE DB connection"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\yourpath;Extended Properties='text;FMT=Delimited'"
语法支持标准SQL~
dBase ODBC DSNless connectionDriver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=c:\somepath\dbname.dbf;Oracle ODBC DSNless connectionDriver={Microsoft ODBC for Oracle};Server=OracleServer.world;Uid=admin;Pwd=pass;MS SQL Server DSNless connectionDriver={SQL Server};Server=servername;Database=dbname;Uid=sa;Pwd=pass;MS Text Driver DSNless connectionDriver={Microsoft Text Driver (*.txt; *.csv)};Dbq=c:\somepath\;Extensions=asc,csv,tab,txt;Persist Security Info=False;Visual Foxpro DSNless connectionDriver={Microsoft Visual FoxPro Driver};SourceType=DBC;SourceDB=c:\somepath\dbname.dbc;Exclusive=No;MySQL DSNless connectiondriver={mysql}; database=yourdatabase;server=yourserver;uid=username;pwd=password;option=16386;OLE DB Connections:MS Access OLE DB connection Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\somepath\dbname.mdb;User Id=admin;Password=pass; Oracle OLE DB connectionProvider=OraOLEDB.Oracle;Data Source=dbname;User Id=admin;Password=pass;MS SQL Server OLE DB connectionProvider=SQLOLEDB;Data Source=machineName;Initial Catalog=dbname;User ID=sa;Password=pass;MS SQL Server OLE DB connection using an IP addressProvider=SQLOLEDB; Data Source=xx.xx.xx.xx,1433; Network Library=DBMSSOCN; Initial Catalog=dbname;User ID=sa;Password=pass;MS Text Driver OLE DB connection"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\yourpath;Extended Properties='text;FMT=Delimited'"
string ConnStr = "Data Source=oradata;User Id=water;Password=water;Integrated curity=no;";
SelectStr= "SELECT * From TABNAME";
OracleConnection objconn = new OracleConnection (ConnStr);
objconn.Open ();