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

long 发表于 2004-10-31 11:08

asp 怎样连接 oracle 数据库????????

<P>set conn=server.createobject("adodb.connection")
conn.cursorlocation=adUseClient
DSNTemp="Provider=MSDAORA.1;Password=xxxxx;User ID=yanhang;Data Source=xxx.world"
conn.open DSNtemp
</P>
<P>adUseClient  :  代表什么????
MSDAORA   :  代表什么????
xxx.world  :  代表什么????
</P>

pyzheng 发表于 2004-12-15 12:45

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

harry_rgj 发表于 2005-8-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%>

harry_rgj 发表于 2005-8-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

查看完整版本: asp 怎样连接 oracle 数据库????????