Connection strings for Oracle

ODBC
  • Driver={Microsoft ODBC for Oracle};Server=MyServer.world;Uid=MyName;Pwd=MyPwd;
  • Driver={Microsoft ODBC Driver for Oracle};ConnectString=MyServer.world;Uid=MyName;Pwd=MyPwd;
OLE DB, OleDbConnection (.NET)
  • 复制到剪贴板标准连接(Standard Security):Microsoft的格式
    Provider=msdaora.1;Data Source=MyOracleDB;User Id=UserName;Password=asdasd;
  • 复制到剪贴板标准连接(Standard Security):Oracle的格式
    Provider=OraOLEDB.Oracle.1;Data Source=MyOracleDB;User Id=Username;Password=asdasd;
  • 复制到剪贴板信任连接(Trusted Connection)
    Provider=OraOLEDB.Oracle.1;Data Source=MyOracleDB;OSAuthent=1;
  • Provider=OraOLEDB.Oracle.1;Data Source=MyOracleDB;User Id=/;Password=;
OracleConnection (.NET)
  • 复制到剪贴板标准连接(Standard Security)
    Data Source=MyOracleDB;Integrated Security=yes;
    说明:此写法用于Oracle 8i release 3及以上版本
  • 复制到剪贴板指定用户名和密码
    Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;
    说明:此写法用于Oracle 8i release 3及以上版本
    如果您丢失了System.Data.OracleClient命名空间,可在此下载.Net Managed Provider for Oracle
Data Shape
  • 复制到剪贴板MS Data Shape
    Provider=MSDataShape.1;Persist Security Info=False;Data Provider=MSDAORA;Data Source=orac;
    user id=MyName;password=MyPwd

©2009 vhalpha#163.com 鲁ICP备09080449号