时间: 2021-08-13 作者:daque
办法:
1. 复制文献
2. 树立情况变量oracle_home, nls_lang, tns_admin
3. 将安置目次介入path
3. 编纂tnsnames.ora
pb代码示例:
// profile
sqlca.dbms = "o10 oracle10g (10.1.0)"
sqlca.logpass = "db_password"
sqlca.servername = "tnsname"
sqlca.logid = "db_username"
sqlca.autocommit = false
sqlca.dbparm = "pbcatalogowner='db_username'"
便宜: instantclient 解压后,摆设path情况变量和tnsnames.ora/sqlnet.ora文献即可运用, 不需安置oracle存户端.
2. 运用odac组件,即oracle数据考察组件,来供给oracle for ado.net的功效;
pb代码示例:
// profile
sqlca.dbms = "ado.net"
sqlca.logpass = "db_password"
sqlca.logid = "db_username"
sqlca.autocommit = false
sqlca.dbparm = "namespace='oracle.dataaccess.client',database='db_username',datasource='tnsname',adorelease='10.1.0.301',pbcatalogowner='db_username'"
便宜: 不妨运用到.net framework2.0中的数据库贯穿缓冲池(和j2ee运用效劳器中表露处置数据库贯穿缓冲各别,.net framework2.0中的数据库贯穿缓冲池是机动处置的),使贯穿到数据库上的物理贯穿数大大缩小,进而减少数据库的压力.