在线几等关于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) ) )