asp 怎样连接 oracle 数据库???????? - 编程论坛

#2

pyzheng2004-12-15 12:45

ASP好象说到这些吧？？？？？？？？老大

#3

harry_rgj2005-08-25 13:22

set conn = server.CreateObject("adodb.connection") strcnn="Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=*****;Password=******;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.5)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=oemrep)))" conn.open strcnn<% set conn = server.CreateObject("adodb.connection") strcnn="Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=system;Password=82901262;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.5)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=oemrep)))" conn.open strcnn%><% set conn = server.CreateObject("adodb.connection") strcnn="Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=system;Password=82901262;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.5)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=oemrep)))" conn.open strcnn%><% set conn = server.CreateObject("adodb.connection") strcnn="Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=system;Password=82901262;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.5)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=oemrep)))" conn.open strcnn%><% set conn = server.CreateObject("adodb.connection") strcnn="Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=system;Password=82901262;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.5)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=oemrep)))" conn.open strcnn%>

#4

harry_rgj2005-08-25 13:25

set conn = server.CreateObject("adodb.connection")
strcnn="Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=system;Password=82901262;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.5)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=oemrep)))"
conn.open strcnn