利用asp连接远端Oracle数据库方法!
网络整理 - 09-01
首先在Oracle安装目录下networkADMIN文件夾下找到tnsnames.ora設置。如配置如下(SERVICE_NAME要注明清楚,8i以下版本是SID)︰假设远端服务器IP是:192.168.1.12
数据库名称是:Data
修改配置文件:
SVN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.12)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = Data)
)
)
连接方法:
set oracleconn = server.Createobject("adodb.connection")
oracleconn.open "Provider=OraOLEDB.Oracle;Data Source=SVN;User Id=system;Password=manager;"