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