各种各样数据库连接标准写法

Oracle数据库的连接方法

标准写法
Data Source=MyOracleDB;Integrated Security=yes; 
Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;Integrated Security=no;  
SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort))(CONNECT_DATA=(SERVICE_NAME=MyOracleSID)));uid=myUsername;pwd=myPassword;
Data Source=myOracleDB;User Id=SYS;Password=SYS;DBA Privilege=SYSOPER;

  

SQLServer连接方式

Server=myServerName,myPortNumber;Database=myDataBase;User Id=myUsername;Password=myPassword;  
Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;
Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;

  

  

https://www.connectionstrings.com/ 最详细的网站

 

posted @ 2021-08-12 14:39  dafengchui  阅读(91)  评论(0)    收藏  举报