记录下几种常见的数据库连接字符串。
数据库类型连接方式连接字符串AccessODBC“Driver={Microsoft Access Driver(*.mdb)}; Dbq=; Uid=; Pwd=;”(Dbq:DataBase Query)AccessOLEDB“Provider=Microsoft.Jet.OLEDB4.0; Data Source=; User Id=; Password=”SQL ServerODBC“Driver={SQL Server}; Server=; Database= Uid=; Pwd=;”SQL ServerOLEDB“Provider=SQLOLEDB; Data Source=; Initial Catalog=; Integrated Security=SSPI; User Id=; Password=;”(Data Source:数据源,指数据库所在服务器)MySqlODBC“Draver={mySQL}; Server=; Option=16384; Database=; Uid=; Pwd=;”MySqlOLEDB“Provider=MySQLProv; Data Source=; User Id=; Password=;”OracleODBC“Driver={Microsoft ODBC for Oracle}; Server=OracleServer.world; Uid=; Pwd=;”OracleOLEDB“Provider=OraOLEDB.Oracle; Data Source= User Id=; Password=;”转自:常见的数据库连接字符串_colincpp的博客-CSDN博客_数据库连接字符串