以下为用C#连接Oracle、postgres数据库的字符串:
1. 连接oracle的字符串
sourceOraConnString = "User Id=***;password=***;Server=***;Direct=True;Service Name=***;Persist Security Info=True";
//说明:其中id表示用户名;password表示密码;server表示ip地址,可以写成如127.0.0.1;Service Name表示服务名,一般默认orcl。
private OracleConnectionOraConnector()
{
if(null ==this.m_oraSourConnection)
this.m_oraSourConnection=newOracleConnection(sourceOraConnString);
if(this.m_oraSourConnection.State != System.Data.ConnectionState.Open)
this.m_oraSourConnection.Open();
returnthis.m_oraSourConnection;
}
privatevoid OraClose(OracleConnectionoraConn,OracleDataReader reader)
{
if(null != reader)
reader.Close();
if (null!= oraConn)
oraConn.Close();
}
protectedvoid UpdateWellInfo(string sql)
{
OracleConnection oraConn =null;
OracleDataReader reader =null;
try
{
oraConn = OraConnector();