常见的数据库连接字符串
记录下几种常见的数据库连接字符串。数据库类型连接方式连接字符串AccessODBC“Driver={Microsoft Access Driver(*.mdb)}; Dbq=<\mdb file>; Uid=<\user name>; Pwd=<\password>;”(Dbq:DataBase Query)AccessOLEDB“Provider=Micros
·
记录下几种常见的数据库连接字符串。
数据库类型 | 连接方式 | 连接字符串 |
---|---|---|
Access | ODBC | “Driver={Microsoft Access Driver(*.mdb)}; Dbq=<\mdb file>; Uid=<\user name>; Pwd=<\password>;”(Dbq:DataBase Query) |
Access | OLEDB | “Provider=Microsoft.Jet.OLEDB4.0; Data Source=<\mdb file>; User Id=<\user name>; Password=<\password>” |
SQL Server | ODBC | “Driver={SQL Server}; Server=<\server name>; Database=<\database name> Uid=<\user name>; Pwd=<\password>;” |
SQL Server | OLEDB | “Provider=SQLOLEDB; Data Source=<\server name>; Initial Catalog=<\database name>; Integrated Security=SSPI; User Id=<\user name>; Password=<\password>;”(Data Source:数据源,指数据库所在服务器) |
MySql | ODBC | “Draver={mySQL}; Server=<\server name>; Option=16384; Database=<\database name>; Uid=<\user name>; Pwd=<\password>;” |
MySql | OLEDB | “Provider=MySQLProv; Data Source=<\database name>; User Id=<\user name>; Password=<\password>;” |
Oracle | ODBC | “Driver={Microsoft ODBC for Oracle}; Server=OracleServer.world; Uid=<\user name>; Pwd=<\password>;” |
Oracle | OLEDB | “Provider=OraOLEDB.Oracle; Data Source=<\database name> User Id=<\user name>; Password=<\password>;” |
更多推荐
已为社区贡献4条内容
所有评论(0)