记录下几种常见的数据库连接字符串,手打不容易,有帮助的话点个赞啊。
数据库类型 | 连接方式 | 连接字符串 |
---|---|---|
Access | ODBC | “Driver={Microsoft Access Driver(*.mdb)}; Dbq=<\mdb file>; Uid=<\user name>; Pwd=<\password>;” |
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>;” |
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>;” |
还可以使用以下方法:
新建一个txt文件,重命名为.x.udl
。双击运行后会出现选项卡,根据选项卡选择相应的数据库,然后填写相应的选项,最后点击测试连接,成功后编辑文件就会出现相应的连接字符串。