日期:2014-05-17  浏览次数:20988 次

在线几等关于asp连接oracle的代码
在线几等关于asp连接oracle的代码

------解决方案--------------------
http://www.isstudy.com/asp/259.html
------解决方案--------------------
http://topic.csdn.net/t/20030822/15/2177610.html
------解决方案--------------------
orclProvider="OraOLEDB.Oracle"
orclDataSource="ORCL" 
orclUserId="1" 
orclPassword="1" 
odns="Provider="&orclProvider&";Data Source="&orclDataSource&";User Id="&orclUserId&";Password="&orclPassword&";Persist Security Info=True"
set aConn=server.CreateObject("adodb.connection")
aConn.open odns 
'1.连接到ORACLE的WEB服务器上必须安装有ORACLE客户端。 
'2.在控制面板的odbc建连接源,在oracle的目录下的tnsnames文件配好连接串 假设远端服务器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) ) )