学习型 ASP/PHP/ASP.NET 主机 30元/年全能 ASP/PHP/ASP.NET 主机,支持月付专业 MSSQL 数据库空间,支持月付专业 MySQL 数据库空间,支持月付
发新话题
打印

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

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

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

adUseClient : 代表什么???? MSDAORA : 代表什么???? xxx.world : 代表什么????

TOP

ASP好象说到这些吧????????老大
-----------人間太苦﹐成仙太難------------

TOP

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%>

TOP

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

TOP

发新话题